15 of 15 Star Schema Jobs in London

source systems into the cloud data platform. Design and govern data transformation frameworks using DBT. Define and enforce data modelling standards including dimensional modelling, star schema, and enterprise data models. Lead architecture reviews and solution design discussions for new data initiatives. Optimize Snowflake performance, workload management, and cost … Python (preferred) for automation and data engineering tasks. Data Engineering Enterprise ETL/ELT pipeline architecture Data warehousing and enterprise data modelling Dimensional modelling (Star Schema, Snowflake Schema) Data pipeline scalability and reliability design. AI/Data Science Exposure Experience supporting AI/ML data pipelines ...

govern enterprise data architectures using Microsoft Foundry, Azure Data Factory, ADLS, Synapse, and Databricks (Spark & Delta Lake). Lead data modelling initiatives including star schema and lakehouse patterns. Architect end-to-end ETL/ELT pipelines and integration strategies. Ensure solutions meet NHS standards (FHIR/HL7), patient … Python and SQL. Proven track record designing end-to-end data pipelines and architectures. Deep understanding of ETL/ELT design and data modelling (star schema/lakehouse). Knowledge of ML workflows (basic to intermediate). ...

Athena, Redshift, Lambda, and Step Functions Deep expertise in streaming and event-driven systems , including Kafka (Confluent/MSK), Kinesis, and EventBridge Experience with schema management (Avro/Protobuf, Schema Registry, schema evolution strategies) Hands-on experience designing real-time and batch data pipelines , including CDC, partitioning … Strong understanding of logical and physical data modelling , including ERDs, normalization (up to BCNF), and denormalization strategies Experience designing analytical and transactional data models (star schema, Data Vault, OLTP vs OLAP patterns) Knowledge of CQRS and event sourcing , including when to apply these patterns effectively Expertise in Event ...

Data architecture (Data Lakes, Data Warehouses) and distributed processing concepts (e.g., MapReduce). ETL/ELT Basic knowledge of ETL principles and data modeling (star schema, snowflake schema). Version Control Practical experience with Git (branching, merging, pull requests). Preferred Qualifications (A Plus) Experience with ...

/CD deployment processes using Azure DevOps Required Experience Power BI (data visualisation, semantic models, paginated reports) SQL databases & data architecture Multidimensional modelling (star schema, snowflake, denormalised models, SCD handling) DAX (complex measures and analytical logic) Azure Data Factory/Fabric pipelines (complex ETL processes across relational ...

including indexing, optimisation and partitioningBackground in financial or investment data environmentsAdvanced SQL and Python skillsExperience migrating data from platforms like DatabricksConfident with dimensional modelling, star schemas, SCDs etc.Experience within regulated financial servicesDesirableExperience in pensions, asset management or institutional investingUnderstanding of performance measurement and attributionExposure to Airflow or dbtCloud platform ...

reporting and analytics. • Partner with stakeholders to understand requirements, validate assumptions and shape how data should be modelled. • Apply strong data modelling practices, including star schemas and Kimball methodologies. • Support the management of the lakehouse, including incremental loads, snapshotting and data quality. • Contribute to the relationship with Databricks ...

similar Strong hands-on experience with dbt (modelling, incremental models, macros, testing, documentation) Advanced SQL skills and solid understanding of analytical data modelling (Kimball, Star schema, etc.) Experience working with Snowflake or similar cloud data warehouses, including query optimisation Experience building data models that support business-facing analytics ...

similar transformation frameworks. • Strong SQL skills. • Solid Power BI capability, including modelling, DAX and semantic layers. • Experience with data modelling approaches such as star schema, Kimball or medallion architectures. • Ability to partner with non‐technical teams and communicate clearly with stakeholders. • Comfortable working autonomously in an evolving data ...

Editor, DAX Studio, Measure Killer. This is a greenfield project and you’ll need data analysis and modelling skills with experience in Semantic design, Star Schemas, Semantic models. Your role will focus on functional design and development of moderately complex applications and infrastructure used in a trading function. ...

teams Contribute to continuous improvement of reporting and analytics capabilities Key Experience Experience developing reports and dashboards using Power BI Strong data modelling experience (star schema, relationships, DAX preferred) Background in data analysis and interpreting business requirements Experience working with systems/data analysts or cross-functional teams ...

Role • Design and build Power BI dashboards with a strong focus on visual design and user experience • Develop well‐structured data models using star schema principles • Write efficient DAX measures and calculated columns • Build and maintain Power Query transformations for data preparation • Define and maintain design systems, templates ...

during an exciting period of data transformation. ROLES AND RESPONSIBILITIES: The BI Analyst will: Build and maintain core analytics data models using SQL, including star schema designs Develop dashboards and reporting layers using modern BI tools Translate commercial questions into clear, actionable insights Partner with stakeholders to define ...

used by BI tools and analytics platforms. Build datasets that support consistent business metrics, reporting and analysis. Implement modelling approaches such as star schemas, denormalised analytical tables and reusable metric layers. Data Analysis & Profiling Profile complex datasets to understand data structure, quality and business meaning. Investigate and interpret source …/GCP). Strong data analysis and data profiling capability with the ability to interpret complex datasets. Experience implementing analytical modelling approaches such as star schemas or wide tables. Desirable Skills Experience working with semantic layers or metrics layers (e.g. Looker/LookML). Experience designing consistent business metrics ...

used by BI tools and analytics platforms. * Build datasets that support consistent business metrics, reporting and analysis. * Implement modelling approaches such as star schemas, denormalised analytical tables and reusable metric layers. Data Analysis & Profiling * Profile complex datasets to understand data structure, quality and business meaning. * Investigate and interpret source …/GCP). * Strong data analysis and data profiling capability with the ability to interpret complex datasets. * Experience implementing analytical modelling approaches such as star schemas or wide tables. Desirable Skills * Experience working with semantic layers or metrics layers (e.g. Looker/LookML). * Experience designing consistent business metrics ...