Migration Analyst - Single Digital Patient Record

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 
• Collaborate with business and application experts to understand and execute on ETL tasks 
• 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. 

We recognise that AI tools are increasingly being used to assist with resumes and applications. While we welcome their use, we’re eager to see your personality and get to know the person behind the application! 

For further discussions around the role or recruitment process, including adjustments, please contact our Talent Advisor Sam Matthews at Samuel.Matthews1@health.nsw.gov.au or Hiring Manager, Sheetal Ram at Sheetal.Ram@health.nsw.gov.au and quote REQ592454 

We will review all applications after the closing date. If your application is successful, you may be invited to take part in additional assessments as part of the recruitment process. 

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).
• Successful candidates may be required to attend multiple virtual Epic training sessions and Epic orientation, all scheduled in U.S. time.
• 'Exempt' is defined as a fixed term contract with a length greater than 13 weeks.

#SDPRIA