The purpose of the role is to oversee the development and full lifecycle of Onward’s data warehouse ETL using SSIS to ensure optimal performance and to produce and organise data and performance metrics for Onward ensuring that systems are linked and processed correctly.
Responsibilities will include writing ETL scripts and code to make sure the ETL process performs optimally, documenting source-to-target mappings, re-engineering manual data flows to enable scaling and repeatable use, supporting the build of data streaming systems, testing and fault finding and resolution.
Analyse and provide support to the analytics and insight team to allow information on performance measurement to be documented and shared with the business; translating data into valuable insights that inform decisions. Support business intelligence reporting and facilitate analysis across Onward through production and maintenance of tables, data models and governed metrics and support the team in developing their technical knowledge of SQL and the data warehouse.
In order to be successful you should have knowledge of Microsoft SQL Server Stack, experience of interpreting data and communicating with technical and non-technical colleagues to assist in decision making across the business, experience of working to develop data and performance services and improve systems and be educated to A-Level standard or equivalent qualification.
All posts are recruited to the recruitment salary and movement to the confirmed salary is based on successful completion of a 6 month probation. As well as a competitive salary and a generous annual leave entitlement, we offer a range of benefits for a rewarding career including a health cash plan, pension scheme and personal development.
Please note that due to Covid-19, we have adapted our working arrangements under government guidelines and Safe Systems of Work. Discussions around the current working arrangements and Safe Systems of Work specific to the role will take place during the interview process. If candidates have any concerns / questions in relation to Covid-19 and the role at any stage of the recruitment and selection process they can contact the HR team on HumanResourcesTeam@onward.co.uk and a member of the HR Team will be in touch.