At a Glance
- Tasks: Lead the design and delivery of ETL data flows for a major banking client.
- Company: EXL, a global leader in data and AI solutions.
- Benefits: Flexible hybrid working, competitive pay, and opportunities for professional growth.
- Other info: Join a collaborative team driving innovation in financial services.
- Why this job: Make a real impact on regulatory data solutions in a dynamic banking environment.
- Qualifications: Experience in data engineering, especially with IBM DataStage and Oracle.
The predicted salary is between 70000 - 90000 € per year.
EXL (NASDAQ: EXLS) is a global data and artificial intelligence ("AI") company that offers services and solutions to reinvent client business models, drive better outcomes and unlock growth with speed. EXL harnesses the power of data, AI, and deep industry knowledge to transform businesses, including the world’s leading corporations in industries including insurance, healthcare, banking and financial services, media and retail, among others. EXL was founded in 1999 with the core values of innovation, collaboration, excellence, integrity and respect. We are headquartered in New York and have more than 60,000 employees spanning six continents.
We are seeking an experienced Lead Data Engineer to join a major banking client working on their Risk Data Warehouse (RDW) platform. This role is critical to supporting both ongoing regulatory change initiatives and the stability of production data pipelines underpinning key risk and finance reporting. You will act as a hands-on technical lead, driving the design and delivery of end-to-end ETL data flows using IBM DataStage and Oracle, ensuring high-quality, controlled, and auditable data pipelines aligned to regulatory standards (including Basel 3.1 and credit risk programmes).
As part of your duties, you will be responsible for:
- Lead the design, build, and validation of ETL pipelines supporting the Risk Data Warehouse
- Make and document ETL and data flow design decisions, ensuring traceability and regulatory compliance
- Deliver high-quality data pipelines supporting Basel 3.1, Murex migration, and credit risk reporting
- Define and implement data lineage, controls, and validation frameworks
- Provide hands-on technical leadership across DataStage and Oracle development
- Collaborate with risk, trading, and engineering stakeholders to gather and translate requirements into scalable data solutions
- Act as the primary escalation point for critical RDW incidents, including triage, root cause analysis, and resolution
- Produce production-ready artefacts (monitoring, runbooks, failure handling, support documentation)
- Drive continuous improvement through post-incident reviews and corrective actions
Qualifications and experience we consider to be essential for the role:
- Strong experience as a Senior / Lead Data Engineer within banking or financial services
- Proven background delivering regulatory data solutions (e.g. Basel, credit risk, capital reporting)
- Deep expertise in IBM DataStage and Oracle (PL/SQL, data warehousing)
- Experience working on Risk Data Warehouse or similar enterprise data platforms
- Strong understanding of data lineage, governance, and control frameworks
- Experience integrating risk data flows with trading / risk systems (e.g. Murex or similar)
- Demonstrated ability to operate in hands-on delivery roles, leading engineering teams and solving complex technical challenges
To be considered for this role, you must already be eligible to work in the United Kingdom.
Lead Data Engineer in Edinburgh employer: exl
EXL is an exceptional employer that fosters a culture of innovation and collaboration, making it an ideal place for professionals seeking to make a meaningful impact in the data and AI landscape. With flexible hybrid working options in the vibrant city of Edinburgh, employees benefit from a supportive environment that prioritises growth and development, alongside opportunities to work on cutting-edge projects within the banking sector. Joining EXL means being part of a global team dedicated to excellence and integrity, where your contributions directly influence the success of leading corporations worldwide.
StudySmarter Expert Advice🤫
We think this is how you could land Lead Data Engineer in Edinburgh
✨Tip Number 1
Network like a pro! Reach out to your connections in the banking and financial services sector. Attend industry meetups or webinars, and don’t be shy about asking for introductions. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your ETL projects, especially those involving IBM DataStage and Oracle. This will give potential employers a clear view of what you can bring to the table, making you stand out from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on regulatory standards like Basel 3.1. Be ready to discuss how you've tackled complex data challenges in the past. We want to see your problem-solving skills in action!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search. Let’s get you that Lead Data Engineer role!
We think you need these skills to ace Lead Data Engineer in Edinburgh
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Lead Data Engineer role. Highlight your experience with IBM DataStage and Oracle, and don’t forget to mention any regulatory data solutions you've worked on. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for this role. Share specific examples of your past work in banking or financial services, especially around risk data and ETL pipelines. Let us know what makes you tick!
Showcase Your Technical Skills:In your application, be sure to showcase your technical skills clearly. Mention your hands-on experience with data lineage, governance, and control frameworks. We love seeing candidates who can demonstrate their expertise in solving complex technical challenges.
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to submit all your documents in one go. Plus, it helps us keep track of your application better!
How to prepare for a job interview at exl
✨Know Your Data Inside Out
As a Lead Data Engineer, you’ll need to demonstrate your expertise in IBM DataStage and Oracle. Brush up on your knowledge of ETL processes, data lineage, and regulatory compliance, especially around Basel 3.1. Be ready to discuss specific projects where you've successfully implemented these technologies.
✨Showcase Your Problem-Solving Skills
Prepare to share examples of complex production issues you've resolved in the past. Highlight your approach to triage and root cause analysis, as well as how you’ve driven continuous improvement through post-incident reviews. This will show your hands-on leadership capabilities.
✨Understand the Business Context
Familiarise yourself with the banking and financial services landscape, particularly around risk data management. Being able to connect your technical skills to business outcomes will impress interviewers and demonstrate that you can collaborate effectively with stakeholders.
✨Prepare for Technical Questions
Expect in-depth technical questions related to data warehousing, PL/SQL, and data governance frameworks. Practice articulating your thought process clearly and concisely, as this will showcase your ability to lead engineering teams and communicate complex ideas effectively.
