BI Developer

Troon•Scottsdale, AZ
•Onsite

About The Position

Troon’s Corporate Office in Scottsdale, Arizona is hiring a BI Developer to lead the design, development, and delivery of Power BI reporting solutions and enterprise semantic models that support data-driven decision-making. The role is responsible for end-to-end data transformation using Power Query and DAX, maintaining reusable semantic models, and enforcing data quality and governance standards across the reporting environment. The BI Developer serves as a technical lead and partners with business stakeholders to ensure reports are accurate, consistent, and fit for purpose.

Requirements

  • At least 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.
  • Advanced proficiency in DAX, including 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, including star schemas, relationships, and 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 for technical and non-technical audiences.
  • Bachelor’s degree in Data Science, Data Analytics, Computer Science, Information Technology, Engineering, Mathematics, Finance, or a related field; an equivalent combination of education and experience may be considered.

Nice To Haves

  • Experience with data warehouses, lakehouses, or cloud data platforms such as Azure Synapse, Fabric, or 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 such as Purview.
  • Experience implementing row-level security (RLS) and object-level security (OLS) in Power BI semantic models.
  • Knowledge of Power BI version control practices, such as PBIP format with Git integration, and deployment pipeline management.
  • Experience with Python or R for data preparation tasks that feed into Power BI datasets.
  • Microsoft Certified: Power BI Data Analyst Associate (PL-300); preferred but not required.

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 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.
  • Establish and document Power BI data governance standards, including dataset ownership, naming conventions, certification processes, and access controls.
  • Monitor and maintain published datasets and reports in the Power BI service, including refresh schedules, gateway configurations, and usage metrics.
  • Optimize report and dataset performance using query folding, incremental refresh, aggregations, and efficient DAX patterns.
  • Guide and enable report consumers in Power BI navigation, filtering, and correct interpretation of metrics.
  • Present findings and recommendations to leadership clearly and concisely.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service