Data Engineer (12 Month Fixed-Term Contract)

Job Title: Data Engineer (12 Month Fixed Term Contract)    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  Your external recruitment contact is Benjamin via [email protected]    Your internal recruitment contact is Pat via [email protected]   Applications must be submitted through our online portal. Applications sent via social media or email will not be accepted.      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     For a full list of our benefits, and our recruitment process as a whole visit our benefits page.     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.