Power BI Developer & Data Model Lead

Talentify; Scottsdale (AZ); On-site; USD 90,000 - 130,000; Full time

Job summary

Troon's Corporate Office in Scottsdale, AZ is seeking a BI Developer to lead design, development, and delivery of Power BI reporting solutions and enterprise semantic models. The role focuses on end-to-end data transformation using Power Query and DAX, building reusable models, and ensuring data quality and governance across the reporting environment.

Youll partner with IT and business stakeholders to define data flows, optimize performance, and enable leadership with clear, actionable insights.

Qualifications

• 4+ years of BI, data analytics, or reporting-focused experience.
• Experience delivering Power BI reports and semantic models in production.
• Hands-on with DAX measures and Power Query transformations for complex reporting.
• Experience with data warehouses, cloud data platforms, or related sources is preferred.
• Knowledge of data governance and data quality concepts.

Responsibilities

• Design, develop, and maintain Power BI reports and dashboards meeting requirements for accuracy and usability.
• Build semantic models with relationships, calculated columns, measures, and row-level security.
• Develop and manage Power Query transformations to prepare analysis-ready data from multiple sources.
• Collaborate with data engineering, IT, and stakeholders to define source-to-report data flows and fix upstream issues.
• Define data quality rules, profiling standards, and validation checks for trustworthy data.
• Document data governance standards for the Power BI environment and access controls.
• Monitor and optimize health of published datasets and reports, including refresh schedules and gateways.
• Improve performance with query folding, aggregations, and efficient DAX patterns.
• Guide users on Power BI navigation, filtering, and metric interpretation.
• Present findings and recommendations to leadership in a clear, actionable manner.

Skills

DAX

Power Query

Power BI

SQL

Data quality

Governance

Education

Bachelor's degree in related field

Tools

Tabular Editor

DAX Studio

ALM Toolkit

Purview

Job description

Troon's Corporate Office in Scottsdale, AZ is seeking a BI Developer to lead design, development, and delivery of Power BI reporting solutions and enterprise semantic models. The role focuses on end-to-end data transformation using Power Query and DAX, building reusable models, and ensuring data quality and governance across the reporting environment.

Youll partner with IT and business stakeholders to define data flows, optimize performance, and enable leadership with clear, actionable insights.