2 x EL1 Enterprise Data Warehouse Engineer

⁠⁠⁠Position Purpose

The Senior EDW engineer will be responsible for developing data assets in a GCFR framework on the TD based datawarehouse platform. This includes updating data development based on approved data models, documentation, providing technical feedback to peers, and reviewing/creating data designs and data models.

The role will focus on collaborating with key business areas in the development and implementation of consumable reports and analytics to address key risks and emerging trends within these areas.

Key Responsibilities

Data Delivery

• Develop datasets and views in the EDW to delivery project goals through best practices of data development, defining and refining release process and technical implementation.
• Review and refine the data delivery framework in order to enhance integration of new sources, performance of existing data delivery and rapid development of new subject areas.
• Engage in peer review and data modelling, development and release standards.
• Provide knowledge transfer sessions on best practices on development, data modelling, release process etc.
• Own the technical implementation of new data from analysis to delivery (designing and delivering data dictionary, defining the release steps, defining best practices of data modelling and review steps).
• Facilitate continuous improvement measures in delivery principles, coding standards, documentation and provide training sessions to team.
• Understand, analyse and size user requirements;
• Development and maintenance of SQL analytical and ETL code;
• Optimisation and tuning of SQL code to ensure optimal performance;
• Development and maintenance of system documentation;
• Work within a state of the art, greenfields dev ops environment;
• Collaboration with data consumers, database development, testers and IT support teams;

Key Deliverables

This role will work within the Data Services team, and will be contribute to delivery of:

• Deliver data assets from a prioritised product backlog in a CI/DC devops environment
• Create and update EDW data models, data dictionary as per data development specification
• Efficient code production