CaSPA Lead Developer
Employment Type: Permanent Full Time
Position Classification: Health Manager Level 4
Remuneration: $137,173 - $163,431, plus Superannuation
Location: 1 Reserve Road, St Leonards NSW, in a hybrid working environment
Hours Per Week: 38
Requisition ID: REQ515424
Closing Date: Friday 08 November 2024 (11:59PM)
Where you'll be working
You will be working with a diverse and dynamic team within Health System Support Group (HSSG) and based at 1 Reserve Road, St Leonards, NSW 2065. HSSG is a unit of the Public Health System Support Division of the Health Administration Corporation to provide services to support the public health system in implementing Government targets and programs.
For more information go to www.health.nsw.gov.au
About this role
PRIMARY PURPOSE
The Clinical Services Planning Analytics (CaSPA) Lead Developer is responsible for the development and maintenance of the CaSPA Portal as well as its data focused applications. This position is the main technical resource for health service planning related data and information systems which are managed by the CaSPA Team within the Strategic Analysis and Investment Unit (SAIU).
KEY ACCOUNTABILITIES
- Responsible for design & development of analytics applications, data marts, ETL processes, dimensions/facts, MSBI SSAS Cubes & BI reports.
- Responsible for ETL jobs and data quality testing for data feeds from the upstream enterprise data warehouse feeding into the CaSPA data analytics applications.
- Research, analyse and implement adjustments to data marts to meet new business requirements and periodic data refresh (e.g. extensions to include new subject areas/datasets on a quarterly/annual basis).
- Update Tabular and Multidimensional data models and any BI tools/reports which are a part of CaSPA based on business requirements.
- Monitor and maintain a high standard of data quality and database performance by optimising the solution code database and server configuration on an ongoing basis.
- Support the CaSPA Application Manager in day-to-day management and maintenance of the CaSPA Portal and applications including responding to complex data queries and requests from users of CaSPA data and other SAIU teams.
- Research, analyse and suggest advances in technology to enhance functionality and performance for the CaSPA applications including developing proof of concepts.
KEY CHALLENGES
- Ensuring that the CaSPA Portal contains up-to-date data and applications that are relied upon for service and capital planning in the Ministry and the LHDs.
- Anticipating and planning for the technical complexities inherent in information system development, support and integration across complex and expanding data collections as well as new applications.
- Maintaining an awareness of current developments within planning and projection methodology to incorporate into the CaSPA Portal and supporting the SAIU Team as the main technical resource and provide expert advice on ICT issues.
- Completing the work required in the period allocated, requiring close attention to project timetables and milestones, and the capacity to organise work and meet deadlines in a high volume, high-pressure work environment.
- Successfully managing additional data quality testing, data migration and data reconciliation as new data sources including a new data warehouse are introduced.
Candidate Assessment
You may be asked to undertake further assessments as part of the recruitment process for this position, which may include, but is not limited to, psychometric assessment (e.g. personality and cognitive abilities assessments) and/or particular work tasks.
How to apply
Your application to be considered should include:
- Responses by addressing the [selection criteria] below.
- A Cover Letter of no more than one (1) page expressing your interest and suitability for this role.
- An up-to-date resume of no more than five (5) pages which clearly details your skills and experience as relevant to this role.
- 2x referees will need to be supplied prior to an offer being made.
- Application must be lodged electronically. Please go to https://jobs.health.nsw.gov.au/ and search Job Reference Number REQ515424 to submit your application.
Selection Criteria
- Relevant qualifications or equivalent experience in development, implementation and maintenance of database information systems in a large and complex service environment. This includes extensive knowledge and demonstrated experience in:
- MS SQL, T-SQL Transactions and SSAS Cubes
- Data Modelling and Data Warehousing
- Data Quality, Data Administration and Performance Troubleshooting
- Excellent analytical skills including the ability to analyse and interpret complex information from numerous sources, prepare and present analysis and reports, deal with challenges creatively and achieve business focused solutions.
- Excellent organisational skills and experience working in a high volume and demanding professional environment with a capacity to prioritise, multi-task, achieve business goals, perform and always work with a customer focused approach.
- Well-developed interpersonal, influencing and negotiation skills with demonstrated experience engaging and influencing key stakeholders and customers to influence and achieve optimal business outcomes.
- Working knowledge of most, if not all, of the following technologies:
- SAS
- DAX
- MDX
- CI/CD Pipeline
- Azure Data Factory
- Azure Synapse Analytics
- Azure DataBricks
- PowerBI
- Git
Need more information?
- Click here for the Position Description
- Find out more about applying for this position
For role related queries or questions contact Raj Sambyal on raj.sambyal@health.nsw.gov.au
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. - If you are current NSW Health, NSW Ministry of Health or NSW Government staff and are looking for opportunity of Secondment, you must have your manager’s approval prior to expressing interest.
- For more information about working at the NSW Health, please visit our career portal.
Applications Close: Friday, 08 November 2024 (11:59PM)
