1 to 25 of 55 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 ...

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 ...

measures for KPIs, time intelligence, and business logic Perform data transformation using Power Query (M) and SQL-based pipelines Design robust data models (star schema, dimensional modelling) to support performance and scalability Ensure data quality, lineage, and governance standards across all BI assets Monitor and improve dataset performance … optimisation, time intelligence Power Query (M) - data transformation and shaping SQL/SQL Server - joins, CTEs, window functions, performance tuning Data Modelling - dimensional modelling, star schema, semantic models ETL/Data Pipelines - building and maintaining dataflows and pipelines Data Governance - data quality, lineage, and controlled environments PROFILE Proven ...

maintain data transformation pipelines using DBT. Develop ELT/ETL pipelines to ingest and transform data from multiple sources. Design and implement data models (star schema, dimensional models) for analytics and reporting. Optimize Snowflake performance, query efficiency, and cost management. Implement data quality checks, automated testing, and documentation … analysis Python (preferred) for data processing and automation. Data Engineering ETL/ELT pipeline development Data warehousing and dimensional modelling Data modelling techniques (Star schema, Snowflake schema) AI/Data Science Exposure Basic understanding of AI/ML data pipelines and data preparation for machine learning models. ...

source systems into the cloud data platform. Design and govern data transformation frameworks using DBT. Define and enforce data modelling standards including dimensional modelling, star schema, and enterprise data models. Lead architecture reviews and solution design discussions for new data initiatives. Optimize Snowflake performance, workload management, and cost … Python (preferred) for automation and data engineering tasks. Data Engineering Enterprise ETL/ELT pipeline architecture Data warehousing and enterprise data modelling Dimensional modelling (Star Schema, Snowflake Schema) Data pipeline scalability and reliability design. AI/Data Science Exposure Experience supporting AI/ML data pipelines ...

source systems into the cloud data platform. Design and govern data transformation frameworks using DBT. Define and enforce data modelling standards including dimensional modelling, star schema, and enterprise data models. Lead architecture reviews and solution design discussions for new data initiatives. Optimize Snowflake performance, workload management, and cost … Python (preferred) for automation and data engineering tasks. Data Engineering Enterprise ETL/ELT pipeline architecture Data warehousing and enterprise data modelling Dimensional modelling (Star Schema, Snowflake Schema) Data pipeline scalability and reliability design. AI/Data Science Exposure Experience supporting AI/ML data pipelines ...

+ 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 ...

doing Designing and building Power BI dashboards to an exceptional standard of visual design and user experience. Developing robust data models using star schema principles, setting up relationships, hierarchies, and optimised structures. Writing efficient, clean DAX - including complex measures and time intelligence. Using Power Query (M) to build … bring Must-haves: Strong, demonstrable Power BI development experience - you'll need a portfolio or examples of your work. Deep understanding of data modelling , star schema, relationships, and model optimisation. Advanced DAX (complex measures, performance optimisation). Strong Power Query (M) capabilities. Ability to translate complex data into ...

doing Designing and building Power BI dashboards to an exceptional standard of visual design and user experience. Developing robust data models using star schema principles, setting up relationships, hierarchies, and optimised structures. Writing efficient, clean DAX - including complex measures and time intelligence. Using Power Query (M) to build … bring Must-haves: Strong, demonstrable Power BI development experience - you'll need a portfolio or examples of your work. Deep understanding of data modelling , star schema, relationships, and model optimisation. Advanced DAX (complex measures, performance optimisation). Strong Power Query (M) capabilities. Ability to translate complex data into ...

processes to integrate data from multiple sources. Develop and maintain Power BI dashboards and reports that provide actionable business insights. Implement data models (star schema, snowflake schema) optimized for analytics and reporting. Ensure data quality, consistency, and governance across the data warehouse. Optimize query performance and data ...

Data architecture (Data Lakes, Data Warehouses) and distributed processing concepts (e.g., MapReduce). ETL/ELT Basic knowledge of ETL principles and data modeling (star schema, snowflake schema). Version Control Practical experience with Git (branching, merging, pull requests). Preferred Qualifications (A Plus) Experience with ...

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 ...

quality frameworks. Database Technologies: Strong knowledge of databases technologies Strong data related programming skills (SQL) Data Warehousing: Understanding of data warehouse design principles (star schema, snowflake schema, data vault) ETL Processes: Familiarity with ETL tools and data integration techniques. Experience of working in Finance related data development ...

quality frameworks. Database Technologies: Strong knowledge of databases technologies Strong data related programming skills (SQL) Data Warehousing: Understanding of data warehouse design principles (star schema, snowflake schema, data vault) ETL Processes: Familiarity with ETL tools and data integration techniques. Experience of working in Finance related data development ...

Development Design and develop enterprise data warehouse solutions using Azure SQL Database/Azure SQL Managed Instance/Azure Synapse Analytics. Build and maintain star and snowflake schemas for analytical workloads. Develop ETL/ELT pipelines for ingesting and transforming data from multiple source systems. Implement data partitioning, indexing … Analysis Expressions). Experience with Power BI semantic models or Azure Analysis Services/SQL Server Analysis Services (SSAS). Strong data modeling skills (star schema, dimensional modeling). Azure & Data Engineering Experience with: Azure Synapse Analytics Azure Data Factory or similar ETL tools Azure Storage/Data ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

analytics across global operations. Key Responsibilities Architect, design, develop, and maintain enterprise-level Power BI reports and datasets Build and govern advanced data models (star schema, dimensional modelling, enterprise structures) Optimise datasets, composite models, and DAX performance for scalability Lead ETL/ELT design within Microsoft Fabric Lakehouse ...

including indexing, optimisation and partitioningBackground in financial or investment data environmentsAdvanced SQL and Python skillsExperience migrating data from platforms like DatabricksConfident with dimensional modelling, star schemas, SCDs etc.Experience within regulated financial servicesDesirableExperience in pensions, asset management or institutional investingUnderstanding of performance measurement and attributionExposure to Airflow or dbtCloud platform ...

Synapse/OneLake) Experience building and managing data pipelines and workflow orchestration tools (e.g. Airflow, Data Factory) A solid understanding of data modelling (e.g. star schemas, SCD) and governance principles Experience implementing data quality testing and validation Familiarity with CI/CD and version control (e.g. Git, GitHub Actions ...