1 to 25 of 50 Permanent Star Schema Jobs in the UK

assess technical feasibility, evaluate trade-offs, and translate product requirements into maintainable, scalable technical solutions.Build and maintain production-ready Python services, SQL transformation layers, star-schema data models, and API integrations across relational databases and cloud storage (Azure Data Lake).Optimise pipeline performance, system reliability, compute efficiency … knowledge-sharing, while systematically refactoring technical debt and maintaining operational runbooks.Experience that contributes to success:Substantial experience designing, building, and operating production data platforms, star-schema data models, and complex ELT/ETL pipelines.Advanced proficiency in Python and SQL, including clean object-oriented design, Pandas, query optimization ...

insights into enterprise grade, productionised reporting. What You'll DoOwn the Gold Layer: Build and optimize high-performance Power BI semantic models and star-schema architectures within a Unified, AI-powered analytics platformProductionize Reports: Review, refine, and promote reports from domain workspaces (Finance, Financial Crime, Marketing) into central … level security (RLS).What You BringSignificant hands on experience productionising Power BI reports and managing live estates. Deep expertise in DAX, dimensional modelling (star schema), and layered data architectures. Demonstrable excellence with SQLExposure to Microsoft Fabric, Azure Synapse, or Azure Data FactoryHigh technical rigor and diplomatic communicationYou catch ...

PySpark, Spark SQL, T-SQL and KQL, optimizing Delta tablesAdd data quality checks, validation rules, logging and alerting to data pipelinesBuild enterprise semantic models (star schema) using Direct Lake, Import or DirectQuery as specified in the architectureWrite efficient DAX measures, calculation groups and Power Query (M) transformationsBuild reports ...

development Proven experience building batch and streaming data pipelines Experience implementing Medallion Architecture and Lakehouse patterns Strong understanding of data modelling techniques (dimensional, star schema, data vault) Experience with CI/CD, Infrastructure as Code and DevOps practices, Git-based source control and deployment pipelines Strong understanding ...

Server, Azure SQL Database and T-SQL. Experience with ETL/ELT and data integration tools, ideally Informatica. Strong understanding of dimensional modelling, including Star Schema. Experience optimising BI models, queries and reporting performance. Understanding of Power BI Service administration and governance. Experience working in an agile environment, ideally ...

Design, implement and maintain scalable ETL/ELT pipelines, ensuring data quality, integrity and reconciliation throughout the migration. Develop and optimise data warehouse structures, star schemas and dimensional models to support business and regulatory reporting. Apply best practices for Snowflake performance tuning, query optimisation and cost efficiency. Implement automated … design, query optimisation, performance tuning and troubleshooting. Significant experience designing and delivering enterprise-scale ETL/ELT solutions. Strong understanding of data warehousing principles, star schema design, dimensional modelling and data architecture. Experience with data governance, data quality and reconciliation within enterprise environments. Familiarity with Git-based source ...

https://www.mclh.co.uk/careers/employee-benefits/) What you will be doing Design, develop and maintain Power BI semantic models, including star schemas, relationships, calculated measures and DAX. Develop clear, intuitive and well-organised Power BI reports and dashboards, as well as maintaining and improving existing … measures, filter context and relationships. Good SQL development skills, including joins, aggregations, and window functions. Good understanding of dimensional modelling, including facts, dimensions and star-schema design. Experience working with relational databases and data warehouse environments. Strong attention to detail and a disciplined approach to validating the accuracy ...

experience building and optimising semantic or data models at scale, including window functions and complex business logic. Solid understanding of data modelling principles — star schema, dimensional modelling, DAX.Experience with Power BI and the Microsoft Power Platform, including building on top of central/curated data models. Familiarity with ...

plus years in a solution architect roleOne-plus year of Microsoft Fabric experienceTwo-plus years of Power BI experience: enterprise semantic model design, star schema modeling, DAX concepts, performance and capacity management and tenant administrationEnough hands-on ability to validate prototypes, review pipelines, notebooks, semantic models ...

data from APIs, databases, CRM, ERP and third party platforms • Support both batch and real time data processing • Develop semantic models and work with Star Schema and Kimball modelling • Implement CI/CD and automated deployment of data solutions • Build monitoring, data quality, lineage and observability into data ...

Python and statistical modelling techniques. Experience working with Snowflake or similar cloud-based data warehouse technologies. Understanding of data modelling principles, including dimensional and star schema modelling. Experience with Power BI and data visualisation best practices. Familiarity with CI/CD processes, version control, testing, and software development ...

within the insurance industry, ideally with exposure to Delegated Authority and/or Large Single Risk/Specialty business Familiarity with dimensional modelling concepts (star schemas, slowly changing dimensions) as applied within a modern lakehouse environmentThought Leaders: You are seen as an expert in your field and will ...

optimisation Stakeholder engagement and requirements gathering Communicating technical concepts to non-technical audiences Designing scalable reporting solutions using best-practice methodologies such as Kimball, Star Schema, or Medallion Architecture Azure DevOps or CI/CD processes Azure Databricks Databricks Genie or AI-assisted analytics tools Microsoft Fabric Agile ...

Snowflake)Proven experience with dbt (modelling, testing, documentation)Experience building dashboards in Looker (LookML is a strong plus)Solid understanding of data modelling concepts (star schema, dimensional modelling)Experience working with large-scale datasetsStrong communication skills with the ability to work with non-technical stakeholdersNICE TO HAVEHands ...

with Microsoft Fabric, Azure Databricks and Azure Data Factory. Solid knowledge of Delta Lake, Medallion Architecture, PySpark and SQL. Expertise in dimensional modelling and star schema design. Advanced Power BI development, including DAX and semantic modelling. Experience with Azure security, governance, DevOps and CI/CD practices. Proven ...

Proven ETL development and data pipeline experience. Solid understanding of data warehousing principles and best practices. Experience with dimensional modelling, including concepts such as star schema, semantic models, tabular models and Kimball methodologies. Exposure to DAX development. Experience working across complex data environments and multiple stakeholders. Strong problem ...

financial reporting solutions, including dashboard design and data visualisationStrong technical knowledge of ERP-derived financial data, data extraction and transformation, reconciliation, data quality and Star Schema dimensional modelling.Experience with Microsoft Fabric, Direct Lake, SQL, DAX and M Coding. Proven ability to develop team capability, strengthen technical reporting skills ...

building and designing products that use both real-time and batch data at scale, and an understanding of the underlying data architecture (e.g. lakehouse, star schema).Ability to write and validate SQL queries, and to trace data flows end-to-end to ensure data quality.Awareness ...

building and designing products that use both real-time and batch data at scale, and an understanding of the underlying data architecture (e.g. lakehouse, star schema).Ability to write and validate SQL queries, and to trace data flows end-to-end to ensure data quality. Awareness ...

high-performance solutions aligned with your target data architecture. Master Data Modeling Techniques – Apply expertise in various data modeling approaches, including 3NF, Data Vault, Star Schema, and One Big Table (OBT). Clearly articulate the benefits and trade-offs of each method and optimize their implementation within columnar ...

building and maintaining ETL processes and data pipelines Solid understanding of data warehousing concepts and dimensional modelling Experience working with semantic models, tabular models, star schemas, Kimball methodologies, or similar data modelling approaches Exposure to SSAS, DAX, and BI solution development Experience working across different data architectures and technology ...

will have strong commercial experience with: SQL Server and SQL development. ETL development and data pipeline engineering. Data warehousing principles and dimensional modelling. Star schema, Kimball methodologies, semantic models, and tabular models. DAX. Working within fast-paced delivery environments. Communicating effectively with both technical and non-technical stakeholders. ...

strong hands-on experience with PySpark. Proven experience working with Databricks and Lakehouse architectures. Strong understanding of dimensional modelling, including fact tables, dimension tables, star schemas and semantic layers. Experience developing curated, analytics-ready datasets for business intelligence and analytics consumption. Ability to translate complex business requirements into well ...

Isio’s DBA strategy. Working with relevant stakeholders. Own and maintain the database architecture for Isio's data warehouses and connected operational systems, including schema design, indexing strategy and query optimisation. Operational and technical responsibility for the data systems. Define and enforce database backup schedules, test restore procedures … maintain database health. Monitor database performance, capacity, and availability; proactively address bottlenecks and plan for data growth. Manage database change control processes, including schema version control and change-freeze enforcement across systems. Work closely with data and solution architects providing technical expertise and design leadership for the delivery ...

across Microsoft Fabric and Azure, aligned with global business goals. Design the Data-to-AI Interface: Establish how enterprise data is structurally modelled (using star schemas, semantic layers, dimensional modelling, and knowledge ontologies) to ensure autonomous AI agents can search, retrieve, and reason over data reliably without hallucinating. Pioneer ...