BI DeveloperTechnologyTroon HeadquartersN Scottsdale RdSuite Scottsdale, AZ moreJul

BI Developer

Troon's Corporate Office, located in Scottsdale, Arizona, is pleased to announce an excellent career opportunity for a BI Developer! We are seeking a highly motivated individual who is eager to learn, contribute, and advance their career within a rapidly growing organization. The ideal candidate will bring a strong commitment to professional development and a desire to succeed in a dynamic corporate environment.

Leads the design, development, and delivery of Power BI reporting solutions and enterprise semantic models to support data-driven decision-making. Responsible for end-to-end data transformation using Power Query and DAX, building and maintaining reusable semantic models, and enforcing data quality and governance standards across the reporting environment. Serves as a technical lead for BI development while partnering with business stakeholders to ensure reports are accurate, consistent, and fit for purpose.

Key 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, analysis-ready datasets
• Partner with data engineering, IT, and business stakeholders to define source-to-report data flows and resolve upstream data issues affecting report reliability
• Define and enforce data quality rules, profiling standards, and validation checks to ensure reports reflect accurate and trustworthy 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, gateway configurations, and usage metrics
• 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, filtering, and correct interpretation of metrics
• Present findings and recommendations to leadership in a clear, concise, and actionable manner

Qualifications:

Experience:

• 4+ years of experience in business intelligence, data analytics, or a reporting-focused role
• Demonstrated experience delivering Power BI reports and semantic models used in production environments
• Hands-on experience writing DAX measures and Power Query transformations for complex business reporting requirements

Knowledge and

Skills:

Required:

• Advanced proficiency in DAX for calculated columns, measures, and time-intelligence functions
• Strong proficiency in Power Query (M) for data transformation, cleansing, and integration across heterogeneous sources
• Deep experience with Power BI Desktop, Power BI Service, and semantic model design (star schema, relationships, hierarchies)
• Solid understanding of data quality concepts including profiling, validation, lineage, and issue triage across the data pipeline
• Proficiency in SQL for data extraction, transformation validation, and troubleshooting source data issues
• Ability to document data models, transformation logic, and governance policies clearly for both technical and non-technical audiences

Preferred:

• Experience working with data warehouses, lake houses, or cloud data platforms (e.g., Azure Synapse, Fabric, Databricks) as Power BI data sources
• Experience with Tabular Editor, DAX Studio, or ALM Toolkit for model development and optimization
• Familiarity with Microsoft Fabric or Power BI Premium capacity management
• Experience with Microsoft Dynamics, Dataverse, or other Power Platform data sources
• Familiarity with data governance frameworks such as DAMA-DMBOK or enterprise data catalog tools (e.g., Purview)
• Experience implementing row-level security (RLS) and object-level security (OLS) in Power BI semantic models
• Knowledge of version control practices for Power BI (e.g., PBIP format with Git integration) and deployment pipeline management
• Experience with Python or R for data preparation tasks that feed into Power BI datasets

Education Requirements:

• Bachelor's degree in Data Science, Data Analytics, Computer Science, Information Technology, Engineering, Mathematics, Finance, or related field
• Equivalent combination of education and experience may be considered

Certificates/Licenses:

• Microsoft Certified:
  Power BI Data Analyst Associate (PL-300) preferred; not required

Physical Requirements:

Minimum physical requirements required to perform the duties of the job

Environment/Noise:

Describe Work Environment (i.e. Office, Outside, Working with Machinery) and Noise Level

About Troon:

Founded in 1990 and headquartered in Scottsdale, AZ, Troon is the world's largest professional club management company that specializes in services in golf,…