Company Summary

Come join First American’s Digital Title Group, newly formed to re-imagine and digitize the title search and examination process through Big Data, AI, document automation and modern, cloud-native application development. As a market leading title insurance company, powered by the nation’s largest and most complete property information, ownership and recorded document database, First American is committed to advancing title automation and removing friction from the real estate closing process. Our modern title decisioning solutions create certainty and speed through data and analytics, delivered to real estate agents, lenders, title agents and homebuyers. Join a team that puts its People First! Since 1889, First American (NYSE: FAF) has held an unwavering belief in its people. They are passionate about what they do, and we are equally passionate about fostering an environment where all feel welcome, supported, and empowered to be innovative and reach their full potential. Our inclusive, people-first culture has earned our company numerous accolades, including being named to the Fortune 100 Best Companies to Work For® list for seven consecutive years. We have also earned awards as a best place to work for women, diversity and LGBTQ+ employees, and have been included on more than 50 regional best places to work lists. First American will always strive to be a great place to work, for all. For more information, please visit www.careers.firstam.com.

Job Summary

Data Engineer (remote)

Summary

Come join First American’s Digital Title Group, newly formed to reimagine and digitize the title search and examination process through Big Data, AI, document automation and modern, cloud-native application development. 

As a market leading title insurance company, powered by the nation’s largest and most complete property information, ownership and recorded document database, First American is committed to advancing title automation and removing friction from the real estate closing process.

Our modern title decisioning solutions create certainty and speed through data and analytics, delivered to real estate agents, lenders, title agents and homebuyers. 

We’re looking for Data Engineers interested in transforming our industry by solving cutting-edge problems with modern technologies, want the benefit of working for an established real estate insurance leader and seek a culture awarded as a Fortune 100 Best Companies to Work.

What you’ll do

Design, develop and maintain scalable data pipelines, build out new API integrations for data transfer.

Perform data analysis required to troubleshoot data-related issues and assist in the resolution of data issues.

Collaborate with Analysts to understand upstream data assets

Own big data enrichment pipelines using AWS technologies like Glue, Pyspark and MWAA with data hosted in S3, Snowflake, and PostgreSQL

Develop locally, empowered by Docker and tools like VSCode, and DBeaver, Jupyter Notebook, GLUE interactive sessions.

Work with QA Engineers to create & maintain tests for CI/CD gates and ETL validation

Contribute beyond the data layer by developing application layer code in Python

Build resilient CI/CD alongside DevOps using GitHub Actions and Terraform

Consult with Architects and other data engineers to define and follow best practices

Knowledge and Skills

Must-have:

1-3 years of extensive ETL development experience using Pyspark/Glue on AWS

1-3 years of experience in CSV, JSON, Parquet file formats.

1-3 years of experience in S3, Athena, RDS, Glue catalogue, Cloud formation/Terraform

Experience with querying nested/JSON data stored in parquet files or tables.

Strong understanding of ETL/Data-pipelines/Big Data architecture

Strong Database/SQL experience in any RDBMS

Nice-to-have:

Experience in schema design, data ingestion experience on Snowflake (or equivalent MPP)

Experience in orchestrating data processing jobs using Step Function/Glue workflow/Apache Airflow (MWAA)

Experience in data analysis using Excel formulas, V lookups, pivot, slicers

​Education

Bachelor’s degree in Computer Science (or related field) or equivalent combination of education and experience

Typical Range of Experience

1-3 years of directly related experience

#LI-REMOTE

First American invests in its employees’ development and well-being, empowers them to provide superior customer service and encourages them to serve the communities where they live and work. First American is committed to diversity and inclusion. We are an equal opportunity employer.Based on eligibility, First American offers a comprehensive benefits package including medical, dental, vision, 401k, PTO/paid sick leave and other great benefits like an employee stock purchase plan.