Business Intelligence (BI) Developer - EDWARD
Employment Type: Temporary Full Time (up to January 2026)
Position Classification: Health Manager Level 3
Remuneration: $127,150 - $144,444, plus Superannuation
Location: 1 Reserve Road, St Leonards NSW, in a hybrid working environment
Hours Per Week: 38
Requisition ID: REQ555064
Closing Date: Thursday 6 Mar 2025 (11:59PM)
Join our System Information and Analytics team at Ministry of Health for an exciting temporary employment opportunity up to Jan 2026 and be part of the team enriching health in millions of ways every day.
About us
- Our core values of collaboration, openness, respect, and empowerment are more than just words – they're the guiding principles that shape every aspect of our work.
- Join a passionate team dedicated to innovation and creativity.
- Embrace a healthy work-life balance with our flexible/hybrid working hours.
About the role
With your skills and experience, you can contribute to the millions of ways we’re enhancing health and wellness while developing your career as part of the largest health organisation in Australia.
The Business Intelligence (BI) Developer will work with members of the Enterprise Data Warehouse for Analysis, Reporting and Decision support (EDWARD) technical team on the architecture, design, development and deployment of Data Warehouse and business intelligence systems. The primary purpose of a BI Developer is to design and implement Extract, Transform, Load (ETL) processes to extract data from various sources, transform and cleanse it, and load it into the data warehouse and ensure data integrity and accuracy throughout the ETL process.
Health Manager level 3, starting salary from $127,150 - $144,444 plus Super and annual leave loading, with a 38-hour work week.
What you will do
- Utilise technical expertise in the analysis of user requirements, translate business requirements into design and configuration recommendations, and engage and negotiate with stakeholders to provide high quality BI solutions.
- Assume responsibility of the design, development, testing, support and enhancement of the data models and data marts to facilitate efficient data retrieval and reporting.
- Execute the design, implementation, and unit testing - Extract, Transform, Load (ETL) processes to extract data from various sources, transform and cleanse it, and load it into the data warehouse.
- Monitor and optimize the performance of BI solutions to ensure timely and efficient data retrieval and reporting. Identify and address bottlenecks and optimize query performance.
- Work in a fast-paced team using agile project management methodologies.
About you
We are seeking motivated and committed individuals who can support the work of NSW Health with:
- Bachelor's degree or Diploma in Information Technology (or equivalent).
- Sound knowledge of Data Warehouse concepts, performance tuning T-SQL using execution plan analysis, Dimensional Modelling concepts (Facts/Dimensions) and proficient in source control practices using GIT.
- Demonstrated experience working in both project and production support environments independently when required as well as in a team-based environment.
- Demonstrated experience working in SSIS and working on T-SQL within SQL Server (2012+).
- Familiar with Agile operational methodology, DevOps principles, Microsoft Azure cloud services and Power BI.
- Excellent conceptual and analytical skills with a proven ability to solve problems including the ability to analyse and interpret complex information from numerous sources and deal with challenges creatively and achieve business focused solutions.
- Superior verbal and written communication skills with the ability to articulate issues and solutions in a simple manner.
- Demonstrated ability to work in a fast-paced environment, using Agile project management methodologies.
How to apply
At The Ministry of Health, we want you to make the most of the opportunities you’ll get to grow your skills and your career, surrounded by authentic, smart people and leaders.
Please review the role description and submit your up-to-date resume (up to 5 pages) and cover letter (1-2 pages), please submit the resume and cover letter in one document AND Demonstrate your ability by attaching a response to the two target questions below in the application.
Target Questions
- Describe an ETL process you have worked on, detailing each stage. What were the key extraction sources, transformation logic, and loading strategies you implemented?
- Share an example of how you optimized the performance of a data warehouse. What specific tasks did you undertake, what actions did you implement, and what results did you achieve?
For role related queries or questions contact Harkanwal Singh on harkanwal.singh@health.nsw.gov.au and quote REQ555064.
If you do require any adjustments to the recruitment process during the recruitment process, please contact Rebecca Chan on rebecca.chan3@health.nsw.gov.au
Closing Date: Thursday 6 Mar 2025 (11:59PM)
Need more information?
1) Click here for the Position Description
2) Find out more about applying for this position
Our commitment to Diversity and Inclusion
At the NSW Health we are committed to creating a diverse, inclusive and flexible environment which reflects the community and customers we serve. We actively promote the employment of women, people with a disability, Aboriginal and Torres Strait Islander peoples, LGBTIQ+ community and people from culturally and linguistically diverse backgrounds.
If you identify as Aboriginal or Torres Strait Islander and would like assistance with your application or to obtain more information on how to apply please visit The Stepping Up Initiative .
To be eligible for employment in these roles you must be an Australian citizen, or a permanent resident of Australia, or a New Zealand citizen with a current New Zealand Passport, or hold a valid visa with permission to work in Australia.
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.
- Please note the selection process will include a range of comparative assessment techniques to assist in determining your suitability for the role.
For more information about working at the NSW Health, please visit our career portal.
Applications Close: Thursday 6 Mar 2025 (11:59PM)
