Enterprise Data Warehouse Engineer
Softtestpays
- Hobart, TAS
- Permanent
- Full-time
- Contract start 06 March 2023 To 12 months, 12 months extensions.
- Australian Citizen, Canberra, Sydney, Brisbane, Adelaide, Melbourne, Hobart, Hybrid(3 days in office 2 days at home) role.
- 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;
- 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