20 of 20 Star Schema Jobs in England

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 ❯

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 ❯

Proficiency in ETL/ELT processes and best practices - Experience with data visualization tools (Quicksight) Required Skills: - Strong analytical and problem-solving abilities - Excellent understanding of dimensional modeling and star schema design (Facts, dimensions, scd type 2) - Experience with agile development methodologies - Strong communication skills and ability to work with cross-functional teams - Background in data governance and More ❯

Proficiency in ETL/ELT processes and best practices - Experience with data visualization tools (Quicksight) Required Skills: - Strong analytical and problem-solving abilities - Excellent understanding of dimensional modeling and star schema design (Facts, dimensions, scd type 2) - Experience with agile development methodologies - Strong communication skills and ability to work with cross-functional teams - Background in data governance and More ❯

Proficiency in ETL/ELT processes and best practices - Experience with data visualization tools (Quicksight) Required Skills: - Strong analytical and problem-solving abilities - Excellent understanding of dimensional modeling and star schema design (Facts, dimensions, scd type 2) - Experience with agile development methodologies - Strong communication skills and ability to work with cross-functional teams - Background in data governance and More ❯

Proficiency in ETL/ELT processes and best practices - Experience with data visualization tools (Quicksight) Required Skills: - Strong analytical and problem-solving abilities - Excellent understanding of dimensional modeling and star schema design (Facts, dimensions, scd type 2) - Experience with agile development methodologies - Strong communication skills and ability to work with cross-functional teams - Background in data governance and 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 ❯

design and rollout. Hands on experience with business intelligence tools, data modelling, data staging, and data extraction processes, including data warehouse and cloud infrastructure. Experience with multi-dimensional design, star schemas, facts and dimensions. Experience and demonstrated competencies in ETL development techniques. Experience in data warehouse performance optimization. Experience on projects across a variety of industry sectors an advantage 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 ❯

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 ❯

a senior, you'll be responsible for mentoring MI Analysts, improving how operational reporting is delivered, and playing a key role in translating existing SQL-based reports into modern star-schema structures. You'll work across retail operations, smart metering, customer support, and market interaction, delivering insights that directly impact B2B customer performance and experience. What you'll … day leadership Owning the delivery of key operational reporting across smart meters, contact centres, faults, goodwill, and more Leading the transition of reporting from legacy SQL statements to new star schema models Building and optimising Power BI dashboards for improved speed, usability, and future self-serve functionality Collaborating with the business to deliver insights in line with agile … BI, including DAX, data modelling, and report optimisation Experience coaching or mentoring junior analysts in a structured environment Bonus if you've been involved in data warehouse redesigns or schema transitions Why this role? This is a genuinely exciting time to join. The MI function has moved away from central transformation and now sits closely aligned to the business 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 ❯

APIs and Loosely Coupled architectures API Management tools including IBM API Connect and AWS API Gateway Understanding of Canonical messaging, Corporate Information modelling and general data modelling techniques (3NF, Star schema, Extended Star Schema, Data Vault and relational database design) Understanding and application of different development styles, eg agile (XP, TDD, SCRUM), iterative, spiral, waterfall. Service 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 ❯

cross-functional stakeholder management, and streamlining manual processes into automated flows. Familiarity with pharmaceutical compliance risks or compliance considerations for stakeholder engagements is a plus. Fluency in SQL, PowerQuery, star-schemas, DAX, or similar coding languages and approaches is preferred but not required. Are you ready to 'go beyond' to create value and make your mark for patients? If More ❯