Data Engineer

The Data Engineer role is responsible for developing and maintaining BI applications and solutions which deliver a single and trusted source for data and reporting to the business. It will support the Data Engineering Manager in developing the Enterprise Data Warehouse and Data Lake. The role provides technical expertise in developing and maintaining the data migration between source systems and the Data Warehouse, in developing fit for purpose data marts, and in developing automated reporting solutions to support health check for Enterprise Data Warehouse.

• Design, develop, test, and roll-out effective Azure data repositories, such as databases, data lakes, data marts, blob storage, and analytics models to support the Reporting Specialists to deliver automated MI reporting, BI dashboards, a self-service BI architecture, and ad-hoc data discovery analysis
• Leverage the relevant data management components such as Reference and Master Data Management, Data Governance, Data Quality, and Metadata to maintain the integrity of the data warehouse and deliver best in class BI capability
• Design, develop, test, and maintain data extraction, transformation, and loading routines (ETLs) to bring relevant data from source systems to the BI Data Warehouse in line with BI and reporting requirements as defined by the Performance
• Maintain the operational reporting layers across the group from a BI technical point of view, ensuring reports are meeting business requirements and support real or near real‑time delivery of operational data to operational teams
• Support the delivery of the more complex reporting requirements in line with the business requirements as specified by the Business Relationship Managers
• Develop and implement error and exception management processes, ensuring causes of poor data quality are identified and escalated to the Data Quality Analysts and Data Architect
• Support data archiving, purging, and GDPR compliance processes by developing the required ETLs
• Ensure work is fully documented and referenced in line with agreed processes and formats

We are an organisation with a passion for giving back. Putting money back into the NHS, raising 150,000 over 3 years for our charity partner Young Lives vs Cancer, supporting colleagues to volunteer within their local communities, and being committed to creating a sustainable working environment on our pledge to become net zero carbon by 2050. We understand that it s important to feel like the work you do is having a meaningful impact on society, and through our approach to being a responsible business, we make sure that every colleague is given the opportunity to make a difference.

We have a fantastic opportunity for a Data Engineer join our team based nationally with flexible working. The salary on offer is from 60,000 with eligibility for our annual 10% bonus. This will be a 12-month FTC.

• 27 days annual leave+ 8 days bank holiday with the option to buy additional weeks leave.
• A Smarter Working Policy, empowering you to choose the location of how and where you work according to your daily activities.
• Training and development opportunities, providing opportunities for our colleagues to develop and progress their careers at all levels through our Professional Excellence Framework.
• Company-wide Colleague Referral Scheme
• SMART Pension contribution into which the company will contribute up to 6%
• A range of flexible benefits including NHS retail discounts and Cycle to Work Scheme.
• We have a great Colleague Assistance Programme and offer support for all areas of life.