1 to 25 of 29 Permanent Star Schema Jobs in England

will play a key role in transforming our data warehouse and Azure data platform. This includes redeveloping Azure Data Factory (ADF) pipelines, implementing star schema models, and improving the reliability and quality of our data assets. You will: Azure Data Factory & Pipeline Development Group and redesign pipelines based … duplication and simplify change management. Migrate existing logic into a cleaner, streamlined structure. Remove old or redundant pipelines to create a more efficient environment. Star Schema & Data Warehouse Development Help transition from denormalised 2D files to a robust star schema aligned to Kimball principles. Create ...

evolving reporting landscape. What You’ll Do Design and develop scalable data transformations in Azure Databricks using Python and Spark Build and maintain star-schema models aligned to business KPI definitions Collaborate with Data Engineering to improve data quality and reliability Support and enhance Tableau dashboards and certified … roles Strong SQL skills (complex queries, optimisation, data validation) Hands-on experience with Python and Spark, ideally in Azure Databricks Experience designing and maintaining star-schema models Experience supporting reporting in Tableau or Power BI Solid understanding of data warehousing, governance, and KPI standardisation Strong stakeholder communication ...

+ 3rd party applications covering, Retail and Wholesale Sales, Stock, Customer, Supply Chain and Finance) into the data lake environment. • Apply good practice in star-schema modelling, incremental refresh, and DAX/M query optimisation. • Work with software developers, analysts and self-serve users to shape reporting requirements … understanding of Microsoft Fabric, particularly: o Lakehouses/Warehouses o Dataflows Gen2 o Pipelines & notebooks o OneLake data architecture • Good knowledge of data modelling (star-schema, fact/dimension design, calculations, DAX, M). • Strong SQL skills and ability to work with structured/unstructured data. • Comfortable working ...

Developer. The Role Joining a newly formed team, you will take ownership of transforming ingested data from the staging layer into governed, high performance star schema models within the reporting layer using Azure Databricks and Azure SQL. Other key responsibilities include: Data Modelling - Design and maintain star schema models, ensuring fact and dimension structures are aligned to business definitions and scalable for future growth. Reporting Development and Delivery - Contribute directly to the development and enhancement of Tableau dashboards and certified data sources. Data Governance - Play a critical role in centralising KPI logic and improving consistency ...

skills, and design sensibility. Key Responsibilities Design and develop Power BI dashboards from concept through to deployment and maintenance. Build robust data models using star schema and dimensional modeling techniques. Write DAX measures and calculations to deliver business metrics and KPIs. Create Power Query transformations to extract, clean … Query proficiency including M language, data transformations, and query optimization. SQL skills for data extraction, transformation, and understanding database structures. Data modeling experience including star schema, dimensional modeling, and normalization. Understanding of UX and design principles for user-friendly dashboards. Stakeholder management skills with ability to gather requirements ...

Boomi, Informatica, Talend, SSIS, or custom scripting languages (Python, PySpark, SQL) for data extraction and transformation. Prior experience with Data warehousing and Data modelling (Star Schema or Snowflake Schema). Skilled in security frameworks such as GDPR, HIPAA, ISO 27001, NIST, SOX, and PII, with expertise ...

manipulate datasets using SQL/T-SQL.Experience producing clear technical documentation, data flows, and specifications.Ability to design and implement dimensional data models (e.g., star schema) including Slowly Changing Dimensions (SCD Type 1/2) for accurate historical reporting.Desirable:Experience in the Social Housing sector.Exposure to BI tools such ...

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 … Power Query, RLS, performance). Advanced Excel: advanced formulas, Pivot tables, Power Pivot. 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 ...

scale processing Support the development and optimisation of Power BI datasets, reports and dashboards Build and maintain scalable semantic data models including dimensional and star schema structures Ensure strong data quality, governance and testing standards across all BI and data engineering solutions Skills and Experience Hands-on expertise ...

work Transform data into meaningful insights and recommendations What you'll bring Experience of building a data warehouse using an ETL/ELT tool Star schema/dimensional modelling. Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements ...

dashboards and reports Translate complex business requirements into scalable data models Build and optimise DAX measures and calculations Develop robust data models using star schema principles Work with data engineers to integrate data from multiple sources (SQL, APIs, cloud platforms) Ensure governance, security and best practice standards ...

Cortex AI and semantic views) 3+ years in Python 3+ Strong database querying skills (MySQL preferred) Experience with complex data warehouses, data modeling, and star schemas Familiarity with APIs and agile methodologies Nice to Have: Azure Data Factory (ADF) experience Exposure to AI tools such as Codex, Claude ...

primary escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation ...

primary escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation ...

primary escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation ...

primary escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation ...

Silver/Gold), data pipelines, and OneLake storage. Querying & Modelling: Exposure to SQL or Spark SQL for querying data models, alongside a familiarity with Star Schema principles. Platform Concepts: An understanding of ETL/ELT concepts with the ability to troubleshoot (rather than design) complex architectures. Soft Skills ...

Lakehouse architecture and best practices. Experience with Unity Catalog. Expertise in Azure DevOps and CI/CD pipelines. Knowledge of data modelling (dimensional/star schemas). Experience working in Agile environments. Desirable Skills Exposure to multiple data technology stacks. Experience in large-scale enterprise environments. Knowledge of security ...

hands-on experience with Microsoft SQL Server Proven experience developing SSIS packages for ETL and data integration Solid understanding of data warehousing concepts , including: Star schema Fact and dimension tables Slowly changing dimensions Professional experience with .NET and C# Advanced T-SQL skills, including performance tuning and query ...

data modelling Proven experience building and maintaining Tableau dashboards Experience working with AWS, Redshift, and ELT workflows Strong understanding of data warehousing concepts (star schema, fact/dimension models) Experience collaborating with cross-functional stakeholders Excellent analytical, problem-solving, and communication skills Ability to work independently ...

Power BI Strong working knowledge of Microsoft Fabric architecture Experience managing Premium and/or Fabric capacities Advanced DAX and enterprise semantic modelling (star schema) Performance tuning and optimisation of semantic models Advanced Power Query diagnostics and optimisation SQL optimisation for analytics workloads Working knowledge of Python ...

production. Key Experience Required Strong hands-on experience with Microsoft Fabric Experience building end-to-end Lakehouse solutions Good data modelling skills (e.g. star schema) Experience using PySpark or Spark SQL Building data pipelines from APIs, ERP or SaaS systems Working with Fabric pipelines, notebooks and Dataflows Understanding ...

challenges. The Role You will: * Design and develop Power BI dashboards with strong visual storytelling and user experience. * Build clean, scalable data models using star schema principles. * Create efficient DAX calculations to support flexible reporting. * Shape and transform data using Power Query within Power BI. * Maintain consistent design ...

challenges. The Role You will: * Design and develop Power BI dashboards with strong visual storytelling and user experience. * Build clean, scalable data models using star schema principles. * Create efficient DAX calculations to support flexible reporting. * Shape and transform data using Power Query within Power BI. * Maintain consistent design ...

Role * Design and build Power BI dashboards with a strong focus on visual design and user experience * Develop well-structured data models using star schema principles * Write efficient DAX measures and calculated columns * Build and maintain Power Query transformations for data preparation * Define and maintain design systems, templates ...