ETL Developer

NEEDED AN AUSTRALIAN CITIZEN WITH BASELINE SECURITY CLEARANCE.

Job details

Software Engineers have experience overseeing software development projects, writing optimised code, and provide technical leadership to a team of software engineers. They are responsible for the quality and functionality of the software produced by their team.

Key duties and responsibilities

The Specified Personnel will be responsible for providing the following deliverables including but not limited to:

• Developing, enhancing and documenting procedures to assist with ETL production support;
• Analysing and resolving ETL production incidents;
• Undertaking data profiling, system analysis and impact analysis;
• Undertaking application development - design, development, testing and documentation of ETL processes;
• Assisting in the physical table, database design and development;
• Understanding and describing requirements and evaluating data for conformance to expectations;
• Providing development effort estimates for changes to existing applications and new applications;
• Providing Code Review and other Quality Assurance tasks for projects and for code delivered by the Section;
• Implementing work standards including design, development and unit testing standards;
• Developing, maintaining and unit testing system components;
• Managing and organising competing priorities and conflicting interests;
• Providing problem diagnosis and resolution;
• Developing positive team ethos within the immediate workgroup through positive participation and communication;
• Developing and maintaining strong effective working relationships with key management personnel and internal client base.

Specified Personnel will be expected to transfer skills and knowledge to departmental staff and ensure appropriate documentation is stored in accordance with the Department's recordkeeping policy and practices.

The Specified Personnel will also be responsible for producing the following deliverables, including but not limited to:

• Technical Specifications;
• System Design Specifications;
• Detailed business requirements documents;
• Technical designs and matrixes;
• Architectural documents;
• System Design Specifications;
• Work flows, events and sequence diagrams;
• UML (Universal Mark-Up Language) charts;
• Environment Context Definitions;
• Deployment plans.

All deliverables performed by the specified personnel must:

• be performed or delivered promptly and without delay in accordance with the timeframes notified by the buyer from time to time; and
• meet the assessment and performance criteria set out in any monitoring and performance assessment processes notified to the seller from time to time.

Essential criteria

1.Programming/software development level 5 - Takes technical responsibility across all stages and iterations of software development. Plans and drives software construction activities. Adopts and adapts appropriate software development methods, tools and techniques. Measures and monitors applications of project/team standards for software construction, including software security. Contributes to the development of organisational policies, standards, and guidelines for software development.

2.Systems integration and build level 5 - Plans and drives activities to develop organisational systems integration and build capabilities including automation and continuous integration. Identifies, evaluates and manages the adoption of tools, techniques and processes to create a robust integration framework. Provides authoritative advice and guidance on any aspect of systems integration. Leads integration work in line with the agreed system and service design. Assesses risks and takes preventative action. Measures and monitors applications of standards. Contributes to the development of organisational policies, standards, and guidelines for systems integration.

3.Methods and tools level 5 - Provides advice, guidance and expertise to promote adoption of methods and tools and adherence to policies and standards. Evaluates and selects appropriate methods and tools in line with agreed policies and standards. Contributes to organisational policies, standards, and guidelines for methods and tools. Implements methods and tools at programme, project and team levels including selection and tailoring in line with agreed standards. Manages reviews of the benefits and value of methods and tools. Identifies and recommends improvements.

Desirable criteria

1.At least five (5) years previous experience working as an ETL Developer.

2.Proven experience in development and solution design in an Enterprise Data Warehouse (EDW) platform

3.Strong understanding of ETL standards, security and governance in a large enterprise wide environment

4.Demonstrated experience with:

o the analysis/design phase of a Software Development Lifecycle (SDLC)

o development and administration across an EDW platform

o developing complex SQL queries and stored procedures as required

o IBM Infosphere DataStage

o Scripting tools (Pearl, SQL, UNIX Shell)

o Data science tools including Python

o Infrastructure as Code for cloud environments

o Information Technology Infrastructure Library (ITIL) framework

o Impact analysis

Job Types: Full-time, Contract

Contract length: 24 months

Pay: $125.00 – $140.00 per hour

Expected hours: 40 per week