19 of 19 Permanent Star Schema Jobs in the UK

design and delivery at scale (high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata/SQL Server/Snowflake … design and delivery at scale (high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata/SQL Server/Snowflake More ❯

design and delivery at scale (high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata/SQL Server/Snowflake … design and delivery at scale (high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata/SQL Server/Snowflake More ❯

of the Microsoft Stack (SQL Server, SSMS, SSIS & SSRS), Power BI and Azure DevOps. By building robust data platforms, pipelines, and catalogues and by defining the metadata, models and schema that underpin our data decision-making, you'll be right at the heart of modernising and improving the way we do things. Accountabilities Implement enterprise data models, pipelines, and … and orchestration tasks. Advanced database manipulation and administration skills, particularly T-SQL, Azure SQL, as well as capacity with unstructured and unlinked data management languages. Experience using and implementing schema and metadata design (e.g., star schema, snowflake, normal forms), with strong understanding of master and reference data management. Experience working with Azure/GCP building and managing More ❯

lead role in delivering our analytical data into the NHS National Data Analytics Platform. By building robust data platforms, pipelines, and catalogues and by defining the metadata, models and schema that underpin our data decision-making, you'll be right at the heart of modernising and improving the way we do things. You'll be working collaboratively with other … ability to define and implement modern enterprise data architectures, including data lakes, data warehouses, and data mesh/data fabric concepts Experience designing logical and physical data models (e.g., star schema, snowflake, third normal form), with strong understanding of master and reference data management. Strong understanding of modern enterprise data architecture principles, including data warehousing, data lakes, and More ❯

training to empower end users. PRINCIPAL MISSIONS Design and implement data pipelines using Azure Data Factory or Microsoft Fabric. Develop and maintain SQL-based transformations and data models (e.g., star schema, snowflakes) in SQL Server, Fabric Datawarehouse/Lakehouse. Build and optimize Power BI dashboards and reports to support business decision-making. Collaborate with stakeholders to gather requirements More ❯

for recurring tasks in line with documentation standards. Essential Skills & Experience Proficient in working with UK mortgage data, including portfolio onboarding, new lending, and securitisations. Experience with Kimball-based star schema data warehouses. Strong capabilities in reporting and data visualisation using: Microsoft SQL Server T-SQL Power BI SSRS Microsoft Excel Azure DevOps Performance tuning techniques Solid understanding More ❯

of the data across the organisation. We need a few basics from you: Data pipeline creation Strong ETL development experience with Azure Data Factory Datawarehouse and data storage concepts - star schema/snowflake/Kimball Azure Databricks and AI Power BI reporting skills would be advantageous Strong stakeholder management experience After a few weeks of induction and meeting More ❯

of the data across the organisation. We need a few basics from you: Data pipeline creation Strong ETL development experience with Azure Data Factory Datawarehouse and data storage concepts - star schema/snowflake/Kimball Azure Databricks and AI Power BI reporting skills would be advantageous Strong stakeholder management experience After a few weeks of induction and meeting More ❯

Detail: Keep continuity across reports created by the team while maintaining accuracy and consistency, ensuring insights are reliable and actionable. Who we're looking for Knowledge Designing Kimball/star schema data models. Agile Methodology. Solar and BESS knowledge (Desirable) Qualifications Bachelor's degree in computer science, mathematics, statistics or engineering discipline. Microsoft Power BI Certification. Experience High More ❯

solutions that power advanced analytics and business intelligence. What You'll Do: Architect and build scalable data pipelines using Microsoft Fabric, PySpark, and T-SQL Lead the development of Star Schema Lakehouse tables to support BI and self-service analytics Collaborate with stakeholders to translate business needs into data models and solutions Mentor engineers and act as a More ❯

solutions that power advanced analytics and business intelligence. What You'll Do: Architect and build scalable data pipelines using Microsoft Fabric, PySpark, and T-SQL Lead the development of Star Schema Lakehouse tables to support BI and self-service analytics Collaborate with stakeholders to translate business needs into data models and solutions Mentor engineers and act as a More ❯

solutions that power advanced analytics and business intelligence. What You'll Do: Architect and build scalable data pipelines using Microsoft Fabric, PySpark, and T-SQL Lead the development of Star Schema Lakehouse tables to support BI and self-service analytics Collaborate with stakeholders to translate business needs into data models and solutions Mentor engineers and act as a More ❯

solutions that power advanced analytics and business intelligence. What You'll Do: Architect and build scalable data pipelines using Microsoft Fabric, PySpark, and T-SQL Lead the development of Star Schema Lakehouse tables to support BI and self-service analytics Collaborate with stakeholders to translate business needs into data models and solutions Mentor engineers and act as a More ❯

application SQL Server database performance and SQL tuning Experience in handling large databases Knowledge of column store indexes Very good SSRS skills Data warehouse experience, design of data marts, star schemas and type 2 slowly changing dimensions Data analysis skills Desirable Skills and Knowledge: Experience with tSQLt unit testing Understands the Agile software development lifecycle and working knowledge of More ❯

extension. This role offers a hybrid working arrangement, requiring 1-2 days per week onsite at Heathrow, Hounslow, with on-site parking available. Responsibilities: Data Modelling: Design and optimize star schema data models tailored to our client's business needs for streamlined analytics and reporting. Collaboration: Work closely with data architects, BI developers, and business analysts to translate … governance practices to ensure accuracy and integrity within data models. Skills/Must have: Proven experience in data modelling using Kimball methodology, with a focus on dimensional modelling and star schemas. Strong proficiency in SQL and experience with data modelling tools like ER Studio, Power Designer, or similar. Ability to translate complex business needs into structured, efficient data models. More ❯

teams and key stakeholders to identify, plan, develop and deliver data services to meet business requirements. Ensure appropriate documentation is produced mapping data from Source to Data Mart. Ensure Schema Diagrams are produced to inform report authors of the Data Model structure. Work with the Data Warehouse Lead and the wider team on the development of the data Warehouse … and supporting the team, enabling them to deliver departmental goals. Person specification Working in a Data Warehouse team creating ETL routines A working knowledge of Data Modelling techniques e.g. Star schema Previous experience of managing a team Essential Technical Skills: Experience of implementing Data Warehouse concepts. Experience of using Databases Experience of using ETL tools Desirable Technical Skills More ❯

on experience working with UK mortgage data (e.g. onboarding, lending, redemptions, securitisation) Strong technical skills with Power BI, T-SQL, SSRS and Excel (advanced) Experience working with Kimball/star schema data warehouse environments Ability to interpret business requirements and apply software development lifecycle principles Exposure to regulatory environments and reporting in financial services (e.g. Consumer Duty, TCF More ❯

will: Digest data requirements, gather and analyse large scale structured data and validate by profiling in a data environment Understand data structures and data model (dimensional & relational) concepts like Star schema or Fact & Dimension tables, to design and develop ETL patterns/mechanisms to ingest, analyse, validate, normalize and cleanse data Liaise with data/business SME to More ❯

will: Digest data requirements, gather and analyse large scale structured data and validate by profiling in a data environment Understand data structures and data model (dimensional & relational) concepts like Star schema or Fact & Dimension tables, to design and develop ETL patterns/mechanisms to ingest, analyse, validate, normalize and cleanse data Liaise with data/business SME to More ❯