Power BI Architect & Reporting Lead

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

Job summary

Troon’s Corporate Office, located in Scottsdale, Arizona, is seeking a BI Developer to lead Power BI reporting and semantic model development.

You will own end-to-end data transformation using Power Query and DAX, build reusable semantic models, and enforce data quality and governance standards across the reporting environment. You will partner with stakeholders to ensure reports are accurate and fit for purpose.

Qualifications

• 4+ years in BI, analytics or reporting roles.
• Proven experience delivering Power BI reports and semantic models.
• Hands-on experience with DAX and Power Query transformations.

Responsibilities

• Design, develop, and maintain Power BI reports and dashboards that meet business requirements for accuracy, performance, and usability
• Build and maintain Power BI semantic models, including table relationships, calculated columns, measures, and row-level security configurations
• Develop and manage Power Query data transformation logic to clean, reshape, and integrate data from multiple source systems into consistent datasets
• Partner with data engineering, IT, and business stakeholders to define source-to-report data flows and resolve upstream data issues
• Define and enforce data quality rules, profiling standards, and validation checks to ensure reports reflect accurate data
• Establish and document data governance standards for the Power BI environment, including dataset ownership, naming conventions, certification processes, and access controls
• Monitor and maintain the health of published datasets and reports in the Power BI service, including refresh schedules
• Optimize report and dataset performance through query folding, incremental refresh, aggregations, and efficient DAX patterns
• Provide guidance and enablement to report consumers on Power BI navigation and interpretation of metrics
• Present findings and recommendations to leadership clearly and concisely

Skills

Advanced DAX

Power Query

SQL

Power BI

Data modeling

Data governance

Documentation

Education

Bachelor’s degree in IT/CS

Tools

Tabular Editor

DAX Studio

Purview

Job description

Troon’s Corporate Office, located in Scottsdale, Arizona, is seeking a BI Developer to lead Power BI reporting and semantic model development.

You will own end-to-end data transformation using Power Query and DAX, build reusable semantic models, and enforce data quality and governance standards across the reporting environment. You will partner with stakeholders to ensure reports are accurate and fit for purpose.