Advanced knowledge of Business Intelligence architecture, data modeling, dimensional modeling, and semantic modeling concepts.
Strong knowledge of Microsoft Fabric and Power BI architecture, including Lakehouses, semantic models, notebooks, workspaces, and deployment processes.
Advanced understanding of dimensional modeling and star-schema design, including fact tables, dimension tables, relationships, hierarchies, and appropriate model grain.
Advanced knowledge of Power BI semantic models and DAX, including measures, calculation logic, model relationships, filter context, and performance optimization.
Advanced SQL skills for querying, validating, profiling, transforming, and reconciling enterprise data.
Strong understanding of modern data architecture and Medallion Architecture, including Bronze, Silver, Gold, and semantic data layers.
Ability to understand source-system data structures and work with Data Engineering teams to map source data into governed analytical data products.
Ability to translate business processes, terminology, rules, calculations, and analytical requirements into scalable technical and semantic solutions.
Experience with Git-based source control, Azure DevOps, pull requests, peer review, CI/CD, and modern software development practices.
Understanding of Power BI reporting and visualization principles sufficient to design semantic models that effectively support downstream analytical experiences.
Understanding of AI and advanced analytics concepts and how governed semantic data can support AI-driven analytical solutions.
Strong analytical and problem-solving skills with the ability to identify data discrepancies, determine root causes, and implement appropriate solutions.
Ability to communicate complex technical concepts to both technical and non-technical audiences.
Strong consulting and influencing abilities to work across Business Intelligence, Data Engineering, IT, leadership, and operational business teams.
Ability to work independently while collaborating effectively as part of a cross-functional development team.
Ability to manage multiple projects and priorities while maintaining technical quality, documentation, and development standards.
Ability to train, mentor, and provide technical guidance to other Business Intelligence professionals.
Responsibilities
Partner with Business Intelligence Analysts and business stakeholders to understand business processes, reporting requirements, analytical needs, key performance indicators, calculations, and business definitions.
Translate business and analytical requirements into technical data and semantic modeling requirements.
Collaborate with Data Engineering teams during data mapping and modeling activities to identify required source data, transformation logic, business rules, relationships, and data quality requirements.
Define Gold data requirements with Data Engineering to ensure data products are structured appropriately for downstream semantic modeling, reporting, analytics, and AI consumption.
Validate Gold data against documented business requirements and source-system logic before incorporating it into governed semantic models.
Design, develop, deploy, and maintain enterprise semantic models within Microsoft Fabric.
Develop and maintain DAX measures and standardized business calculations to ensure consistent calculation of enterprise metrics and key performance indicators.
Add business context to semantic models through clear naming conventions, descriptions, metadata, relationships, hierarchies, formatting, and documented business definitions.
Develop reusable enterprise semantic models that support multiple downstream reports, dashboards, applications, and analytical use cases rather than report-specific data solutions when enterprise reuse is appropriate.
Design semantic model architecture that allows specialized downstream semantic models to extend governed enterprise models for specific business or operational use cases.
Optimize semantic models for performance, scalability, usability, security, and maintainability.
Implement appropriate data and semantic model security, including row-level security, object-level security, and other access-control requirements.
Identify data quality issues and work with Business Intelligence Analysts, Data Engineering, Data Stewards, and business stakeholders to determine appropriate resolution.
Establish and follow enterprise semantic modeling standards, naming conventions, documentation practices, reusable development patterns, and governance requirements.
Document data lineage, business definitions, transformation logic, model relationships, calculations, measures, and dependencies to improve transparency and maintainability.
Use Git-based source control and Azure DevOps to manage development work, version control, code reviews, pull requests, and solution deployment.
Implement and follow CI/CD practices for semantic models and related Business Intelligence solutions across development, test, and production environments.
Partner with Business Intelligence Analysts who use governed semantic models to develop Power BI dashboards, reports, and other business-facing analytical solutions.
Partner with Data Scientists to ensure enterprise semantic models can support advanced analytics, machine learning, generative AI, and other AI-driven solutions.
Evaluate emerging Microsoft Fabric, Power BI, semantic modeling, and analytics capabilities and recommend opportunities to improve the organization's Business Intelligence architecture.
Provide training and technical support and serve as a subject matter expert for semantic modeling and Business Intelligence development.
Maintain professional and technical knowledge through ongoing training, conferences, webinars, certifications, and other educational opportunities.
Work safely and adhere to applicable safety policies, company policies, procedures, and standards.
Perform other duties as assigned.
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.
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 DevOps 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 business-facing analytical solutions
Partners with Data Scientists to ensure enterprise semantic models can appropriately support advanced analytics, machine learning, generative AI, and other AI-driven solutions
Evaluates emerging Microsoft Fabric, Power BI, semantic modeling, and analytics capabilities and recommends opportunities to improve the organization's Business Intelligence architecture
Provides training and technical support and serves as a subject matter expert for semantic modeling and Business Intelligence development
Maintains professional and technical knowledge through ongoing training, conferences, webinars, certifications, and other educational opportunities
Works safely at all times and adheres to all applicable safety policies; complies with all company policies, procedures, and standards
Performs other duties as assigned
Advanced knowledge of Business Intelligence architecture, data modeling, dimensional modeling, and semantic modeling concepts
Strong knowledge of Microsoft Fabric and Power BI architecture, including Lakehouses, semantic models, notebooks, workspaces, and deployment processes
Advanced understanding of dimensional modeling and star-schema design, including fact tables, dimension tables, relationships, hierarchies, and appropriate model grain
Advanced knowledge of Power BI semantic models and DAX, including measures, calculation logic, model relationships, filter context, and performance optimization
Advanced SQL skills for querying, validating, profiling, transforming, and reconciling enterprise data
Strong understanding of modern data architecture and Medallion Architecture, including Bronze, Silver, Gold, and semantic data layers
Ability to understand source-system data structures and work with Data Engineering teams to map source data into governed analytical data products
Ability to translate business processes, terminology, rules, calculations, and analytical requirements into scalable technical and semantic solutions
Experience with Git-based source control, Azure DevOps, pull requests, peer review, CI/CD, and modern software development practices
Understanding of Power BI reporting and visualization principles sufficient to design semantic models that effectively support downstream analytical experiences
Understanding of AI and advanced analytics concepts and how governed semantic data can support AI-driven analytical solutions
Strong analytical and problem-solving skills with the ability to identify data discrepancies, determine root causes, and implement appropriate solutions
Excellent verbal, written, communication, documentation, and presentation skills
Ability to communicate complex technical concepts to both technical and non-technical audiences
Strong consulting and influencing abilities with the ability to work across Business Intelligence, Data Engineering, IT, leadership, and operational business teams
Ability to work independently while collaborating effectively as part of a cross-functional development team
Ability to manage multiple projects and priorities while maintaining technical quality, documentation, and development standards
Ability to train, mentor, and provide technical guidance to other Business Intelligence professionals