1 to 25 of 27 Star Schema Jobs in the UK

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 ❯

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 ❯

user stories Building and optimising Power BI reports in line with stakeholder requirements Querying and transforming data from SQL Server and Snowflake Transforming data using PowerQuery Modelling data into STAR schemas What makes a great Grayce Analyst? Analytical Problem Solving: We're looking for analytical minds that can spot patterns and think creatively. Whether it's dissecting complex issues 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 ❯

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 ❯

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 ❯

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 ❯

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 ❯

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 ❯

producing reporting and BI through Qlikview or similar BI tools Ability to interpret data to provide insight and direction based on findings Experience of designing data structures (dimensional/star schemas) and optimising performance Able to prioritise multiple tasks and work under pressure for senior business people Experience working with complex data structures Essential Skills: Effective communicator with good More ❯

and non-technical audiences, tailoring communication style based on the audience. Data Modeling and Warehousing: •Design and implement data models optimized for analytical workloads, using dimensional modeling techniques (e.g., star schema, snowflake schema). •Participate in the design, implementation, and maintenance of data warehouses ensuring data integrity, performance, and scalability. BASIC QUALIFICATIONS •Educational Background: Bachelor's or … Analysis Skills: Working knowledge of R or Python for analytics, data manipulation, and algorithm development. •Data Warehousing Knowledge: In-depth knowledge of data warehousing principles, dimensional modeling techniques (e.g., star schema, snowflake schema), and data quality management. •Communication and Collaboration Abilities: Excellent verbal and written communication skills, with the ability to effectively communicate technical concepts; experience gathering 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 ❯

Agile methodologies, and an interest in working in an iterative, team-based environment. Interest in data modelling for analytics, with a willingness to develop understanding of concepts such as star schemas, fact/dimension tables, and modelling for performance. Qualifications Essential Minimum of 5 GCSEs or equivalent at grade 4 (grade C) or above. Relevant Level 3 qualifications that More ❯

databases, REST APIs, Kafka streams and other sources. Apply data cleansing rules to ensure high data quality standards. Model data into a single source of truth using Kimball methodology (star schema, snowflake, etc.). Develop high-quality code following DevOps and software engineering best practices, including testing and CI/CD. Monitor and maintain business-critical pipelines, reacting More ❯

ETL/ELT processes and best practices. Experience with data visualization tools such as 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 collaborate with cross-functional teams. Background in data governance 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 ❯

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 ❯

user stories Building and optimising Power BI reports in line with stakeholder requirements Querying and transforming data from SQL Server and Snowflake Transforming data using PowerQuery Modelling data into STAR schemas What makes a great Grayce Analyst? Analytical Problem Solving: We're looking for analytical minds that can spot patterns and think creatively. Whether it's dissecting complex issues 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 ❯

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 ❯

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 ❯