Business Intelligence Developer

The Business Intelligence Developer designs, develops, and maintains enterprise business intelligence data solutions and semantic models that enable trusted reporting, analytics, self-service, and artificial intelligence capabilities across the organization. This position serves as a technical bridge between business requirements, Data Engineering, and Business Intelligence.The Business Intelligence Developer partners with Business Intelligence Analysts to understand business processes, reporting requirements, key performance indicators, and analytical needs.

The role works closely with Data Engineering teams to map source data and define requirements necessary to transform enterprise data from Bronze through Gold medallion architecture within Microsoft Fabric. Using governed Gold data, the Business Intelligence Developer designs and develops reusable enterprise semantic models that translate technical data structures into business-ready analytical data products with standardized relationships, measures, calculations, definitions, metadata, and business context.The incumbent in this position is expected to model the following practices daily: Demonstrate alignment with the company's mission and core business values; Collaborate with key internal/external resources; Participate in ongoing self-development.Essential FunctionsModel, promote, reinforce, and recognize the consistent use of HOLT's Values Based Leadership (VBL) tools, models, and processes to ensure alignment with our Vision, Values, and MissionPartners with Business Intelligence Analysts and business stakeholders to understand business processes, reporting requirements, analytical needs, key performance indicators, calculations, and business definitionsTranslates business and analytical requirements into technical data and semantic modeling requirementsCollaborates with Data Engineering teams during data mapping and modeling activities to identify required source data, transformation logic, business rules, relationships, and data quality requirementsDefines Gold data requirements with Data Engineering to ensure data products are structured appropriately for downstream semantic modeling, reporting, analytics, and AI consumptionValidates Gold data against documented business requirements and source-system logic before incorporating data into governed semantic modelsDesigns, develops, deploys, and maintains enterprise semantic models within Microsoft FabricDevelops and maintains DAX measures and standardized business calculations to ensure consistent calculation of enterprise metrics and key performance indicatorsAdds business context to semantic models through clear naming conventions, descriptions, metadata, relationships, hierarchies, formatting, and documented business definitionsDevelops reusable enterprise semantic models that can support multiple downstream reports, dashboards, applications, and analytical use cases rather than creating report-specific data solutions when enterprise reuse is appropriateDesigns semantic model architecture that allows specialized downstream semantic models to extend governed enterprise models for specific business or operational use casesOptimizes semantic models for performance, scalability, usability, security, and maintainabilityImplements appropriate data and semantic model security, including row-level security, object-level security, and other access-control requirementsIdentifies data quality issues and works with Business Intelligence Analysts, Data Engineering, Data Stewards, and business stakeholders to determine appropriate resolutionEstablishes and follows enterprise semantic modeling standards, naming conventions, documentation practices, reusable development patterns, and governance requirementsDocuments data lineage, business definitions, transformation logic, model relationships, calculations, measures, and dependencies to improve transparency and maintainabilityUses Git-based source control and Azure DevOps to manage development work, version control, code reviews, pull requests, and solution deploymentImplements and follows CI/CD practices for semantic models and related Business Intelligence solutions across development, test, and production environmentsPartners with Business Intelligence Analysts who use governed semantic models to develop Power BI dashboards, reports, and other business-facing analytical solutionsPartners with Data Scientists to ensure enterprise semantic models can appropriately support advanced analytics, machine learning, generative AI, and other AI-driven solutionsEvaluates emerging Microsoft Fabric, Power BI, semantic modeling, and analytics capabilities and recommends opportunities to improve the organization's Business Intelligence architectureProvides training and technical support and serves as a subject matter expert for semantic modeling and Business Intelligence developmentMaintains professional and technical knowledge through ongoing training, conferences, webinars, certifications, and other educational opportunitiesWorks safely at all times and adheres to all applicable safety policies; complies with all company policies, procedures, and standardsPerforms other duties as assignedKnowledge, Skills, and AbilitiesAdvanced knowledge of Business Intelligence architecture, data modeling, dimensional modeling, and semantic modeling conceptsStrong knowledge of Microsoft Fabric and Power BI architecture, including Lakehouses, semantic models, notebooks, workspaces, and deployment processesAdvanced understanding of dimensional modeling and star-schema design, including fact tables, dimension tables, relationships, hierarchies, and appropriate model grainAdvanced knowledge of Power BI semantic models and DAX, including measures, calculation logic, model relationships, filter context, and performance optimizationAdvanced SQL skills for querying, validating, profiling, transforming, and reconciling enterprise dataStrong understanding of modern data architecture and Medallion Architecture, including Bronze, Silver, Gold, and semantic data layersAbility to understand source-system data structures and work with Data Engineering teams to map source data into governed analytical data productsAbility to translate business processes, terminology, rules, calculations, and analytical requirements into scalable technical and semantic solutionsExperience with Git-based source control, Azure DevOps, pull requests, peer review, CI/CD, and modern software development practicesUnderstanding of Power BI reporting and visualization principles sufficient to design semantic models that effectively support downstream analytical experiencesUnderstanding of AI and advanced analytics concepts and how governed semantic data can support AI-driven analytical solutionsStrong analytical and problem-solving skills with the ability to identify data discrepancies, determine root causes, and implement appropriate solutionsExcellent verbal, written, communication, documentation, and presentation skillsAbility to communicate complex technical concepts to both technical and non-technical audiencesStrong consulting and influencing abilities with the ability to work across Business Intelligence, Data Engineering, IT, leadership, and operational business teamsAbility to work independently while collaborating effectively as part of a cross-functional development teamAbility to manage multiple projects and priorities while maintaining technical quality, documentation, and development standardsAbility to train, mentor, and provide technical guidance to other Business Intelligence professionalsRequirementsEducation and Experience:Bachelor's Degree in Business Analytics, Data Analytics, Information Systems, Computer Science, Data Science, Business, or a related discipline requiredMinimum of two years of experience in Business Intelligence, analytics engineering, data modeling, data development, or related disciplines required; four or more years of experience preferred Demonstrated experience designing and developing dimensional or semantic data models requiredExperience developing Power BI semantic models and DAX requiredExperience with SQL and relational data structures requiredExperience with Microsoft Fabric or comparable modern cloud analytics platforms strongly preferredExperience with Microsoft Fabric notebooks, Python, or similar data development technologies preferredExperience working with Data Engineering teams on data mapping, transformation requirements, and analytical data products preferredExperience with Git-based source control, Azure DevOps, CI/CD, or comparable modern development practices preferredSupervisory Responsibilities:None Travel:Up to 15% to include conferences or travel to other locations for in-person meetingsPhysical Requirements:This position involves extended periods in a stationary positionOccasional movement inside the office to access office machinery, file cabinets, etc.This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machinesThis position frequently communicates with employees and stakeholders; Must be able to exchange accurate information in these situationsOccasionally moves or transports items weighing up to 10 lbs. Work Environment:This job is generally performed in a professional office environment, in environmentally controlled conditionsFrequently works at a fast pace with unscheduled interruptionsDisclaimer:Please note that the above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification. They are not to be interpreted as an exhaustive list of all responsibilities, duties, and skills required of the incumbents so classified. All incumbents may be required to perform duties outside of their normal responsibilities, as needed.DepartmentMarketing (MRKT)Employment TypeFull TimeWorkplace typeOnsite