EDW Engineers

EDW Engineers

Softtest pays pty ltd | Sydney, NSW, AU

Posted a month ago

Apply Now

Description


Please respond to the job if you are an Australian Citizen and residing in Australia.
Contract start 05 December 2022 To 12 months, 12 months extensions.
Australian Citizen, Sydney role.
Send your responses to jobs@softtestpays.com

Overview

Position Purpose

The Senior EDW engineer will be responsible for developing data assets in a GCFR framework on the TD based datawarehouse platform. This includes updating data development based on approved data models, documentation, providing technical feedback to peers, and reviewing/creating 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
Develop datasets and views in the EDW to delivery project goals through best practices of data development, defining and refining release process and technical implementation.

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.
Engage in 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.

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, greenfields dev ops environment;
Collaboration with data consumers, database development, testers and IT support teams;
Key Deliverables

This role will work within the Data Services team, and will be contribute to delivery of:
Deliver data assets from a prioritised product backlog in a CI/DC devops environment
Create and update EDW data models, data dictionary as per data development specification
Efficient code production
Key Skills
Technical data development
Data modelling and peer review
Expertise in SQL
Knowledge of metadata/model driven frameworks
Experience working in an Agile environment
Experience reverse engineering end user SQL code
Technical Competencies

The Data Services Developer / Analyst is should have 4+ years experience in similar roles, and is expected to have level of competency:
SQL / Teradata Demonstrated competency in developing, auditing and reviewing code
SAS (Base, EG) 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
Tertiary qualifications in mathematics, statistical, computer sciences discipline or more than three years relevant work experience.
Every application requires to address selection criteria as part of application submission

Essential Criteria
The Data Services Developer / Analyst should have 4+ years experience in similar roles
2.Tertiary qualifications in mathematics, statistical, computer sciences discipline or more than three 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