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 starschema 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 starschema 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 ❯
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 ❯
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 ❯
London, South East, England, United Kingdom Hybrid / WFH Options
Harnham - Data & Analytics Recruitment
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 starschema 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 ❯
London, South East, England, United Kingdom Hybrid / WFH Options
Lorien
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/StarSchema Data Analysis Reconciliation Defect triage and classification of bug prioritisation and severity Financial modelling and statutory reporting platforms Knowledge and Experience 7+ years of direct experience of More ❯
London, South East, England, United Kingdom Hybrid / WFH Options
Lorien
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/StarSchema Data Analysis Reconciliation Defect triage and classification of bug prioritisation and severity Financial modelling and statutory reporting platforms Knowledge and Experience 7+ years of direct experience of More ❯