Business Intelligence Developer

Business Intelligence Developer

Department: Marketing (MRKT)

Employment Type: Full Time

Location: Irving-Las Colinas

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:

• Model, 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 Mission
• Partners with Business Intelligence Analysts and business stakeholders to understand business processes, reporting requirements, analytical needs, key performance indicators, calculations, and business definitions
• Translates business and analytical requirements into technical data and semantic modeling requirements
• Collaborates with Data Engineering teams during data mapping and modeling activities to identify required source data, transformation logic, business rules, relationships, and data quality requirements
• Defines Gold data requirements with Data Engineering to ensure data products are structured appropriately for downstream semantic modeling, reporting, analytics, and AI consumption
• Validates Gold data against documented business requirements and source-system logic before incorporating data into governed semantic models
• Designs, develops, deploys, and maintains enterprise semantic models within Microsoft Fabric
• Develops and maintains DAX measures and standardized business calculations to ensure consistent calculation of enterprise metrics and key performance indicators
• Adds business context to semantic models through clear naming conventions, descriptions, metadata, relationships, hierarchies, formatting, and documented business definitions
• Develops 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 appropriate
• Designs semantic model architecture that allows specialized downstream semantic models to extend governed enterprise models for specific business or operational use cases
• Optimizes semantic models for performance, scalability, usability, security, and maintainability
• Implements appropriate data and semantic model security, including row-level security, object-level security, and other access-control requirements
• Identifies data quality issues and works with Business Intelligence Analysts, Data Engineering, Data Stewards, and business stakeholders to determine appropriate resolution
• Establishes and follows enterprise semantic modeling standards, naming conventions, documentation practices, reusable development patterns, and governance requirements
• Documents data lineage, business definitions, transformation logic, model relationships, calculations, measures, and dependencies to improve transparency and maintainability
• Uses Git-based source control and Azure Dev Ops to manage development work, version control, code reviews, pull requests, and solution deployment
• Implements and follows CI/CD practices for semantic models and related Business Intelligence solutions across development, test, and production environments
• Partners with Business Intelligence Analysts who use governed semantic models to develop Power BI dashboards, reports, and other…