> Markdown version of [/jobs/ext/1332655-bi-developer](https://www.wearedevelopers.com/jobs/ext/1332655-bi-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # BI Developer - **Company:** Troon - **Location:** Scottsdale, AZ, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Business Intelligence Development, Data Cleansing, Information Engineering, Data Governance, Data Transformation, Data Mining, Data Warehousing, Document-Oriented Databases, Python (Programming Language), Microsoft Dynamics, Power BI, Cloud Services, SQL Databases, Data Streaming, Git, Powerquery, Microsoft Fabric, Information Technology, Data Analytics, Star Schema, Azure Synapse Analytics, Software Version Control, Data Pipelines, Databricks - **Published:** July 18, 2026 - **Apply:** https://recruiting2.ultipro.com/TRO1001TROO/JobBoard/2b13054b-60bb-410d-9136-e52c1c7d9720/OpportunityDetail?opportunityId=9b12ded3-6e9e-41db-96e7-45261de5b177 ## About the Role * 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 Preferred: * Experience working with data warehouses, lakehouses, 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, * 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 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, Minimum education credentials required for the role: * 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 ## Description 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., * 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 ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Cutting LLM Costs Without Cutting Quality: How to Beat Proprietary LLMs with Fine-Tuned Open Source](https://www.wearedevelopers.com/videos/100151-cutting-llm-costs-without-cutting-quality-how-to-beat-proprietary-llms-with-fine-tuned-open-source) - [Enabling intelligent logistics automation: home-grown Industrial IoT platform at Austrian Post](https://www.wearedevelopers.com/videos/2018-enabling-intelligent-logistics-automation-home-grown-industrial-iot-platform-at-austrian-post) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)