Business Intelligence Engineer

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.

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.
First American invests in its employees’ development and well-being, empowers them to provide superior customer service and encourages them to serve the communities where they live and work. First American is committed to diversity and inclusion. We are an equal opportunity employer.