Data Engineer

Seven Investment Management LLP
London
About The Role

Purpose

Reporting to the Head of Data & Analytics, we are seeking a motivated and detail-oriented Junior Data Engineer to support our Analytics Engineering capability. This role is ideal for someone with foundational experience in data engineering who is eager to deepen their skills in modern data platforms, particularly Azure Databricks and Microsoft Fabric. You will play a key role in maintaining and evolving our medallion architecture, crafting robust data pipelines, and curating high-quality dimensional models to support business intelligence and advanced analytics. You'll work closely with the Data Analyst team, wider data engineering teams, and governance teams to ensure data is accurate, well-modeled, and traceable.

Responsibilities

  • Data Pipeline Development: Build and maintain scalable data pipelines using PySpark notebooks in Azure Databricks and Microsoft Fabric. Automate ingestion of raw data from various sources into our lakehouse, ensuring reliability and performance.
  • Medallion Architecture: Support the development and maturity of our bronze-silver-gold layer architecture, ensuring clean separation of raw, refined, and curated data.
  • Dimensional Modelling: Apply star schema and other dimensional modelling techniques to transform data into analytics-ready structures.
  • Collaboration: Work closely with analytics, insight, and business teams to understand data requirements and deliver solutions that meet their needs.
  • Governance & Lineage: Implement and maintain data governance practices, including data lineage, documentation, and metadata management.
  • Quality Assurance: Conduct data validation, testing, and monitoring alongside wider testing teams to ensure pipeline integrity and model accuracy.
About You

Knowledge

  • 3-5 years' experience applying relational data modelling and data warehousing techniques, including dimensional modelling (e.g. star schema and slowly changing dimensions) is essential to the role.
  • Technical experience building and deploying models using PySpark and Python in a data warehouse or data lakehouse environment.
  • Exposure to Delta Lake, lakehouse tables, or similar technologies - familiarity with Azure Databricks or Microsoft Fabric in particular is advantageous.
  • Experience with SQL for data transformation and querying.
  • Experience with Git and version control in a collaborative environment.
  • Familiarity with CI/CD pipelines for data workflows.
  • Awareness of data governance principles and tools (e.g., Purview, Unity Catalog, Fabric Data Governance).
  • An understanding of the structure and purpose of the Financial Advice and Wealth Management markets within the UK Financial Services sector is highly advantageous.
  • Knowledge of the Agile methodology would be beneficial.
Qualifications
  • No specific qualifications are required for this role; however, the successful candidate will be expected to complete the Microsoft Certified: Fabric Data Engineer Associate certification within their probation period (6 months).
Skills/Other relevant information
  • Excellent numerical skills are essential.
  • Strong problem-solving and analytical thinking.
  • Willingness to learn and grow in a fast-paced environment.
  • Good communication skills and ability to work collaboratively.
  • Attention to detail and commitment to data quality.
Posted 2025-10-15

Recommended Jobs

Project Manager / Business Analyst (Contractor)

Fair Finance
London

Project Manager / Business Analyst (Contractor) Contract: 3–4 days per week, initial 3-month contract (with potential extension) Location: Dalston Office (at least 1 day per week, travel costs c…

View Details
Posted 2025-10-10

Quality Manager-Pathology

The London Clinic
London

Quality Manager (3 days a week) - Pathology Service s We have an exciting opportunity for a n experienced Quality Manager to join our Pathology service based at The London Clinic in Central Lo…

View Details
Posted 2025-10-06

Nursery Practitioner Level 3 - Part Time

Busy Bees
City of London, Greater London

Role Overview: Join Our Team at Busy Bees – Leading Nursery Group in the UK Busy Bees is looking for passionate Level 3 Nursery Practitioners to join our team on a part-time basis , working 2–…

View Details
Posted 2025-10-11

After-school Nanny for a busy family, Job ID J1D38D

Little Ones UK Ltd
Wimbledon, Greater London

A lovely family based in Wimbledon, London, is seeking an After-school Nanny to care for their two school-aged children. The role includes all general nanny duties, with light housekeeping and cookin…

View Details
Posted 2025-10-12

IT Support Specialist

First Recruitment Group
Kingston upon Thames, Greater London

New Job Opportunity - IT Support Specialist - Initial 12 Month PAYE Contract Our Client has a requirement for an IT Support Specialist , who will be required to work on a Contract  basis in King…

View Details
Posted 2025-10-11

Hospitality Leader

Red 5 People
Hounslow, Greater London

Are you a hospitality leader looking for a career change? This is your chance to step into a growing sector with one of the UK’s largest charities that can really develop your career. What’s more, it’…

View Details
Posted 2025-09-20

Principal Product Manager

Fonoa
London

We are looking to hire a Principal Product Manager with deep experience in building and scaling SaaS products for global enterprise customers. The ideal candidate will have a proven track record of ow…

View Details
Posted 2025-10-12

CRM Insight & Data Planning Manager

Currys
London

CRM Insight & Data Planning Manager Currys London Campus at Waterloo Permanent Full Time Grade 4   We’re iD Mobile, one of the UK’s leading mobile virtual network operators. We launc…

View Details
Posted 2025-10-06

Quant Linux Systems Engineer

Quant Capital
London

Quant Linux Systems Engineer £120,000 – £160,000 Quant Capital is urgently looking for a talented Senior Linux Engineer to join our client’s Quant Systems team in London. Our client is a well-…

View Details
Posted 2025-09-10

Corporate Insurance Associate, London, 3-5 PQE

Jameson Legal.
London

Our US firm client's Financial Institutions Group is seeking a talented mid-level associate with 3-5 years' PQE to join their market-leading Corporate Insurance practice in London. The team advise…

View Details
Posted 2025-09-24