Data Engineer

Job Description

Job Title : Data Engineer Location: London Leeds, EdinburghSalary:London -£49,700 -£70,000 and London - £53,300-£80,000Company:FCADescribe the work of the team and the 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 isas much emotional as it is financial. We believe that we can prevent that with better designed digital intelligence products and services for our colleagues.What does this job involveThe Data Engineer works within a multi-disciplinary digital team (squad) aimed at improving the design and collection of data from the industry to deliver the FCAs mission and strategic objectives. They develop and construct data products and services, andintegrate them into systems and business processes.At this role level, you will:* 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 used in analytical modelsWhich minimum, essential & desirable skills are required* Experience of working in 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 criteriaRequired role-specific know-how, skills and behaviours* Communicating between the technical and non-technical. You can show an awareness of the need to translate technical concepts into non-technical language. You can understand what communication is required with internal and external stakeholders. (Skill level:awareness)* Data analysis and synthesis. You can undertake data profiling and source system analysis. You can present clear insights to colleagues to support the end use of the data. (Skill level: working)* Data development process. You can design, build and test data products based on feeds from multiple systems, using a range of different storage technologies, access methods or both. You can create repeatable and reusable products. (Skill level: working)* Data innovation. You can show an awareness of opportunities for innovation with new tools and uses of data. (Skill level: awareness)* Data integration design. You can deliver data solutions in accordance with agreed organisational standards that ensure services are resilient, scalable and future-proof. (Skill level: working)Data modelling. You can explain the concepts and principles of data modelling. You can produce, maintain and update relevant data models for an organisations* specific needs. You can reverse-engineer data models from a live system. (Skill level: working)* Metadata management. You can work with metadata repositories to complete complex tasks such as data and systems integration impact analysis. You can maintain a repository to ensure information remains accurate and up to date. (Skill level: working)* Problem resolution (data). You can explain the types of problems in databases, data processes, data products and services. (Skill level: awareness)* Programming and build (data engineering). You can design, code, test, correct and document simple programs or scripts under the direction of others. (Skill level: working)* Technical understanding. You can understand the core technical concepts related to the role, and apply them with guidance. (Skill level: working)* Testing. You can correctly execute test scripts under supervision. You can understand the role of testing and how it works. (Skill level: awareness)Tooling. You are proficient in the use of Tableau Prep, SQL and Python.If you are someone who is seeking that next challenge, and you have the experience and skills required, then please send me your CV. /