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.The Senior EDW Engineer will advise, design, model, and deliver 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 ResponsibilitiesData DeliveryDevelop 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 the team.Understand, analyze, and articulate user requirements.Development and maintenance of SQL analytical and ETL code.Optimization 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.The Enterprise Data Warehouse Engineer must have 10+ years experience in similar roles and is expected to have a 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.Every application requires addressing selection criteria as part of the application submission.The candidate should have 3+ years experience in similar roles.Tertiary qualifications in mathematics, statistical, computer sciences discipline, or more than 3 years relevant work experience.Experience with updating data development based on approved data models, documentation, providing technical feedback to peers, and reviewing/creating data designs and data models.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.
#J-18808-Ljbffr