Analyst Reporting

About the role

This role is all about turning data into useful insights.

You'll help our operational, policy, and management teams – and the wider public – understand what's happening and why.

You'll work closely with people across MSD, including senior leaders and the Minister's office, to support decisions that affect New Zealanders every day.

Responsibilities

To do well in this role, you'll be able to turn complex information into clear insights and communicate them effectively.

You'll work with data, identify key findings, and help shape solutions that meet real needs in collaboration with others.

Qualifications

Advanced SQL skills – able to write complex queries to extract, transform and analyse data.

Experience with Snowflake SQL – including stored procedures, user-defined functions (UDFs), and Snowflake-specific features.

Strong understanding of dimensional modelling – including star schemas, facts, dimensions, grain, and surrogate keys.

Intermediate Python skills – for scripting, automation and data wrangling.

Great communication and collaboration skills – able to work with business teams, understand their needs, and translate them into technical solutions.

Relevant additional skills

Familiarity with ETL tools like Informatica.

Experience with Azure DevOps and Git – including version control and branching.

Exposure to SAS or legacy code migration.

Understanding of metadata management and data governance.

Ability to contribute to process improvement and help build documentation standards.

About MSD and joining us

We're looking for an Analyst – Reporting to join our team at MSD.

12 months Fixed term / Secondment opportunity

• Wellington based
• Salary range : $90,743- $109,980.

We welcome your application and look forward to learning more about what you can bring to the team.

How to apply

To apply, click the Apply Now button to upload your CV, cover letter and complete the online application form.

Note : Your cover letter will be a key part of our assessment process, so please highlight how your experience relates to the key responsibilities listed in the position description.

All applications must be made online.

If you have any queries, please contact us at

Internal MSD Employees

– please apply through your myHR portal at work.

This will ensure that your myHR employee profile is visible as internal candidate.

Joining us

Joining MSD means being part of a whanau that celebrates the diversity each individual represents.

We show manaaki, care about the wellbeing and success of people, and strive to create a supportive and inclusive working environment.

We are a Treaty partner committed to strengthening relationships with Maori, Hapu, Iwi and communities to realise their own potential and aspirations.

If you have any support or access requirements, please tell us when you apply so we can assist you through the recruitment process.

MSD has a COVID-19 vaccination policy that encourages, but does not require, employees to be fully vaccinated for COVID-19 and its variants, unless the role is identified as requiring vaccination at the time.

#J-18808-Ljbffr