Data Engineer (12 Month Fixed-Term Contract)

PSR Limited; London Borough of Newham; On-site; GBP 43,000 - 67,000; Full time

Benefits offered by this job

25 days annual leave plus bank holiday

Pension 8–12% depending on age

Private healthcare

Volunteer hours

Flexible benefits

Job summary

FCA in London, Edinburgh and Leeds seeks a Data Engineer on a 12-month fixed-term contract to design and implement robust data flows connecting operational systems with analytics platforms. You will create source-to-target mappings aligned to enterprise data models and governance, and transform manual processes into scalable automated pipelines.

The role emphasizes ETL, SQL, Python, data modeling and metadata management to deliver trusted data for regulatory insights.

Qualifications

• Experience in designing, developing and deploying data solutions in complex environments.
• Strong Tableau Prep experience with multi-source data and performance tuning.
• Extensive ETL experience with SQL and Python.
• Ability to translate data concepts for technical and non-technical audiences.

Responsibilities

• Design and implement robust data flows linking operational systems with analytics platforms.
• Create source-to-target mapping docs aligned to data models and governance frameworks.
• Transform manual data processes into scalable automated pipelines.
• Support real-time and near real-time streaming to enable timely insights.

Skills

Tableau Prep

ETL

SQL

Python

Data modeling

Metadata

Data profiling

Stakeholder comms

Job description

Job Title: Data Engineer (12 Month Fixed Term Contract)Division: Data, Technology and Innovation (DTI)Department : Digital Intelligence SolutionsSalary: 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 - RegulatoryYour external recruitment contact is Benjamin via [e-mail] internal recruitment contact is Pat via [e-mail] must be submitted through our online portal. Applications sent via social media or email will not be accepted. About the FCA and teamWe 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 responsibilitiesDesign and implement robust data flows that connect operational systems with analytics and business intelligence platforms, ensuring trusted and accessible data across the organisationCreate and maintain source-to-target mapping documentation aligned to enterprise data models, governance frameworks and data standardsTransform manual and fragmented data processes into scalable, automated solutions that improve efficiency, consistency and long-term reuseSupport the development of real-time and near real-time data streaming solutions that enable timely insights and data-driven decision makingDevelop, optimise and maintain ETL pipelines and code to ensure high performance, reliability and data quality across complex data environmentsPrepare, cleanse and wrangle large and varied datasets for analytical models, enabling accurate reporting, advanced analytics and business insightSkills requiredMinimum: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.EssentialExperience 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.Benefits25 days annual leave plus bank holidaysColleagues 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 officesNon-contributory pension (8–12% depending on age) and life assurance at eight times your salaryPrivate healthcare with Bupa, income protection, and 24/7 Employee Assistance35 hours of paid volunteering annuallyA flexible benefits scheme designed around your lifestyleFor a full list of our benefits, and our recruitment process as a whole visit our benefits page.Our values & cultureOur 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 approachWe’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 timelineAdvert Closing: 11th November at 11:59pmCV Review/Shortlist: 13th NovemberFirst Stage Interviews W/C: 23rd NovemberYour 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.