1 to 25 of 38 Star Schema Jobs in England

models, dashboards and reports. Develop scalable dimensional data models (fact and dimension tables) to support analytical reporting. Design and optimise enterprise semantic models using star schema methodologies. Develop advanced DAX measures, calculations and KPIs to support business reporting requirements. Optimise Power BI datasets and semantic models to maximise … Strong experience designing dimensional data models for enterprise analytics. Excellent knowledge of Microsoft Fabric architecture. Advanced experience with DAX and enterprise semantic modelling using star schema design. Strong experience tuning and optimising Power BI semantic models. Advanced knowledge of Power Query , including transformation optimisation and diagnostics. Strong ...

pipeline development on Azure and SQL Server. Hands-on orchestration experience with SSIS, SQL Agent, and Azure Data Factory. Solid data modelling, ideally star schema design. Experience implementing data quality checks and testing (DBT or similar). Comfortable with Git and GitHub in a CI/CD workflow. … pipelines for structured and unstructured data. Help develop and maintain a modern data architecture, including optimising on-prem data warehouses. Design performant data models (star schema) and apply data transformations. Implement data observability, testing, and validation checks (such as DBT tests) to protect data integrity. Set up dynamic ...

PowerBI Developer to join their PowerBI Development team. The PowerBI Developer will be responsible for end-to-end Power BI development, complex DAX, star-schema modeling, and Power Platform workflows using SQL and Databricks. Key Responsibilities for the PowerBI Developer: Designing and developing Power BI solutions (semantic models … reports, and dashboards - that serve real business needs across multiple areas of the organisation) Writing complex DAX, building star schema data models, and optimising solutions for performance and usability Managing your own projects end-to-end, from requirements and scoping through to deployment and support Using deployment pipelines ...

globally connected Case Management System. The solution must support nightly data ingestion with zero disruption to system availability. Key Responsibilities Design and build a star schema data warehouse and associated data marts, including fact and dimension tables (e.g., Fact Cases, FactCaseEvents, Date, Case, Status, User, Organisation) Implement Slowly … data technologies , including: Azure SQL/Synapse Azure Data Factory Power BI (datasets, tabular models, and reporting) Strong experience building data warehouse solutions , including: Star schema design Fact and dimension modelling SCD implementation T-SQL performance tuning Experience working within always-on or mission-critical environments with strict ...

keep full control on what's going on and how we shape solutions. Key responsibilities : ● Design and implement robust data models (e.g., star schema, snowflake schema, data vault). ● Develop and maintain dimensional data models to support BI and reporting requirements. ● Develop and implement analytics solutions ...

keep full control on what's going on and how we shape solutions. Key responsibilities : Design and implement robust data models (e.g., star schema, snowflake schema, data vault). Develop and maintain dimensional data models to support BI and reporting requirements. Develop and implement analytics solutions ...

allows us to keep full control on what's going on and how we shape solutions.Key responsibilities :● Design and implement robust data models (e.G., star schema, snowflake schema,data vault).● Develop and maintain dimensional data models to support BI and reportingrequirements.● Develop and implement analytics solutions ...

high-volume transactional sources. Build reliable, high-performance data solutions for reporting and analytics. Design scalable data models using dimensional modelling techniques including star schema and Data Vault methodologies. Evaluate and modernise existing data architecture, identifying opportunities to improve performance, scalability and governance. Ensure robust data governance, security ...

using Power BI including semantic modelling, DAX, Power Query, data visualisation best practice, report development, and performance optimisation Advanced data modelling including dimensional modelling, star schema design, database layers, and data mart development Knowledge of BI solution delivery methodologies including requirements and discovery, Agile delivery, testing, deployment ...

using Power BI including semantic modelling, DAX, Power Query, data visualisation best practice, report development, and performance optimisation\ NAdvanced data modelling including dimensional modelling, star schema design, database layers, and data mart development\ NKnowledge of BI solution delivery methodologies including requirements and discovery, Agile delivery, testing, deployment ...

scale. Key Responsibilities: Data platform ownership: Lead the design, operation, and evolution of our SQL Server data warehouse. Establish best practice standards for schema design and performance tuning in SQL Server/SSMS. ETL/ELT & integration: Define and manage pipelines (e.g., SSIS & Power Query) that consolidate sources including … experience delivering Power BI models and dashboards (DAX, Power Query, RLS, performance). ETL/ELT tooling (SSIS/Power Query) and dimensional modelling (Star Schema). Practical AI/ML exposure (e.g., Python notebooks, Azure ML, or equivalent) and the ability to operationalise models responsibly within reporting ...

APIs and native connectors Own data quality, monitoring, and governance across the platform Design and implement dimensional data models (fact/dimension tables, star schema) Build and maintain Power BI semantic models with DAX, KPIs, and row-level security Deliver dashboards and reporting across commercial, marketing, and operational ...

operational stability \n Monitor production performance and resolve root causes to prevent recurring data delivery issues \n Apply dimensional modeling and support Unified Star Schema development to ensure semantic consistency \n Mentor and coach junior engineers while promoting strong technical standards and collaborative ways of working ...

deployments to ensure reliability and operational stabilityMonitor production performance and resolve root causes to prevent recurring data delivery issuesApply dimensional modeling and support Unified Star Schema development to ensure semantic consistencyMentor and coach junior engineers while promoting strong technical standards and collaborative ways of working About the Team ...

ensure reliability and operational stability\ NMonitor production performance and resolve root causes to prevent recurring data delivery issues\ NApply dimensional modeling and support Unified Star Schema development to ensure semantic consistency\ NMentor and coach junior engineers while promoting strong technical standards and collaborative ways of working\ N\nAbout ...

ensure reliability and operational stability Monitor production performance and resolve root causes to prevent recurring data delivery issues Apply dimensional modeling and support Unified Star Schema development to ensure semantic consistency Mentor and coach junior engineers while promoting strong technical standards and collaborative ways of working About ...

DevOps, along with exposure to AWS data platforms (Redshift, S3, etc.). Key Responsibilities Data & Semantic Modelling - Design and implement dimensional data models (star schema, fact/dimension design) - Build and manage enterprise-scale semantic models (Power BI datasets/tabular models) - Define modelling standards, reusable measures, hierarchies ...

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

GitHub, and Databricks Asset Bundles Strong programming skills in PySpark, Databricks SQL, and T-SQL Understanding of Medallion Architecture and modern data modelling approaches (Star Schema, Data Vault 2.0) Experience with performance optimisation in Databricks and integration with Power BI (Direct Lake) Robert Walters Operations Limited ...

. dbt (modular analytics engineering, transformations, testing). AWS Python proficiency as a data engineer and Orchestration tools (e.g. Airflow) Data and Dimensional modelling (star schema, Kimball/Inmon methodologies, OBT). AI - copilots, agentic AI, MCP Servers Strong understanding of DataOps, CI/CD, git, and data ...

near-production environment Practical experience building and maintaining ETL/ELT pipelines in a cloud environment Working knowledge of data modelling concepts including star schema and dimensional modelling Please see full job description attached. What you can expect from us We believe doing your best work starts with ...

reporting and analytics. • Partner with stakeholders to understand requirements, validate assumptions and shape how data should be modelled. • Apply strong data modelling practices, including star schemas and Kimball methodologies. • Support the management of the lakehouse, including incremental loads, snapshotting and data quality. • Contribute to the relationship with Databricks ...

automation specialist or similar role. Strong proficiency in Power BI Desktop, Power BI Service, and Power Query. Solid understanding of data modelling concepts, including star schema, relationships, and normalisation. Experience with DAX (Data Analysis Expressions) for creating complex measures and calculations Familiarity with Power BI best practices, security ...