How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Data Engineer (FTC)
Location: London, EC2M
About LPPI
One of the key priorities at LPPI is ensuring that our people work every day in an empowered, supportive, diverse and inclusive culture. Practically, this means recognising and valuing the uniqueness of every individual in terms of background, experience, beliefs, and circumstances. This starts with the recruitment process, where we partner with agencies who share our common goal and advertise on a variety of job boards to access the broadest spectrum of candidates. And once successful applicants are on board, we trust our people to work in the way that works best for them, which typically involves a mix of office and home working plus an engagement model to ensure frequent two-way feedback.
We are very proud of our culture at LPPI and the benefits it brings to both our people and the business. But don’t just take our word for it! Recently, we invited our entire workforce to describe in three words what is great about us, and they said – our people, flexibility, and collaboration.
If you would like to join a company that is inclusive and forward-thinking, please read on.
Role Purpose
The purpose of this document is to solicit proposals from qualified vendors to supply a ‘Hands-on’ Data Engineer role that aligns with LPPI’s purpose by supporting the delivery of innovative, supportable, and sustainable solutions that help LPPI achieve its vision of being a leading provider of pensions and investments.
This role is an 8-month, Fixed-Term Contract.
Key Responsibilities
- Work closely with business analysts and stakeholders to understand data requirements
- Creation of technical specifications and architecture visions covering quality attributes, diagrams, associated risks, technical and system requirements
- Collaborate with wider Data Team and Business Analysts to align data models with business needs
- Build and maintain robust ETL pipelines to extract data from diverse sources (e.g., APIs, databases, flat files)
- Use Azure Git Repo, Boards, and CI/CD deployment pipelines for version control of ETL, SQL & Reports
- Transform and load raw data into structured formats using business rules, data cleansing, and enrichment techniques into a unified schema
- Design and implement reporting data models (e.g., star/snowflake schemas) to support analytics
- Tune ETL activities for efficiency and scalability through data indexing, partitioning, as well as parallel processing strategies to reduce latency and improve throughput
- Implement data validation rules & cleansing routines to ensure accuracy and consistency
- Monitor data pipelines for anomalies, errors, and performance issues
- Implement access controls and encryption where necessary
- Document ETL processes, data flows, and transformation logic for transparency and maintainability
- Design and build interactive, visually compelling Power BI reports and dashboards tailored to business needs
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.
Requirements for the role
- Commercial project experience in delivering modern data solutions using Medallion Architecture and experience in the following Technical Stack (must have):
- Medallion, Delta Lake, and metadata-driven architecture using MS Fabric or Synapse Analytics ETL pipelines
- Data Transformation using SQL Query Language and Python notebooks
- Data storage and warehouse using SQL DB, Delta Lake (Gen2), Snowflake
- Dimensional modelling using Kimball methodology
- Power BI Interactive Dashboard and Paginated Reports using DAX functions, Power Query.
- Familiarity with Investment Management and/or Financial Services
- Commercial experience working with business stakeholders within a cross-functional matrix environment
- Experience in the delivery of projects utilising Agile methodologies
- The ability to understand and apply new technologies to stay current with best practices and trends in application and data architecture for financial services
- Confidence in handling, interpreting, and presenting complex numerical data and technological challenges in a clear and concise manner
- Self-motivated, decisive, with the ability to adapt to change and competing demands
- Experience working both independently and within a team-oriented, collaborative environment
- Adept at conducting research into project-related issues and products
- A proactive, self-motivated team player who can manage a high workload with multiple deadlines and continually strive for improvements in quality, efficiency, and presentation
- Bachelor’s degree in computer science, engineering, or a related field (or equivalent experience)
- DP-203: Data Engineering on Microsoft Azure or an equivalent certification. Additional certification/courses in the use of Gen AI will be beneficial
- Maintain a working technical understanding of the complexities in delivering change into an Investment Management organisation, specifically where the application ecosystem is decentralised
- Good conduct that is consistent with the LPPI values-aligned behaviours
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Reasonable adjustment will be made to working arrangements to accommodate a person with a disability who otherwise would be prevented from undertaking the work.
“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