EDW Engineer
- 10 Apr 2024
- Sydney
- Contract
The Senior EDW engineer will lead project stream of the data warehouse platform. 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 in the development and implementation of consumable reports and analytics to address key risks and emerging trends within these areas.
Key Responsibilities
Data Delivery
Essential criteria
Aus citizens only for this opportunity unfortunately.
If you’d like to be considered for this opportunity, press apply now.
The role will focus on collaborating with key business areas in the development and implementation of consumable reports and analytics to address key risks and emerging trends within these areas.
Key Responsibilities
Data Delivery
- 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.
- 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).
- Facilitate continuous improvement measures in delivery principles, coding standards, documentation and provide training sessions to team.
- Prioritise work items and add them to a work queue.
- Understand, analyse and size 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;
- Work within a state of the art, greenfield dev ops environment;
- Collaboration with data consumers, database development, testers and IT support teams.
Essential criteria
- MS SQL / Teradata /Snowflake / Redshift / Databricks – Demonstrated competency in developing, auditing and reviewing code in 2 out of the 5 DW listed
- SAS (Base, EG) or SQL (essential) or Python, R or Java (preferred)
- Tertiary qualifications in mathematics, statistical, computer sciences discipline or more than three years relevant work experience.
- DevOps - Ability to understand DevOps process and can use DevOps tools in accordance with the process
- Exposure to AWS Cloud, AWS S3, AWS Glue or similar tools within the cloud environment
- Programming – High level of competency in Programming, including knowledge of supplementary programming languages such as Python
Aus citizens only for this opportunity unfortunately.
If you’d like to be considered for this opportunity, press apply now.