Migration Analyst

**Position**:Migration Analyst - Single Digital Patient Record

**Employment Type**:Temporary Full-Time for up to 3 years with a possibility of extension
- Opportunity to work from our modern Chatswood, St Leonards office
- Attractive salary, up to $144,444 + 12% Super and annual leave loading
- Allocated day off per month, salary packaging, discounted fitness passport and more
- Join the team enriching health in millions of ways every day through digital innovation

**Applications Close**: 11:59pm, Sunday 3 August 2025.

**About Us - Single Digital Patient Record (SDPR), NSW Health**
Be part of the team leading the largest digital transformation in Australia's public health history. NSW Health's SDPR program is transforming the way patient care is delivered and experienced - creating a single, secure, holistic, and integrated view of patient information across the entire state.

By connecting every corner of the NSW public health system, this groundbreaking program empowers clinicians and care teams with real-time access to unified patient data - enabling safer, more transparent, and quality care for every person, anywhere.

Join us now and contribute to the millions of ways we're enriching health every day.

**About the Opportunity**
As a Migration Analyst within our Single Digital Patient Record Implementation Authority (SDPRIA) team, you will help make a real difference in healthcare by ensuring relevant clinical and operational patient data is migrated from current clinical systems into the statewide SDPR solution. Your work will ensure clinicians can access critical clinical and operational patient data for the continuation of optimal clinical care without disruption.

This role offers the opportunity to interact with a range of complex clinical systems and enterprise solutions such as the NSW Health Enterprise Data Lake to support the accurate and timely extraction, analysis, translation and migration of patient data. You'll work with large-scale health datasets and tools such as SQL, SQL Server Integration Services (SSIS)

In this role, you will:

- **Extract, analyse, transform, and load** data from multiple clinical source systems into a target state-wide clinical system
- **Define** data transport methods by which extracted source system data will be migrated to the target system
- **Analyse and translate** source system data into appropriate formats (E.g. HL7, XML, JSON etc.) for migration into the target system
- **Lead validation activities**and** investigate and resolve** ETL related issues to ensure data from source systems are successfully migrated into the target system

**About You**

We are looking for someone who:

- Has **advanced SQL skills and experience** in a large, complex service industry environment
- Brings **extensive knowledge of complex data models** and demonstrated experience working with large and complex databases, preferably with health data, **using IDEs such as SQL SSMS, Oracle SQL Developer and Snowflake**:

- Is experienced with **analytics tools, Snowflake, ETL processes, SSIS**and **writing custom SQL queries for migration, reporting and dashboards.**:

- Holds a **relevant qualification in Computer Science or a related field**:

- Can **work both independently and collaboratively**, demonstrating resilience and problem-solving under pressure
- Has experience with **version control, change management processes**, and requirement gathering for reporting solutions

**Need more information?**
- Position description
- Check out our diversity and inclusion commitment
- Learn more about Single Digital Patient Record

**Working at SDPR**

Our people are at the heart of who we are. We support our people with great benefits so they can enrich health in millions of ways every day:

- Professional growth and career development
- Allocated day off per month
- Salary packaging
- Various health and wellbeing programs to support our team

**How to apply**

Share with us your **cover letter** and most up to date **resume** (up to 5 pages), highlighting your relevant skills and experience.

**Additional information**
- This recruitment may be used to create a Talent Pool for similar future roles (ongoing or temporary) that may arise over the next 18 months.
- To be eligible for this role you must have current Australian work rights (Australian citizen, permanent resident, New Zealand citizen with a current passport, or hold a valid visa with permission to work in Australia).
- 'Exempt' is defined as a fixed term contract with a length greater than 13 weeks.

SDPRIA

.