Lead Data Engineer (Cyber)
Description
Salary: $140-160 per hour inclusive of super
This role can be based in Canberra, Brisbane, Adelaide or SydneyOur client is a large, federal government department that is at the frontline of government service delivery - it’s using cutting edge technology to build world class platforms and capabilities
The solution they are looking to deliver is one to support Vulnerability Management processes within a Protected environment (therefore an understanding of Cyber Security frameworks and whole of government requirements would be of immense benefit)
Role Description:
The Lead Data Engineer will work closely with business and technical teams to deliver continuous improvement of data pipelines and processes
Responsibilities:
- Develop, maintain and optimise enterprise data pipelines, Extract, Transform and Load (ETL) processes and analytical code
- Define and maintain data modelling, peer review, development and release standards
- Lead technical implementation activities from requirements analysis through to deployment and warranty support
- Develop and maintain Structured Query Language (SQL) analytical and ETL code supporting enterprise reporting and analytics
- Optimise and tune SQL code to improve performance and efficiency
- Produce and maintain technical documentation, data dictionaries and implementation artefacts
- Conduct peer reviews of code, data models, and technical designs
- Analyse and translate business requirements into technical solutions and data assets
- Collaborate with business stakeholders, developers, testers and support teams to deliver solutions
- Facilitate knowledge transfer and contribute to team capability uplift
- Support backlog prioritisation, work queue and management, and delivery planning activities
Essential:
- Demonstrated experience in cyber resilience, security remediation or compliance initiatives within large and complex ICT environments; preferably within Australian Government or other regulated environments
- Demonstrated and proven experience in Business intelligence, Data engineering, Data management, Data modelling and design, Data visualisation, Database design, Information management, Quality assurance, Storage management
- Demonstrated experience applying cyber security frameworks, policies and standards, including the Protective Security Policy Framework (PSPF), Information Security Manual (ISM), Essential Eight and other relevant security and risk management frameworks such as the National Institute of Standards and Technology (NIST)
- Experienced in Structured Query Language (SQL), Cloud Platforms - Amazon Web Services, Google Cloud Platform & Microsoft Azure (Current environment is On premise Microsoft SQL and Postgres. There is no data warehouse/datalake integration at this point in time, but something they will look at in future for archiving purposes)
- Proven ability to engage, influence and collaborate with a broad range of stakeholders, including senior executives, technical specialists, business representatives and external providers
- NV1 Security clearance
- Experience working within large scale enterprise environments involving cloud platforms, identity and access management, security operations, infrastructure, applications and data services
- Demonstrated ability to deliver outcomes within tight timeframes while managing competing priorities, dependencies and stakeholder expectations
Demonstrated ability to communicate complex technical and cyber security concepts to both technical and non-technical audiences and contribute to capability uplift through mentoring, collaboration and knowledge transfer activities
Keywords: Data Engineering, Lead Data Engineer, Structured Query Language (SQL), Cloud Platforms - Amazon Web Services, Google Cloud Platform & Microsoft Azure, Cyber Security, Structured Query Language (SQL) analytical and ETL, Protective Security Policy Framework (PSPF), Information Security Manual (ISM), Essential Eight, National Institute of Standards and Technology (NIST), Government, NV! security clearance
At AAR Consulting Group we embrace diversity, inclusion, and equal opportunity. We encourage and support applications from people with a disability.
Please reach out to discuss any accommodations or adjustments that may be needed during the recruitment process via careers@aarconsultinggroup.com.au or 02 9114 8300