Job Overview
This role involves working as an ETL developer to develop and maintain robust ETL processes for extracting, transforming, and loading data into a data warehouse or other target systems.
Key Responsibilities:
1. Collaborate with business analysts to define and document business requirements.
2. Design, code, and document complex programs using agreed specifications, standards, and tools.
3. Identify and manage risks that affect delivery of system releases.
4. Develop estimates of effort and duration for development tasks and monitor progress.
5. Report on progress, anomalies, risks, and issues associated with allocated development tasks.
6. Contribute technical expertise to requirements analysis to enhance solution design and improve processes.
7. Data Analytics Expertise:
* Assess data availability and usability and determine the most appropriate technique for analysis in consultation with senior colleagues.
* Prepare data for analysis (cleansing and transformation).
* Manipulate, explore, and model data using programming languages and techniques in consultation with senior colleagues.
* Simplify and summarise data and draw out key insights for stakeholders.
8. Data Extraction & Analysis:
* Work with comprehensive data assets and apply advanced querying techniques.
* Access, query, interrogate, and manipulate large and/or complex data sets.
* FOLLOW data privacy and security protocols.
* Identify and resolve data-related challenges and discrepancies.
* Maintain detailed documentation of data access processes, query logic, and derivations.