About the Role
Senior data engineers are hands-on leaders of consultants and client teams, building data platforms for clients in regulated financial services. This is a hands-on build role with client exposure, involving writing code, reviewing architecture, leading junior engineers, and explaining technical trade-offs to non-technical stakeholders.
Responsibilities
- Lead and mentor junior engineers on delivery workstreams, reviewing their code and data model decisions.
- Build reliable ingestion pipelines to move client data from source systems into the platform efficiently and securely.
- Design data models (Data Vault 2.0, Kimball Dimensional) that survive audit and provide a single trusted version of business numbers.
- Build pipelines to agreed SLAs and ensure their reliability in production.
- Translate business logic into pipeline logic with domain SMEs to produce correct numbers.
- Incorporate LLM-based processing into pipelines for tasks like document parsing, entity extraction, and unstructured data classification.
- Build AI-powered business solutions on the platform, such as agents, search, and applied use cases, to solve client problems with trusted data.
- Support pre-sales activities by sizing effort and cost for engagements, contributing to delivery plans, and presenting technical approaches.
- Write code, typically tackling the most complex challenges.
- Review code and data model decisions across the team.
- Take responsibility for a delivery workstream, including planning, execution, and leading junior engineers.
Requirements
- 4+ years in data engineering.
- At least 2 years of production experience on Databricks or Snowflake.
- Strong SQL and Python skills.
- Comfort with PySpark or Snowpark.
- Strong experience with at least one cloud vendor (Azure, AWS, or GCP), including core services beyond the data platform.
- Working knowledge of dimensional modelling (Kimball) and/or Data Vault 2.0.
- Comfortable presenting technical decisions to non-technical stakeholders.
- Track record of setting engineering standards and reviewing others' code.
- Comfortable leading or mentoring junior engineers and taking ownership of technical decisions.
- Familiarity with private markets data or London Market insurance.
- Experience with supporting tooling such as IaC, Transformation (dbt), DevOps, Data Quality, Data Modelling, Data Glossary/Governance, iPaaS/ELT, Orchestration.
- Some exposure to regulated environments (financial services, insurance, or similarly audited sectors).
- Awareness of relevant regulatory frameworks including FCA SYSC, DORA, and MiFID II.
Skills
- Databricks
- Snowflake
- SQL
- Python
- PySpark
- Snowpark
- Azure
- AWS
- GCP
- Data Vault 2.0
- Kimball Dimensional Modelling
- LLM-based processing
- IaC
- dbt
- DevOps
- Data Quality
- Data Modelling
- Data Glossary/Governance
- iPaaS/ELT
- Orchestration
Location
- United Kingdom
- United States
- France
- Netherlands
- Luxembourg
- Switzerland
- Asia
Work Type
- Hybrid working model
Experience Level
- Senior
- 4+ years in data engineering
- 2+ years on Databricks or Snowflake in production
Education Level
- Snowflake or Databricks certifications
Salary/Compensations
- Competitive base salary
- Annual performance bonus tied to individual and company outcomes.
Benefits
- Comprehensive benefits package
- Private medical insurance
- Life assurance
- Income protection
- Generous pension scheme with enhanced employer contributions
- Continuous learning budget
- Access to industry conferences, certifications, and training programmes
- 25 days annual leave plus bank holidays
- Option to buy additional days
- Employee assistance programme
- Wellbeing support
About the Company
- Alpha Financial Markets Consulting (Alpha) is a leading global consultancy to the financial services industry.
- We are a boutique management consulting firm that offers the world’s top industry players a competitive edge through our expertise and industry insight.
- Our team is of a uniquely high calibre and by focusing across the General Insurance & Specialty value chain, we build deep knowledge and experience within our industry.
- We have our headquarters located the United Kingdom, as well as offices in major global financial centres across the United States, France, Netherlands, Luxembourg, Switzerland, and Asia.
- The Insurance team works with industry leading carriers, brokers, market bodies, ancillary businesses, and technology providers to position our clients for future success.
- We have a fast growing team of dedicated consultants with deep experience from working both within the industry and consulting.
- Successful candidates should expect a diverse range of complex and strategic engagements across the market.
- As we continue to expand our client base and expertise, we are looking for individuals to join our team to support our growth journey.
