Salary: National – ranging from £40,600 to £50,100 per annum and London – ranging from £44,900 to £55,700 per annum
Do you want to play a key role in a multi-disciplinary digital product team aimed at delivering assignments supporting the development of the FCA’s Digital Unified Intelligence Environment?
The team/ department
As data practitioners at the FCA we dedicate our talent to keeping the UK financial services industry safe. Financial fraud, scams, and disorderly failure of institutions can see consumers lose life changing amounts of money, and damage to an individual is as much emotional as it is financial. We believe that we can prevent that with better designed digital intelligence products and services for our colleagues.
In Data, Technology and Innovation, we believe in doing things differently. We believe the best approach is sometimes a new approach. We place emphasis on curiosity and experimentation. We collaborate widely with academics, innovative companies and the rest of the FCA. We believe that people need space to continue learning and the support to develop new ideas, so we commit to giving them both.
This role will be part of the Digital Intelligence Solutions department, which brings together skills in data analysis, visualisation, service, and product design to deliver the FCA's Digital Unified Intelligence Environment. This department works widely across the FCA to ensure that the data and intelligence we create and acquire is turned into actionable insight for the organisation. It has a unique perspective across the breadth of the FCA's regulatory activities and is at the heart of delivering our data strategy.
What You Will Be Doing (the Role)
The Data Engineer works within a multi-disciplinary digital product team (squad) aimed at delivering assignments supporting the development of the FCA’s Digital Unified Intelligence Environment (DUIE). They develop and construct data products and services and integrate them into systems and business processes.
- Implement data flows to connect operational systems, data for analytics and business intelligence (BI) systems
- Document source-to-target mappings with reference to Enterprise Data Models and associated standards
- Re-engineer manual data flows to enable scaling and repeatable use
- Support the build of data streaming systems
- Write ETL scripts and code to ensure that ETL processes perform optimally
- Prepare and wrangle data for use in analytical models
What You Will Get From The Role
- Being part of a dynamic and newly established team and Division, working with colleagues that are passionate about the role of user centred design in digital service delivery
- Learning and development tailored to your role, including industry recognised qualifications, coaching and mentoring
- Training budget, enabling you to attend conferences, events, meetups to develop your community of practice
- An inclusive and diverse environment with opportunities to join staff networks
Core Benefits That You Will Receive As Standard Are
- 25 days holiday per year plus bank holidays
- Private healthcare with Bupa
- A non-contributory Pension of at least 8% of basic salary each month (there are several contribution levels that increase depending on your age – up to 12% a month once you reach age 35)
- Life assurance of eight times your basic salary
- Income protection
We support hybrid working which means you will be able to work from home up to 60% of the time over a month with the remainder of your time in one of our three office locations.
The Skills And Experience You Will Have
Minimum
We're a signatory to the Government's Disability Confident scheme. This means that we guarantee an interview to any disabled candidates entering under the scheme, should they meet the minimum criteria for a role.
- Experience of contributing to teams that design, develop, test and implement efficient and effective data solutions in complex environments
- Experience of modelling and/or documenting data to be used for analytics
- Strong extract, transform, load (ETL) experience and solid programming/database programming knowledge, specifically Python and SQL
Essential
- Experience of undertaking data profiling and source system analysis, being able to present clear insights to colleagues to support the end use of the data
- Experience of designing, building and testing data products based on feeds from multiple systems, using a range of different storage technologies, access methods or both
- Delivering data solutions in accordance with agreed organisational standards that ensure services are resilient, scalable and future proof
- Experience of producing, maintaining and updating data models, being able to reverse-engineer data models from a live system
- Experience of working with metadata repositories to complete complex tasks such as data and systems integration impact analysis
- Experience in designing, coding, testing, correcting and documenting simple programs or scripts under the direction of others
- Proficient in the use of Tableau Prep, SQL and Python
- Be able to translate technical concepts into non-technical language
About The FCA
The FCA regulates the conduct of 50,000 firms in the UK to ensure our financial markets are honest, fair and competitive. We do this to make sure markets work well for individuals, businesses and the economy as a whole. For more information on what we do, our three-year strategy can be found here.
The FCA's Values & Diversity
Our ambition is to cultivate a culture of inclusion for all employees that respects their individual strengths, views, and experiences. 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.
The FCA is committed to achieving greater diversity across all levels of the organisations. Given this, we particularly welcome applications from women, disabled and minority ethnic candidates for our Senior Associate role.
Flexible working
We welcome applications from candidates who are looking for flexible arrangements. Many of our staff work flexibly including working part-time, staggered hours, and job shares. We can’t promise to give you exactly what you want but we won’t judge you for asking.
Multi-location
As part of the FCA’s on-going commitment to develop our national presence, most of our vacancies are now open to working in our Edinburgh, Leeds, or London offices. This means that as part of the application process you will be able to select your preference of which office location you would like to work from.
Useful information
Applications for this role close at midnight on 11th August 2023
This role is graded as Associate Level 8 – Regulatory
Got a question?
If you are interested in learning more about the role, please contact:
What To Expect From Our Interview Process
The assessment process will involve a competency-based interview.
