Senior Analytics Engineer (Remote)

First American Financial Corp.; Santa Ana (CA); Remote; USD 126,000 - 194,000; Full time

Job summary

Join a leading company in the real estate industry as a Senior Analytics Engineer. You will transform raw data into clean datasets, maintain transformation code, and collaborate with teams to ensure data quality. This role offers a chance to make a significant impact in a people-first culture that values diversity and innovation.

Benefits

Comprehensive benefits package including medical, dental, vision

401k

PTO/paid sick leave

Employee stock purchase plan

Qualifications

• 5+ years working in SQL and experience with dbt Core.
• 4+ years programming in Python and proficiency with PySpark.
• Strong experience in data modeling and transforming raw data.

Responsibilities

• Transform bronze data into clean, well-modeled datasets.
• Write and maintain transformation code in dbt Core.
• Develop robust data models for data access and interpretation.

Skills

SQL

Python

Data Modeling

Data Quality

Communication

Collaboration

Education

Bachelor's degree in Computer Science, Data Science, or a related field

Tools

dbt Core

PySpark

Data Lake Platforms

Data Visualization Tools

Cloud Platforms

Job description

Who We Are

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 ten 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.

What We Do

**Remote Work Welcome** Be part of a transformative team that is shaping the way First American builds and delivers world-class technology products that fuel the real estate industry. We are looking for the best-of-the-best technology experts who will envision, design, build, and deliver innovative solutions that provide exceptional experiences and lasting value to our customers. We are looking for a Senior Analytics Engineer who is passionate about transforming raw data into clean, well-modeled datasets that are ready for analysis. This person will write and maintain transformation code in dbt Core and PySpark to ensure data quality and consistency across the organization. In this role, you will have the chance to make a big impact and drive efficiency across our organization.

What You’ll Do:

• Transform Data:Convert bronze data into clean, well-modeled datasets that are ready for analysis.

• Maintain Transformation Code:Write and maintain transformation code in dbt Core to ensure data quality and consistency.

• Create Data Models:Develop robust data models that enable data analysts and business users to easily access and interpret data.

• Ensure Data Quality:Ensure that data is reliable, well-documented, and ready to support data-driven decision-making.

• Collaborate:Work with data engineers, data analysts and business users to understand their data needs and provide the necessary datasets.

What You’ll Bring:

• Development Experience:5+ years working in SQL and experience with dbt Core.

• Python Development:4+ years programming in Python and proficiency with PySpark.

• Data Modeling:Strong experience in data modeling and transforming raw data into structured datasets.

• Data Quality:Experience ensuring data quality and consistency across large datasets.

• Communication & Collaboration:Strong communication skills and ability to collaborate with data analysts, business users, and other stakeholders to understand data needs and deliver solutions.

• Documentation:Ability to create and maintain comprehensive documentation for data models and transformation processes.

• Education:Bachelor's degree in Computer Science, Data Science, or a related field, or equivalent combination of education and experience.

Ideally, you will also have experience with:

• Experience with Data Lake Platforms:Experience with platforms such as Databricks, Snowflake, BigQuery, or RedShift.

• Data Visualization:Experience with data visualization tools such as Domo, Power BI, Tableau, or Looker.

• Cloud Platforms:Experience with cloud platforms such as Azure, AWS, or GCP.

Pay Range: $126,100 – $193,325 Annually

This hiring range is a reasonable estimate of the base pay range for this position at the time of posting. Pay is based on a number of factors which may include job-related knowledge, skills, experience, business requirements, and geographic location.

ST2

** Note that the following statements only apply to candidates who will be working from an unincorporated area within Los Angeles County. **

First American will consider for employment all qualified applicants, including those with arrest or conviction records, in a manner consistent with the requirements of applicable state and local laws (e.g., the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act).

First American intends to conduct a review of an applicant’s criminal history in connection with a conditional offer. First American reasonably believes that a criminal history may have a direct, adverse and negative relationship with the following material job duties for this position potentially resulting in the withdrawal of the conditional offer of employment: handling of confidential, proprietary or trade secret information belonging to First American or its customers, administrating or facilitating financial transactions, and the ability to meet customer-imposed criminal history requirements.

What We Offer

By choice, we don’t simply accept individuality – we embrace it, we support it, and we thrive on it! Our People First Culture celebrates diversity, equity and inclusion not simply because it’s the right thing to do, but also because it’s the key to our success. We are proud to foster an authentic and inclusive workplace For All. You are free and encouraged to bring your entire, unique self to work. First American is an equal opportunity employer in every sense of the term.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.