Senior Software Engineer

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:

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

About the team

The Data Integration & Engineering Section (DI&E) develops and maintains data assets in the Connected Information Environment (CIE), which are used to support business information reporting, risk assessment and intelligence analysis.

About the organisation

The role will contribute to the development of systems that the Data Integration& Engineering Section develops and support that: integrate cross-domain data sources to provide a consistent and consolidated view, support consistent domain-level data use and support particular reporting and analytical needs via specific data marts. The role will also assist DIE Section with: maintaining the infrastructure supporting the CIE, managing database administration and undertaking performance management.

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. ), ITIL
o Data analysis
o Impact analysis

Successful applicants must work full time on site for 1 month or until they understand the department’s ICT landscape, requirements and project objectives. Flexible working arrangements may be considered afterward, subject to approval per the Department’s operational needs and ICT Contractor Working from Home Guidelines. Contractors must be on-site in Canberra at least 2 days per week. Remote work costs (eg travel, accommodation, utilities, and equipment) are the contractor’s responsibility.