Senior Analytics Engineer (Remote)

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

Job summary

First American is seeking a Senior Analytics Engineer to transform raw data into clean datasets ready for analysis. This remote role involves writing code in dbt Core and PySpark, ensuring data quality, and collaborating with teams to meet data needs. Join a company that values its people and fosters an inclusive culture.

Benefits

Comprehensive benefits package including medical, dental, vision

401k and 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 analysts.

Skills

SQL

Python

Data Modeling

Data Quality

Communication

Collaboration

Education

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

Tools

dbt Core

PySpark

Data Lake Platforms

Cloud Platforms

Job description

Senior Analytics Engineer (Remote) page is loaded

Senior Analytics Engineer (Remote)

Apply locations USA, California, Santa Ana time type Full time posted on Posted 2 Days Ago job requisition id R050737

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

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.

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

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.

Similar Jobs (1)

Senior Data Engineer (Remote)

locations USA, California, Santa Ana time type Full time posted on Posted 5 Days Ago

Our people are the foundation of First American’s success and that is the reason we put them first.

This philosophy has cultivated a culture of happy employees who are highly engaged, passionate about their work and leave each day feeling they have made a difference.

Privacy Policy

By submitting this application, you may convey certain personal information to First American. This information is collected for the sole purpose of determining your qualification for the position you are applying.

Notice Regarding LA County Fair Chance Ordinance