Data Engineer (12 Month Fixed-Term Contract) in London

Division: Data, Technology and Innovation (DTI)

Department: Digital Intelligence Solutions

Salary: National (Edinburgh and Leeds) ranging from £43,100 to £61,000 and London from £47,300 to £67,000 per annum (salary offered will be based on skills and experience)

This role is graded as: Associate Level 8 - Regulatory

About the FCA and team

We regulate financial services firms in the UK, to keep financial markets fair, thriving and effective. By joining us, you’ll play a key part in protecting consumers, driving economic growth, and shaping the future of UK finance services.

The Data, Technology and Innovation (DTI) division enables the FCA to be a digital-first, data-led smart regulator by delivering a secure, agile, and cost-effective technology and data ecosystem that drives better decisions, transparency, and operational efficiency.

Sitting within DTI, the Digital Intelligence department (DIS) delivers the Digital Unified Intelligence Environment (DUIE), which surfaces actionable insights through tools, dashboards and bespoke analysis. Within DIS, the Single View team delivers regulatory insights that help supervisors carry out case assessments, while also evaluating the quality and effectiveness of those insights.

Role responsibilities

• Design and implement robust data flows that connect operational systems with analytics and business intelligence platforms, ensuring trusted and accessible data across the organisation.
• Create and maintain source-to-target mapping documentation aligned to enterprise data models, governance frameworks and data standards.
• Transform manual and fragmented data processes into scalable, automated solutions that improve efficiency, consistency and long-term reuse.
• Support the development of real-time and near real-time data streaming solutions that enable timely insights and data-driven decision making.
• Develop, optimise and maintain ETL pipelines and code to ensure high performance, reliability and data quality across complex data environments.
• Prepare, cleanse and wrangle large and varied datasets for analytical models, enabling accurate reporting, advanced analytics and business insight.

Skills required

• Minimum: Prior experience of working in teams that design, develop, test and implement data solutions in complex environments, including integrating data from multiple source systems.
• Strong practical experience of Tableau Prep, including designing, building, testing, maintaining and troubleshooting complex Prep flows; integrating multiple data sources; applying joins, unions, transformations and calculations; and improving the performance, reliability and maintainability of existing flows.
• Extensive experience of extract, transform and load (ETL) processes, with strong programming and database skills, particularly in SQL and Python.
• Essential Experience of data profiling and source system analysis, with the ability to identify data issues, synthesise findings and provide clear insights to support the effective use of data.
• Experience designing, building and testing data products and integration solutions using feeds from multiple systems, storage technologies and access methods, creating solutions that are repeatable, reusable, robust and scalable.
• Strong understanding of data modelling principles, with experience producing, documenting, maintaining and updating data models for analytical and organisational needs, including reverse engineering models from live systems where required.
• Experience working with metadata repositories to support activities such as data and systems integration, impact analysis and the maintenance of accurate and up-to-date metadata.
• Knowledge and practical experience of data quality and problem resolution, testing practices, programming and scripting, and relevant data engineering concepts and techniques.
• Ability to communicate effectively with technical and non-technical stakeholders, translating complex technical and data concepts into clear and accessible language appropriate for internal and external audiences.
• Awareness of opportunities to improve and innovate data solutions through new tools, technologies and approaches, with the ability to consider maintainability, scalability and future needs.

Benefits

• 25 days annual leave plus bank holidays.
• Colleagues spend a minimum of 50% of their working time in the office each month (60% for Directors and Executive Directors) across our London, Leeds and Edinburgh offices.
• Non-contributory pension (8–12% depending on age) and life assurance at eight times your salary.
• Private healthcare with Bupa, income protection, and 24/7 Employee Assistance.
• 35 hours of paid volunteering annually.
• A flexible benefits scheme designed around your lifestyle.

Our values & culture

Our colleagues are the key to our success as a regulator. We are committed to fostering a diverse and inclusive culture: one that’s free from discrimination and bias, celebrates difference, and supports colleagues to deliver at their best. We believe that our differences and similarities enable us to be a better organisation – one that makes better decisions, drives innovation, and delivers better regulation.

If you require any adjustments due to a disability or condition, your recruiter is here to help - reach out for tailored support. We welcome diverse working styles and aim to find flexible solutions that suit both the role and individual needs, including options like part-time and job sharing where applicable.

Disability Confident: our hiring approach

We’re proud to be a Disability Confident Employer, and therefore, people or individuals with disabilities and long-term conditions who best meet the minimum criteria for a role will go through to the next stage of the recruitment process. In cases of high application volumes, we may progress applicants whose experience most closely matches the role’s key requirements.

Useful information and timeline

• Advert Closing: 11th November at 11:59pm.
• CV Review/Shortlist: 13th November.
• First Stage Interviews W/C: 23rd November.

Your Recruiter will discuss the process in detail with you during screening for the role, therefore, please make them aware if you are going to be unavailable for any date during this time.