Company description:

Department of Communities and Justice

Job description:

Senior Application Developer - Data warehouse

• Location - Parramatta (hybrid working)
• Employment type - Ongoing / Full - Time
• Grade - Clerk Grade 9/10
• Salary -$116,211 - $128,061 pa, plus employer's contribution to superannuation and annual leave loading
• Generous leave entitlements including flex leave
• Health and wellbeing benefits including Fitness Passport
• Ongoing career development and support
• Brand new office next to train line - easily accessible

Your role

The Senior Application Developer data warehouse will work within the Information Management (IM) Business intelligence / data warehouse team. This team manages multiple data warehouses supporting Child Protection, HOMES NSW and Youth Justice. The technologies underpinning these data warehouses include the use of Google Cloud Platform (GCP), Tableau and Collibra; Informatica Cloud, Oracle OBIEE and OAC; SAP BoDS and webi reports.

This role will lead the support and creation of new ETL pipelines, data models, reports and dashboards; that facilitate the achievement of business outcomes with process and technology.

This role is at a senior level, and is required to liaise with other developers, business analysts and stakeholders within the IM teams. They need to be able to workshop complex design discussions internally and externally.

What you'll do

• Manage the delivery of a complex range of Business Intelligence / Data warehouse initiatives of varying size and complexity across a wide geographic area to ensure they are all delivered on time, on budget, and meet the needs of the Department and its clients.
• Utilise technical expertise to build and maintain various ETLs, reports, dashboards across all data warehouses utilising webi, Tableau, OAC and any other future technologies.
• Utilise technical expertise and advise in the requirements analysis phase to ensure the solution is both fit for purpose and fit for use.
• Design and execute acceptance testing to improve the quality and reduce operational risk of the developed application.
• Provide ongoing 3rd level support of developed data warehouse applications to reduce the impact of application defects and related incidents.
• Provide ongoing analysis and review of data warehouse development to identify opportunities to improve and enhance availability of analytics for the organisation.
• Maintain currency in knowledge and understanding of application tools and standards of data warehouse and reporting tools. Create, maintain and update all relevant technical documentation.
• Assume technical responsibility for all stages of the development process to ensure compliance with application development standards and achievement of documented requirements.
• Perform maintenance tasks to support the existing build and maintain its currency within various environments.

What we're looking for

Tertiary qualifications in a related discipline and/or equivalent knowledge, skills and experience with demonstrated commitment to ongoing professional development.

Knowledge and experience in ETL, report building, monitoring data pipelines on premise and on cloud and proficiency using tools similar to those listed below.

PL/SQL, Informatica data integration services (IDIS), Oracle 12C, OBIEE, OAC, BigQ, Data Form, Tableau, Looker Studio or other visualisers, SAP BO (Universe Designer - IDT, UDT and webi), SAP BODS

Desirables

• Knowledge of SQL and cloud data bases
• Knowledge of various master data management tools used on cloud platforms and related technologies

Appointments are subject to reference checks. Some roles may also require the following checks/ clearances:

• National Criminal History Record Check in accordance with the Disability Inclusion Act 2014

Working with Children Check clearance in accordance with the Child Protection (Working with Children) Act 2012

Download the role description.

If you are viewing this ad in Seek and wish to apply via their portal, you will be required to either set up a profile or login via your existing Seek account.

To apply directly via the DCJ Careers site click here. Search for the job and click the ‘Apply now' button.

We focus on hiring people who share our commitment and goals of inclusion, collaboration, adaptability, courage and integrity. If you meet the essential requirements and the role resonates with you, please apply - you do not need to meet every desired requirement for us to want to talk to you.

What We Offer

We offer a variety of benefits, including:

• A challenging and rewarding career
• Flexible, autonomous work environment
• Competitive pay and conditions
• Training and development opportunities to build and maintain capabilities
• Health & Wellbeing and Employee Assistance Programs.

Want more information? Visit our website to see more information on Working for us.

We do work that really matters

Working for the Department of Communities and Justice (DCJ) provides lots of opportunities to make a real difference. We collaborate with other agencies and community partners, to improve lives and realise the potential of children, adults, families and communities. We're focused on breaking, rather than managing, disadvantage. It's work that really matters.

Apply now and join Australia's top public sector employer where we will support you and provide an exciting and flexible working environment!

Are you ready to join us?

Click apply, attach a cover letter (maximum 2 pages) outlining how you meet the requirements of the role as well as an up-to-date resume (maximum 3 pages).

Applications close Sunday, 18 May 2025 at 11:59pm AEST.

Got a question?

For more information about the role or what it's like to work for DCJ, please contact the hiring manager Preeti Gandhi at [email protected]

If you've got a question about applying or would benefit from an adjustment in the recruitment process to help you perform at your best (including an alternate method submission of the application), please call Poppy Sgro on 02 9765 3929 or via [email protected]

Visit Recruitment adjustments on the DCJ website to learn more.

Inclusion and Diversity lies at the heart of how we recruit

We continue to hire great people with a wide variety of skills, experience and backgrounds. This includes people with disability, Aboriginal and Torres Strait Islander People, women, people identifying as LGBTIQ+, culturally and linguistically diverse people, carers and other diversity groups.

To find out what DCJ are doing to build an inclusive and diverse workforce, visit Inclusion and diversity on the DCJ website.

Other Information

A talent pool may be created for future ongoing and temporary roles and is valid for a period of up to 18 months.

For more information visit Your recruitment journey on the DCJ website.

Thank you for your interest in this role. We look forward to receiving your application.

To keep up with recruitment opportunities at DCJ, follow us on Facebook: www.facebook.com/CareersatDCJ/

The Welcome Experience
Thinking about moving to regional NSW? Get free, personalised support with housing, schools, jobs, and settling in. Learn more: www.nsw.gov.au/welcomeexperience

The careers site currently promotes this service on the ‘Discover roles with DCJ in regional NSW' page.