BI Developer
About The Position
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.
Requirements
- 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 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
Nice To Haves
- 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
- 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
- Microsoft Certified: Power BI Data Analyst Associate (PL-300) preferred; 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 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
