1 to 25 of 28 Star Schema Jobs in the UK excluding London

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

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

processing. Work with AWS services such as DMS, Glue, Lambda, Step Functions, S3, Redshift, Athena, RDS, EC2, and CloudWatch. Design and implement data models (Star Schema, Snowflake Schema) to support downstream BI and analytics dashboards. Perform data validation, reconciliation, and quality checks across migration and ingestion pipelines. ...

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

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

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

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

logic in a data warehousing environment. Experience designing and maintaining ETL pipelines and data integration processes. Strong experience of Kimball data modelling techniques (e.g. star schema, dimensional modelling). Experience working within a Microsoft data stack (e.g. SQL Server, Azure Data Factory, Azure Synapse, Microsoft Fabric, or similar ...

Collaborate with business stakeholders to deliver scalable data solutions. Required Skills: Minimum 2 years' experience working with Microsoft Fabric. Strong experience in data modelling (Star Schema, dimensional modelling). Strong SQL skills and experience with data warehousing concepts. Experience with Power BI and semantic models. Knowledge ...

manipulating, and analysing data from relational databases. Experience building dashboards and reports using Power BI. Understanding of data modelling principles, including dimensional modelling and star schema design. Experience gathering, documenting, and translating business requirements into analytical solutions. Knowledge of ETL processes, data integration, and data quality management. Experience ...

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

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

with building Oracle OTBI reports Experience building automated workflows or integrations. Knowledge of SQL queries on SQL Server and Reporting data warehouse concepts like star schema and normalizations etc. Discover why our teams love working here: Where do we start! Our benefits package includes: We offer a package ...

user stories and acceptance criteria into effective reporting and analytical solutions * Designing and developing semantic models aligned to best-practice dimensional modelling approaches (e.g., star schema principles) * Collaborating with Business Analysts and Data Engineers to ensure requirements are clear and underlying data structures support reporting needs * Optimising report ...

Power BI (critical – minimal ramp-up) Strong data modelling/DAX/SQL/data transformation Experience with large datasets/semantic models/star schema Exposure to Azure/data platforms (nice to have but helpful) Strong Excel Other must haves Commercial/business-facing analytics: Sales ...

design and development of conceptual, logical, and physical data models for enterprise data platforms and analytics solutions Develop and implement dimensional models including Star Schema, Snowflake, Data Vault, and Canonical Data Models Design scalable data models across relational, cloud, and big data environments Collaborate with enterprise architects, business ...

WORK AREAS Power BI Development Design, develop, and maintain Power BI reports, dashboards, and paginated reports. Build and optimise Power BI semantic models, including star schemas, relationships, measures, and row-level security. Create and maintain dataflows and shared datasets to support enterprise reporting. Data Modelling & Architecture Apply dimensional modelling ...

similar cloud data warehouse) Experience migrating from legacy BI/reporting tools (e.g. SSRS, Cognos, Business Objects) Strong data modelling experience (dimensional modelling, star schemas, etc.) Experience building transformation layers in ELT environments Track record of delivering in hands-on roles (not purely architectural) Highly Desirable Experience with ...