Job Title: Senior Enterprise Data Warehouse Engineer
Description:
The Senior EDW Engineer will provide strategic data assets to the data users and customers across NDIA. This includes updating data development documentation, providing technical guidance to developers and reviewing/approving data designs and data models.
The role will focus on collaborating with key business areas, solution architecture, and other governance committees in the development and implementation of consumable datasets to address key risks and emerging trends within these areas.
Key Responsibilities:
* Develop data models based on existing modelling practice, data source and end user requirements.
* 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).
* Provide technical leadership to the project delivery team through design reviews, advising on implementation best practices, defining and refining release process and technical workshops.
* 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.
* Set peer review and data modelling, development and release standards.
* Provide knowledge transfer sessions on best practices on development, data modelling, release process etc.
* Facilitate continuous improvement measures in delivery principles, coding standards, documentation and provide training sessions to team.
* Understand, analyse and articulate 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.
* Collaboration with data consumers, database development, testers and IT support teams.
Requirements:
The Enterprise Data Warehouse Engineer must have 10+ years experience in similar roles, and is expected to have high level of competency:
* SQL / Teradata Demonstrated competency in developing, auditing and reviewing code.
* SAS (preferred) or SQL (essential) or Python, R or Java (preferred).
* DevOps - Ability to understand DevOps process and can use DevOps tools in accordance with the process.
* Programming - High level of competency in Programming, including knowledge of supplementary programming languages such as Python.
* Version control - Ability to demonstrate knowledge of version controls and its appropriate uses.
* Excel - Competency with required systems, software and programs, including SAS and Excel.
* Other - Ability to read and interpret data models and specifications.
Selection Criteria:
Every application requires to address selection criteria as part of application submission.
* 1. The candidate should have 3+ years experience in similar roles.
* 2. Tertiary qualifications in mathematics, statistical, computer sciences discipline or more than 3 years relevant work experience.
* 3. Experience with updating data development based on approved data models, documentation, providing technical feedback to peers, and reviewing/creating data designs and data models.
* 4. Experience in the review of data modelling, development and release standards.
Required Skills:
User Requirements, Project Delivery, Version Control, SAS, Steps, Analysis, DevOps, Programming Languages, Reviews, Continuous Improvement, Workshops, R, Auditing, Developers, Architecture, Specifications, Integration, Mathematics, Programming, Python, Documentation, Software, Java, SQL, Leadership, Maintenance, Design, Business, Training.