The Data Engineer will build and maintain the data infrastructure and systems that collect, manage and transform raw data for onward use by the company' data analysts and data scientists. They will implement efficient data systems that are aligned appropriately with business goals, and will make all the organisation's data accessible to be used in support of relevant aspects of the organisations regulatory mission.

Key responsibilities include:

* Working to Extract, Transform and Load (ETL) data sets from a variety of data sources across the companies enterprise technology stack.
* Monitoring the execution of data workflows, including identifying and mitigating risks, setting service level indicators and configuring alerts.
* Adopting data governance best practice when processing raw data to develop, test and maintain datasets, including the use and maintenance of relevant resources (such as, but not limited to, a data catalogue, data dictionary, logical data models).
* Supporting continuous data quality improvements across the organisation by exploring enhancements to: automated quality assurance processes; the reliability of data workflows; and the effectiveness of data transformations.
* Applying dimensional data modelling concepts and practices across the companies data to develop conceptual, logical and physical data models that support efficiency and effectiveness of business operations
* Advocating and supporting an evidence-led culture across the organisation, assisting with driving enhancements to the organisation's data capability.


About you

To fulfil the role you will be:
* Adaptable, with a willingness to work flexibly as the needs of the organisation evolve
* Able to work well within a team, and able to work closely with internal and external stakeholders.
* Able to take a logical and analytical approach, and to take a pragmatic, collaborative approach to solving problems.
* Experienced in organising, manipulating, understanding and optimising data structures through data management tools and analytical programming, and of designing and running complex processes from beginning to end.
* Adept at communicating technical concepts to a non-technical audience.

Your technical skills will include:

* Knowledge of modern tools and methodologies that help shape the organisation's ability to provide business insight.
* Good knowledge of the Microsoft Azure data ecosystem
* Strong contemporary Microsoft data solution and development skills
* A comprehensive knowledge of database design and development, data management and systems integration
* Knowledge of automation testing as part of a data engineering pipeline
* Knowledge of software development approaches, disciplines and best practice
* Awareness of how data is used by Analysts, Data Scientists and in Business Intelligence tools (Power BI, Tableau)
* Experience using Cloud services (primarily Azure)
* Experience using ETL tools (SSIS, Data Factory)
* Experience using APIs to send and receive data.
* Good knowledge of code management principles and experience using source Control Management tools, such as Azure DevOps, Git
* Experience connecting datasets together from a variety of sources (XML, JSON, SQL, CSV).
* Experience of developing and supporting data warehouse modelling.
* Experience scripting data pipelines in Python & T-SQL
* Experience of developing and delivering data services through Continuous Integration, Continuous Delivery practices
* Experience of effective delivery, working to Agile methodologies.

This is an agile working role, which means the role-holder will be expected to operate and work flexibly across different activities commensurate with this pay band, including undertaking project work to support different components of the DTP or of the company's data functions.

--- Fusion People are committed to promoting equal opportunities to people regardless of age, gender, religion, belief, race, sexuality or disability. We operate as an employment agency and employment business. You'll find a wide selection of vacancies on our website.