Job description
EL1 Data Engineer
The Senior Data engineer will lead project stream of the agencies 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.
Duties
DFP welcomes applications from Aboriginal and Torres Strait Islander people, people with diverse cultural and linguistic backgrounds and people with disability. In addition, DFP will provide reasonable adjustments for individuals with disability throughout the recruitment process. If you identify as a person with disability and require adjustments to the application, recruitment, selection and/or assessment process, please advise via adjustments@dfp.com.au or 1300 337 000 and indicate your preferred method of communication (email, phone, text) so we can keep in touch and meet your accessibility needs.
- $800 - $900 / Daily Rate / Ex Super
- Deakin, ACT
- 12-month contract (Possible extension)
The Senior Data engineer will lead project stream of the agencies 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.
Duties
- 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;
- 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)
- 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
- 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.
- Applicants must hold Australian citizenship.
- National Criminal History Records Check and completion of the Agency’s screening checks.
DFP welcomes applications from Aboriginal and Torres Strait Islander people, people with diverse cultural and linguistic backgrounds and people with disability. In addition, DFP will provide reasonable adjustments for individuals with disability throughout the recruitment process. If you identify as a person with disability and require adjustments to the application, recruitment, selection and/or assessment process, please advise via adjustments@dfp.com.au or 1300 337 000 and indicate your preferred method of communication (email, phone, text) so we can keep in touch and meet your accessibility needs.