Description :

Overall Job Purpose :

The Data Warehouse developer is responsible for the maintenance, improvement, and strategic direction of the Air & Water Data Warehouse and reporting solutions.

They will be responsible for ETL (Extract, Transform and Load), Design of the data warehouse and all downstream reporting.

The candidate must have technical acumen, business analysis and have significant input into architectural and strategic decisions.

ION, Azure, Synapse, MS SQL Server, Data Factory and PowerBI makes up the current technology stack of our data warehouse.

The project entails mining data from various ERP systems. Experience querying multiple ERP systems would be an advantage. e.g. AX 2012, Dynamics, Infor Cloud, Navision, etc.

This role is a unique opportunity to design and improve the Air Data Warehouse.

Scope of duties :

Business Analysis :

- Translating Business Requirements into technical design

- ETL (Extract, Transform and Load)

- Creating ad hoc reports and dashboards of medium to high complexity

- Validating reports to ensure data accuracy

- Undertaking appropriate data analysis for ad hoc projects

- Working with the business to gather report requirements and recommend reports to help run the business

- Creating user guides and documentation on both run management and ad hoc reporting where applicable

- Supporting the Business on transformation and alignment activities

- Communicating business results in a user friendly format

- Highlighting any process issues to manager so that issues may be addressed and appropriate action taken

- Supporting and mentoring of other areas of the business