Senior Analytics Engineer (Remote)
2 First American Way, Santa Ana, CA 92707, United States
Full Time Senior-level / Expert USD 126K - 193K
First American
First American Financial Corporation provides comprehensive title insurance protection and professional settlement services for homebuyers and sellers, real estate agents and brokers, mortgage lenders, commercial property professionals,...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 OfferBy 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.Tags: AWS Azure BigQuery Computer Science Databricks Data quality Data visualization dbt GCP Looker Power BI PySpark Python Redshift Snowflake SQL Tableau
Perks/benefits: 401(k) matching Equity / stock options Health care Medical leave
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.