Senior Data Engineer

Who We AreJoin a team that puts its People First! As a member of First American’s family of companies, First American Home Warranty offers a wide range of home warranty products and services to home sellers, buyers and agents. 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 DoThe Data Engineer is an expert in data technologies and plays a key role in the development and deployment of innovative data and analytics solutions. Directly supports the Business Intelligence & Analytics team with regard to data architecture, data pipelines, and data modeling. Works with functional teams and supports data analysts, report developers, and data scientists on data initiatives. Ensures that optimal data delivery architecture is consistent throughout ongoing projects.

What You'll Do

• Viewed as a data expert; drives innovation and plays a key role in the department.  Participates in highly visible initiatives that have broad impact.
• Identify, design, and implement internal process improvements: automate manual processes, optimize data delivery, re-design architecture for greater scalability.
• Design, update, and maintain data architecture including data warehouses, lakehouses, and semantic models.
• Create data pipelines to acquire, move, and transform data to support analytics initiatives.
• Serve as a subject matter expert on data architecture and make innovative recommendations including best practices and how to improve data reliability, efficiency, and quality.
• Serve as a mentor for other members of the team with regard to the data engineering domain.
• Troubleshoot and resolve a wide range of data issues.
• Required to perform duties outside of normal work hours based on business needs.

What You'll Bring

• Bachelor's degree in Computer Science, Information Systems, Informatics, or related field or equivalent combination of education and experience.
• Demonstrated expertise in data modeling, database maintenance, monitoring and performance tuning on SQL Server and NoSQL databases.
• Exceptional analytical skills analyzing large and complex data sets
• 5-8 years of directly related experience.
• Knowledge and experience conducting thorough testing and data validation to ensure the accuracy and efficiency of data transformations
• Experience working in Agile SDLC methodology
• Solid ability to build data pipelines (ETL & ELT) and data warehouses
• Ideally, experience with the process of deploying machine learning models in a production environment.
• Passion for continuous learning.
• Proficient with SQL and T-SQL
• Working knowledge of DAX Proficiency or working knowledge of python (specifically PySpark)
• Working knowledge/proficient with Microsoft data and analytics stack – ideally Fabric as a whole with a focus on SQL Server, Data Factory, Synapse, and Analysis Services / semantic models
• Strong written and verbal communication skills, with precise documentation
• Self-driven team player with ability to work independently and multi-task.
• Analytical, creative thinker and innovative problem solver

 Salary Range

$126,000 - 168,125

​

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

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.