Job Description

Client: Australian Federal Government Department

About the Prospect n

DDP Consulting is seeking an experienced Senior Technical Systems Analyst to support a significant application modernisation and cloud transformation program within a Federal Government department.

n

The program involves modernising a complex legacy application platform, transitioning existing applications, databases, integrations and reporting capabilities to a modern cloud-based architecture using Microsoft Azure.

n

Working alongside Solution Architects, Developers, Data Engineers and business stakeholders, you will analyse existing systems, data structures and business processes to support future-state solution design and delivery.

n

This opportunity would suit a technically focused Systems Analyst with experience investigating complex legacy systems, understanding application and data dependencies, and translating findings into detailed technical specifications.

n

In order to apply, you must be an Australian Citizen and ideally have an Australian Government Baseline security clearance or above.

Key Responsibilities n

n
- Analyse and reverse engineer legacy applications, databases, integrations and data flows to understand current-state functionality and dependencies.
n
- Examine SQL Server databases, stored procedures, data models, schemas and transformation logic.
n
- Analyse data warehousing and reporting solutions, including SSAS/OLAP cubes, dimensional models, measures and calculations.
n
- Review application code, including .NET, C++ and Python, to identify business rules, calculation logic and system behaviour.
n
- Trace data through applications, databases, integrations and reporting layers to document data lineage and dependencies.
n
- Develop detailed system requirements, technical specifications, data mappings, interface definitions and process flows.
n
- Investigate data quality, reconciliation issues and undocumented system behaviours.
n
- Support future-state solution design,



application modernisation and migration to Microsoft Azure.
n
- Work closely with architects, developers, data engineers and business stakeholders to clarify technical requirements.
n
- Support testing, validation and data migration activities to ensure existing functionality and business rules are maintained.
n

Skills and Experience n

We are looking for candidates with experience across the following areas:

n

n
- Technical systems analysis, particularly involving complex or bespoke legacy applications.
n
- SQL Server, including database analysis, stored procedures, queries and data structures.
n
- Data modelling, mapping, transformation, data lineage and reconciliation.
n
- Data warehousing, SSAS/OLAP, dimensional modelling and analytical reporting platforms.
n
- Ability to navigate and analyse application code written in .NET, C++, Python or similar technologies.
n
- Reverse engineering applications and identifying undocumented business rules, integrations and dependencies.
n
- Producing functional and technical specifications, system diagrams, data flows and acceptance criteria.
n
- Working with Solution Architects, Developers and Data Engineers on application and data modernisation initiatives.
n
- Communicating complex technical findings to both technical and business stakeholders.
n
- Application and data migration to cloud-based platforms.
n
- Python scripting, data analysis and automation.
n
- Scientific, environmental, geospatial or computational modelling applications.
n
- Previous experience working within Australian Government environments.
n

About DDP Consulting n

DDP Consulting is a boutique Australian ICT consultancy specialising in digital transformation, technology delivery and ICT recruitment across the Federal Government.

n

We take a personalised approach to recruitment, working closely with our clients and candidates to find the right fit while offering competitive contract rates through our low-margin operating model.

Interested? n

If this opportunity aligns with your experience, we’d welcome a conversation.

#J-18808-Ljbffr

📌 Senior Technical Systems Analyst (Canberra)
🏢 DDP Consulting
📍 Canberra