26 to 50 of 54 Star Schema Jobs in London

Data Engineer

Hiring Organisation
Motability Operations
Location
City of London, London, United Kingdom
Employment Type
Permanent, Part Time
building a data warehouse using an ETL/ELT tool, preferably Oracle ODI or dbt Significant database experience in Snowflake and/or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions ...

Data Engineer

Location
Islington, North London, United Kingdom
building a data warehouse using an ETL/ELT tool, preferably Oracle ODI or dbt Significant database experience in Snowflake and/or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions ...

Power BI developer (Contract/London)

Hiring Organisation
Tenth Revolution Group
Location
London, South East England, United Kingdom
Employment Type
Full-Time
Salary
£400.00 - £500.00 per day
they're looking for: 5+ years experience in Power BI report & dashboard development Advanced DAX and data modelling SQL and large-scale data analysis Star schema, fact & dimension modelling Power BI Service, Apps & Deployment Pipelines 3+ years experience with Databricks and exposure to Microsoft Fabric Stakeholder engagement ...

Lead Analytics Engineer

Hiring Organisation
Funding Circle
Location
London, UK
Employment Type
Full-time
strategy, sets standards for data modelling, transformations, and governance. Leads the design and implementation of new features,, such as the creation of a new star schema and other best practices to optimise data usability. Sets best practices and standards on how we use SQL & dbt/Python/ ...

Senior Manager, Data Engineering

Hiring Organisation
Momentum Worldwide
Location
London, UK
Employment Type
Full-time
Storage, Pub/Sub, and Cloud SchedulerExperience with Infrastructure as Code (Terraform) for provisioning and managing cloud resources. Solid understanding of data modelling techniques (star schema, dim/fact architecture, slowly changing dimensions).Comfortable with Git (GitHub, branching strategies, pull requests) and CI/CD (Cloud Build ...

Data Architect

Hiring Organisation
Methods Consulting
Location
London, UK
Employment Type
Full-time
Server, CosmosDB, Azure Data Factory, Purview, Synapse, Event Hub, Azure Databricks/Fabric) Extensive data modelling experience: both normalised relational models and de-normalised Star Schema/dimensional models Excellent relational database design skills with expertise in diagnosing and optimising performance across SQL Server, PostgreSQL, and cloud databases ...

Senior Data Engineer (Remote within the UK)

Location
Greater London, England, United Kingdom
configuration, governance, orchestration, user management, engineering best practices. Data modelling: You're comfortable designing schemas and data models, including medallion architecture and Kimball/Star Schema concepts (Fact and Dimension tables), from the ground up. Git: You're fluent in Git workflows — branching, troubleshooting, code reviews. Python/ ...

BI Developer (SQL, Data Modelling, Power BI)

Location
Greater London, England, United Kingdom
skills, including views, stored procedures and query optimisation. A good understanding of Kimball data modelling concepts including grain, surrogate keys, conformed dimensions, and star schemas. Experience turning raw or operational data into trusted, business‐ready datasets. The ability to investigate complex data issues and work through them logically. Confidence ...

Python Engineer Data Domains

Location
Greater London, England, United Kingdom
team spirit Nice-to-Have Data Governance & Quality Hands-on experience with: Data Quality Data Governance practices Familiarity with modelling approaches such as: Star Schema OBT Knowledge of modern architectures: Medallion Lambda Kappa Experience building or contributing to cloud-based data platforms AWS preferred Familiarity with: S3 Glue ...

Senior Analytics Engineer

Location
Greater London, England, United Kingdom
system observability, and experience with source control tools like GitHub. Hands on experience with dbt or similar transformation tools. Strong data modelling principles, including star schema, and best practices for building scalable data assets that can be used in BI and other user facing tools. Experience working with ...

BI Developer (SQL, Data Modelling, Power BI) London en-GB

Location
Greater London, England, United Kingdom
skills, including views, stored procedures and query optimisation. A good understanding of Kimball data modelling concepts including grain, surrogate keys,conformed dimensions, and star schemas. Experience turning raw or operational data into trusted, business-ready datasets. The ability to investigate complex data issues and work through them logically. Confidence ...

Data Solutions Architect

Location
Greater London, England, United Kingdom
marts and business specific data products. Ability to model complex business relationships, hierarchies, and many-to-many relationships. Proficiency in dimensional modelling techniques including star schemas, snowflake schemas, facts, dimensions, and slowly changing dimensions (SCDs). Experience producing ERDs, logical data models, business data models, and data dictionaries. Strong ...

Data Solutions Architect

Hiring Organisation
Arthur J. Gallagher & Co
Location
London, UK
Employment Type
Full-time
marts and business specific data products. Ability to model complex business relationships, hierarchies, and many-to-many relationships. Proficiency in dimensional modelling techniques including star schemas, snowflake schemas, facts, dimensions, and slowly changing dimensions (SCDs).Experience producing ERDs, logical data models, business data models, and data dictionaries. Strong knowledge ...

Senior Software Engineer II - Data Onboarding & Reporting

Location
Greater London, England, United Kingdom
infrastructure using Trino/Presto and open table formats like Apache Iceberg or Delta Lake. Advanced Data Modeling: Deep expertise in Medallion Architecture patterns, Star Schemas, and processing semi-structured financial data logs (JSON/Avro). Robust ETL/ELT Orchestration: Expert proficiency in data transformation engines (such ...

Senior Manager, Solution & Data Architecture

Location
Greater London, England, United Kingdom
budgets for an architecture or engineering function. Strong technical foundation across the data platform stack: Databricks lakehouse architecture (Delta Lake, medallion patterns), Azure Synapse (star schemas, dedicated pools), and data pipeline orchestration (ADF or Databricks Workflows). Experience with data quality frameworks, data contracts, and computational governance approaches. Understanding ...

Senior Project Controls Data & Reporting Analyst

Location
Greater London, England, United Kingdom
wider Project Controls community by sharing lessons learned, best practice, and innovations.## About you* Expertise in **Power BI dashboard development**, including dataset design, star-schema modelling (fact/dimension tables), and relationship management.* Strong, demonstrable experience **working in Project Controls** within the **construction or infrastructure sector** (this ...

BI Developer SQL – (SSIS, SSAS)

Hiring Organisation
Quant Capital
Location
London, United Kingdom
Salary
£ 70 K
Server. Must have familiarity using either SQL 2012 or SQL 2014Experience in integrating data from external sources via API calls or FTP downloadsUnderstanding of Star Schema and Database design using accepted best practice and Kimball methodologies.Strong Knowledge of T-SQL – must have a good understanding of stored procedures ...

BI Developer SQL - (SSIS, SSAS)

Hiring Organisation
Quant Capital
Location
London, UK
Employment Type
Full-time
Server. Must have familiarity using either SQL 2012 or SQL 2014Experience in integrating data from external sources via API calls or FTP downloadsUnderstanding of Star Schema and Database design using accepted best practice and Kimball methodologies. Strong Knowledge of T-SQL – must have a good understanding of stored ...

Senior Information Architect-London

Location
Greater London, England, United Kingdom
coding assistant experience in a professional setting Financial services background preferred; BCBS 239 awareness advantageous Desirable skills include: Data Vault 2.1 alongside Kimball/Star‐schema modelling Data mesh, data product ownership and federated governance Knowledge graph platforms (Neo4j, Neptune) or knowledge of OWL, RDF and exposure ...

Senior Information Architect-London

Hiring Organisation
Northern Trust
Location
London, UK
Employment Type
Full-time
equivalent AI coding assistant experience in a professional settingFinancial services background preferred; BCBS 239 awareness advantageousDesirable skills include: Data Vault 2.1 alongside Kimball/Star-schema modellingData mesh, data product ownership and federated governanceKnowledge graph platforms (Neo4j, Neptune) or knowledge of OWL, RDF and exposure to and build ...

Analytics Engineer

Hiring Organisation
Adecco
Location
London, United Kingdom
Employment Type
Contract
Contract Rate
£450 - £465/day
skills with experience building analytical data models. Experience working with cloud data platforms such as GCP/BigQuery. Strong understanding of dimensional modelling, star schemas and data warehousing concepts. Experience developing reporting datasets and enabling self-service analytics. Ability to engage with business stakeholders and translate requirements into data ...

Analytics Engineer

Hiring Organisation
Adecco
Location
London, South East England, United Kingdom
Employment Type
Full-Time
Salary
£450.00 - £465.00 per day
skills with experience building analytical data models. Experience working with cloud data platforms such as GCP/BigQuery. Strong understanding of dimensional modelling, star schemas and data warehousing concepts. Experience developing reporting datasets and enabling self-service analytics. Ability to engage with business stakeholders and translate requirements into data ...

Junior Analytics Engineer

Location
Greater London, England, United Kingdom
pieces you own, growing into more complex transformation work as your confidence builds. Learn dimensional modelling in practice (fact/dimension design, star schemas) through paired work with the Data Engineer, rather than being expected to make these calls solo from day one. Help identify manual Excel-based consolidation … relational databases, including joins and aggregation, and ready to build up to more complex transformation work. Dimensional modelling — you understand fact and dimension design, star schemas, keys and granularity, and what goes wrong downstream when they are off. We do not expect years of it, but you should ...

Data Engineer III - Python, Databricks - Senior Associate

Hiring Organisation
JP Morgan Chase
Location
London, UK
Employment Type
Full-time
skillsFamiliarity with the Standardized data layer practices (Medallion architecture)Exposure to Aurora Postgres and MongoDBSkills in designing efficient data models including normalization, denormalization, and schema design and an understanding around relational and star schemas.J.P. Morgan is a global leader in financial services, providing strategic advice and products ...

Data Engineer III - Python, Databricks - Senior Associate

Location
Greater London, England, United Kingdom
with the Standardized data layer practices (Medallion architecture) Exposure to Aurora Postgres and MongoDB Skills in designing efficient data models including normalization, denormalization, and schema design and an understanding around relational and star schemas. #J-18808-Ljbffr ...