Alpha FMC
Senior Data Engineer (Databricks/ Snowflake)
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Alpha Financial Markets Consulting
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. Please see below an outline of the responsibilities of the role as well as the requirements.
About the Role
Our senior data engineers are hands-on leaders of consultants and client teams, building data platforms for clients in regulated financial services – private equity, real estate, fund administration, and specialist insurance. You'll work directly with client stakeholders, from engineering leads to CTOs, delivering production pipelines on Databricks or Snowflake (strong experience in one is sufficient). This is a hands-on build role with client exposure. You'll write code, review architecture decisions, lead junior engineers and explain trade-offs to people who aren't engineers.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
What You'll Do
- Lead and mentor junior engineers on your delivery workstream, reviewing their code and data model decisions
- Build reliable ingestion pipelines that move client data from source systems into the platform efficiently and securely
- Design data models – Data Vault 2.0, Kimball Dimensional etc. that survive audit and give the business one trusted version of the numbers
- Build pipelines to agreed SLAs and own their reliability in production
- Work with domain SMEs to translate business logic into pipeline logic that produces correct numbers
- Bring LLM-based processing into pipelines where it fits, document parsing, entity extraction, unstructured data classification, alongside deterministic logic
- Build AI-powered business solutions on the platform, agents, search, and applied use cases on Mosaic AI or Cortex, that solve a client problem with trusted data rather than demo a capability
- Support pre-sales by sizing effort and cost for prospective engagements, contribute to delivery plans, and present technical approach to prospective clients
What You'll Bring
- 4+ years in data engineering, with at least 2 years on Databricks or Snowflake in production (one platform is sufficient)
- Strong SQL and Python; comfort with PySpark or Snowpark
- Strong experience with at least one cloud vendor, Azure, AWS, or GCP, including core services beyond the data platform itself (networking, IAM, storage)
- 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 for quality, not just correctness
- Comfortable leading or mentoring junior engineers on a delivery team, and taking ownership of technical decisions
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Additional Experience We’d Value
- Snowflake or Databricks certifications
- Familiarity with private markets data (fund administration, private equity/real estate, secondaries) 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 – and awareness of relevant regulatory frameworks including FCA SYSC, DORA, and MiFID II
What the Engagement Looks Like
You'll work closely with client teams, alongside their internal engineers and Alpha consultants in a regulated environment where change control, data lineage and documentation matter. You'll write code, typically tackling the most complex challenges, review code and data model decisions across the team, and take responsibility for a delivery workstream – planning it, running it, and leading the junior engineers working on it.
What We Offer
- Competitive base salary
- Annual performance bonus tied to individual and company outcomes.
- Comprehensive benefits package including private medical insurance, life assurance, and income protection.
- Hybrid working model with flexible arrangements to support work-life balance.
- Generous pension scheme with enhanced employer contributions.
- Continuous learning budget and access to industry conferences, certifications, and training programmes.
- 25 days annual leave plus bank holidays, with option to buy additional days.
- Employee assistance programme and wellbeing support.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location