10 of 10 Star Schema Jobs in London

Redshift. Implementing a Medallion architecture (bronze, silver, gold). Using DBT to model data, configure tables, and set up tests (including unit testing). Creating a data mart and star schema for financial and revenue reporting. Advising on orchestration best practices using Airflow. Optimising data pipelines for downstream BI tools (Power BI/Looker). This role won … a functioning data mart and reporting models, not dashboarding. YOUR SKILLS & EXPERIENCE The successful candidate will have: Strong SQL and DBT experience. Familiarity with Kimball methodology, dimensional modelling, and star schema design. Proven experience with Redshift or Snowflake. Strong background in cloud-based data environments (AWS preferred). Hands-on experience with Airflow for orchestration. (Nice-to-have More ❯

and lead analytics projects from onboarding through delivery in a collaborative, fast-growing environment. Analytical Data Engineer Job Overview Cleanse and transform data sets to create one-to-many star schema models from multiple sources. Define fact and dimension tables based on requirements, enabling users to drill down and explore data independently. Proactively search for and review data … outcomes. Develop and deliver advanced analytical dashboards using Sisense, Quicksight, and Power BI, tailored to user needs. Provide technical guidance on data structures from APIs to ensure alignment with star schema models. Support the Lead Solutions Architect on best practices for go-live within client Microsoft environments. Work directly with clients during onboarding, running workshops, gathering requirements, clarifying More ❯

and lead analytics projects from onboarding through delivery in a collaborative, fast-growing environment. Analytical Data Engineer Job Overview Cleanse and transform data sets to create one-to-many star schema models from multiple sources. Define fact and dimension tables based on requirements, enabling users to drill down and explore data independently. Proactively search for and review data … outcomes. Develop and deliver advanced analytical dashboards using Sisense, Quicksight, and Power BI, tailored to user needs. Provide technical guidance on data structures from APIs to ensure alignment with star schema models. Support the Lead Solutions Architect on best practices for go-live within client Microsoft environments. Work directly with clients during onboarding, running workshops, gathering requirements, clarifying More ❯

metadata management Performance Tuning : Partitioning, caching, Spark job optimization Cloud Architecture : Infrastructure-as-code, monitoring, automation Finance Domain Knowledge : Experience with financial systems and reporting Data Modelling : Kimball methodology, star schemas Retail Experience : Preferred but not essential About the Team We're a collaborative data function made up of BI Developers and Data Engineers. We work end-to-end More ❯

Experience managing large and complex datasets, with a strong command of SQL for cloud-based environments (Fabric, Snowflake, BigQuery, Redshift, etc.). A solid understanding of data modelling techniques (star schema, data vault, dimensional modelling). Proficiency in Excel-based data workflows for various Agile Retail projects. Hands-on experience with data pipeline orchestration tools (Airflow, dbt, Prefect More ❯

Experience managing large and complex datasets, with a strong command of SQL for cloud-based environments (Fabric, Snowflake, BigQuery, Redshift, etc.). A solid understanding of data modelling techniques (star schema, data vault, dimensional modelling). Proficiency in Excel-based data workflows for various Agile Retail projects. Hands-on experience with data pipeline orchestration tools (Airflow, dbt, Prefect More ❯

implementing enterprise-scale data architecture in complex environments Deep understanding of data modelling techniques-including conceptual, logical, and physical modelling Strong expertise in Kimball methodology and dimensional modelling (e.g. star schema design) Experience with modern cloud data platforms, ideally including Microsoft Azure, Databricks, and associated tools (e.g., Azure Data Factory, Azure SQL, Synapse) Familiarity with modern data engineering More ❯

relational databases (preferably postgres); working with Change Data Capture is a bonus. Data modelling knowledge, breaking down backend logic to understand and form a holistic data model (ie 3NF, star schema, Data Vault). Strong experience with Python, TypeScript or Java (a significant amount of work will be in Java - it is not expected for you to know … as code" practices. Good understanding of DevOps practices, Infrastructure as Code & Continuous Integration/Continuous Deployment. Desirable Experience extracting, loading and transforming large data sets (>100GBs). Experience with schema evolution tools such as flyway or liquibase. Experience with AWS (S3, IAM, RDS). Translate internal data user needs into building BI Dashboards to answer their key business questions. More ❯

and configure incremental loads with built-in unit testing. Support data pipeline orchestration with Airflow and work with AWS cloud tools. Help deliver a production-ready Data Mart with star schema design to power business reporting and dashboards (PowerBI experience a plus). Skills & Experience: Strong SQL expertise and hands-on experience with DBT. Familiarity with Kimball dimensional More ❯

when needed Excellent requirements, Epics, User Stories and Acceptance Criteria specification Managing agile product backlogs in scrum Process and requirements modelling Data Modelling of financial data and CUBE/Star Schema Data Analysis Reconciliation Defect triage and classification of bug prioritisation and severity Financial modelling and statutory reporting platforms Knowledge and Experience Experience of finance software implementations and More ❯