Assistant Director - Business Intelligence

About the role

The Assistant Director – Business Intelligence will provide specialist expertise in data engineering and Power BI semantic model development, creating a trusted, scalable and governed data foundation for People Analytics products. The role will own the Power BI data and semantic model layer end to end, ensuring workforce data is accessible through intuitive, natural-language experiences and fit for business use.

What you'll do

• Own the Power BI data and semantic model layer end to end, designing scalable dimensional models, including star schemas, fact and dimension tables, relationships
• Design and deliver robust data pipelines, including source onboarding, ingestion, transformation, dependency management, validation, monitoring and production support
• Translate business and reporting requirements into reusable semantic models, common data definitions, KPI logic and calculation standards
• Build and optimise Power BI datasets and semantic models using Import, DirectQuery and composite modelling approaches
• Implement and support Row-Level Security, Column-Level Security and other access controls, diagnosing issues across the data pipeline, semantic model

What you need

• Power BI
• SQL
• ETL
• DAX
• Data modelling
• Azure
• Any graduate

Good to have

• CI/CD
• Databricks