Business Intelligence 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 DoWe are seeking a Business Intelligence Engineer with deep expertise in semantic modeling and Power BI reporting. This role bridges traditional data engineering with business-facing analytics, focusing on the design, optimization, and delivery of semantic models and reports within the Microsoft Fabric ecosystem. You will be a key driver of our migration to Microsoft Fabric and a subject matter expert in data modeling, ensuring high-performance, scalable, and well-governed data solutions.

HOW YOU’LL CONTRIBUTE

• Serve as the subject matter expert for semantic model development, optimization, and governance.
• Lead the design and implementation of Analysis Services style tabular models and Power BI datasets, supporting self-service and enterprise reporting needs, including automation where appropriate.
• Collaborate with business users, analysts, and other engineers to understand reporting requirements and translate them into performant data models.
• Monitor and tune semantic models for performance, including aggregations, DAX calculations, and relationships.
• Champion best practices in semantic model design, including star/snowflake schema use, calculation groups, and partitioning strategies.
• Implement deployment strategies and version control for semantic models and reports using tools like Fabric Git integration or Azure DevOps.
• Support source control and CI/CD workflows for semantic model and report deployment.
• Provide guidance on governance, dataset certification, and usage metrics across the Power BI ecosystem.
• Mentor team members in data modeling techniques, DAX, and effective Power BI usage.
• Troubleshoot complex model performance or report behavior issues.
• Develop and maintain robust Power BI reports and paginated reports with an emphasis on usability, performance, and consistency.

WHAT YOU’LL BRING

• Bachelor’s degree in Computer Science, Information Systems, Analytics, or a related field; or equivalent experience.
• 5–8 years of experience in data engineering, analytics, or BI development roles.
• Hands-on experience with semantic model development (Power BI, SSAS Tabular / Analysis Services).
• Experience with advanced features such as TMDL, partitioning / refreshes, etc.
• Deep understanding of DAX and the VertiPaq engine, with the ability to optimize complex measures and queries.
• Strong SQL and T-SQL skills, particularly for model sourcing and data validation.
• Experience with Power BI development (including paginated reports).
• Familiarity with Microsoft Fabric or modern cloud data platforms (Data Factory, Synapse, Lakehouses, OneLake).
• Experience with source control and deployment strategies for Power BI datasets and reports.
• A passion for data storytelling, usability, and empowering end users with high-quality models.
• Strong communication skills and the ability to bridge technical and business teams.
• Self-starter, team-oriented, and committed to continuous learning

SALARY RANGE

$93,350 - $127,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.