Who We Are

Join 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 nine 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

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

HOW YOU’LL CONTRIBUTE

• 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.
• 5-8 years of directly related experience.
• Working experience building data pipelines (ETL & ELT) and data warehouses.
• Demonstrated expertise in data modeling, database maintenance, monitoring and performance tuning on SQL Server and NoSQL database.
• 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.
• Exceptional analytical skills analyzing large and complex data sets.
• Perform thorough testing and data validation to ensure the accuracy and efficiency of data transformations.
• 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.
• Experience working in Agile SDLC methodology
• Ideally, experience with the process of deploying machine learning models in a production environment.
• Proficient with SQL and T-SQL, DAX or python (specifically PySpark)

SALARY RANGE:

$114,625 - $191,025

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