1 to 25 of 34 Star Schema Jobs in England

data pipelines and supporting a modern data platfor 4-8+ years Data Engineering experience SQL Expert with Python and ETL Data Modelling Kimball Star Schema Our client is a well-established UK organisation investing heavily in its data capability and looking for an experienced Data Engineer … Python experience Hands-on ETL development experience, such as SSIS or equivalent tools Knowledge of data warehouse design and dimensional modelling using Kimball or Star Schema approaches Experience with cloud-based data platforms, including Azure Data Factory, Microsoft Fabric or similar technologies Preferred Qualifications Degree in Computer Science ...

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

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

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

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

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

scalable, high-performance data pipelines using Azure Data Factory and Fabric. Engineer lakehouse architectures using medallion layers (Bronze, Silver, Gold). Design and implement star schemas and analytical data models aligned to business needs. Develop and optimise data transformations using PySpark/Spark. Integrate data from on-premises ...

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

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

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

documentation, and managing a project structure Ability to translate business logic and organisational rules into data model design Experience building curated or semantic layers — star schemas or similar Excellent communication skills — able to work closely with non-technical stakeholders to understand and codify their data needs Outstanding attention ...

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

Power BI Strong working knowledge of Git/version control, CI/CD pipelines, and Python for automation Solid understanding of star schemas and Kimball methodologies Experience supporting advanced Power BI models (DAX and Power Query) Exposure to ML/AI concepts (e.g. scikit-learn, TensorFlow) or an interest ...

best practices across client environments. Provide technical leadership and architectural guidance to engineering teams. Design and optimise data models including 3NF, Data Vault, Star Schema, and OBT approaches. Partner with stakeholders to develop data strategies aligned to business objectives. Collaborate with engineering and data science teams to deliver ...

Skills Working knowledge of SAS (especially in ETL context) Experience in migrating SAS workloads to Informatica ETLs Familiarity with data modelling (dimensional modelling/star schema) Exposure to scheduling tools (e.g., Control-M, Autosys) Understanding of data governance and data quality frameworks ...

Snowflake Innovation: Drive CDC-based incremental processing using Snowflake Streams, Tasks, Snowpipe, Dynamic Tables, and Stored Procedures. Data Modeling: Design robust fact, dimension, and star schema models while focusing on query performance and cost optimization. Collaboration: Partner with Agile cross-functional teams and clearly translate complex data concepts ...