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 usabilityBuild and maintain Power BI semantic models, including table relationships, calculated columns, measures, and row-level security configurationsDevelop and manage Power Query data transformation logic to clean, reshape, and integrate data from multiple source systems into consistent, analysis-ready datasetsPartner with data engineering, IT, and business stakeholders to define source-to-report data flows and resolve upstream data issues affecting report reliabilityDefine and enforce data quality rules, profiling standards, and validation checks to ensure reports reflect accurate and trustworthy dataEstablish and document data governance standards for the Power BI environment, including dataset ownership, naming conventions, certification processes, and access controlsMonitor and maintain the health of published datasets and reports in the Power BI service, including refresh schedules, gateway configurations, and usage metricsOptimize report and dataset performance through query folding, incremental refresh, aggregations, and efficient DAX patternsProvide guidance and enablement to report consumers on Power BI navigation, filtering, and correct interpretation of metricsPresent findings and recommendations to leadership in a clear, concise, and actionable mannerQualifications:Experience:4+ years of experience in business intelligence, data analytics, or a reporting-focused roleDemonstrated experience delivering Power BI reports and semantic models used in production environmentsHands-on experience writing DAX measures and Power Query transformations for complex business reporting requirementsPreferred:Experience working with data warehouses, lakehouses, or cloud data platforms (e.g., Azure Synapse, Fabric, Databricks) as Power BI data sourcesExperience with Tabular Editor, DAX Studio, or ALM Toolkit for model development and optimizationFamiliarity with Microsoft Fabric or Power BI Premium capacity managementKnowledge and Skills:Required:Advanced proficiency in DAX for calculated columns, measures, and time-intelligence functionsStrong proficiency in Power Query (M) for data transformation, cleansing, and integration across heterogeneous sourcesDeep 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 pipelineProficiency in SQL for data extraction, transformation validation, and troubleshooting source data issuesAbility to document data models, transformation logic, and governance policies clearly for both technical and non-technical audiencesPreferred:Experience with Microsoft Dynamics, Dataverse, or other Power Platform data sourcesFamiliarity 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 modelsKnowledge of version control practices for Power BI (e.g., PBIP format with Git integration) and deployment pipeline managementExperience with Python or R for data preparation tasks that feed into Power BI datasetsEducation Requirements:Minimum education credentials required for the role:Bachelor’s degree in Data Science, Data Analytics, Computer Science, Information Technology, Engineering, Mathematics, Finance, or related fieldEquivalent combination of education and experience may be consideredCertificates/Licenses:Microsoft Certified: Power BI Data Analyst Associate (PL-300) preferred; not requiredPhysical Requirements:Minimum physical requirements required to perform the duties of the jobEnvironment/Noise:Describe Work Environment (i.e. Office, Outside, Working with Machinery) and Noise LevelAbout TroonFounded in 1990 and headquartered in Scottsdale, AZ, Troon is the world’s largest professional club management company that specializes in services in golf, hospitality, and residential communities. With more than 900 locations in 45+ states and 27+ countries, Troon is a leading employer in hospitality. Guided by values that emphasize being infectiously energetic, consciously kind, and humbly prosperous, Troon offers professionals the opportunity to grow and succeed within a globally respected organization. Learn more at SummaryRequisition Number: BIDEV033194Job Category: TechnologySchedule: Full-Time