Senior Oracle Reporting Specialist

About Us 

The Department of Government Services (DGS) was established on 1 January 2023 to improve everyone’s experience of doing business and interacting with the Victorian government.  We bring important day-to-day services together in one department to make things easy and seamless for Victorians and businesses.  We are doing this by connecting and digitising our systems and platforms across state and local government as well as streamlining our corporate and procurement services.   

You can find out more about our Ministers, leadership and entities here: Department of Government Services.  

About the Group

The Operations Group delivers frontline customer services to Victorians and the public service. It maintains the foundational digital infrastructure and platforms that support efficient, secure and reliable service delivery.

About the Role 

The Senior Oracle Reporting Specialist leads the design and delivery of high-performance reporting solutions and interactive dashboards using Oracle Analytics Cloud (OACS) and BI Publisher.  This role acts as a technical anchor, leveraging expert knowledge of Oracle ERP/EPM schemas to architect robust data models for financial and procurement data. The role is also responsible for maintaining security frameworks, data lineage documentation, and supporting on complex ETL processes.

Key Accountabilities

• Lead BI reporting solution design and delivery, developing scalable reporting and dashboard solutions using BI Publisher and OACS across Oracle ERP, EPM and ADW.
• Apply advanced Oracle Financials and Procurement expertise, designing robust data models and optimised SQL across core financial schemas.
• Support data integration and ETL processes, collaborating with ODI and OCI specialists to ensure reliable, high-integrity data flows into the Autonomous Data Warehouse.
• Integrate and reconcile ERP and EPM data, ensuring consistent and accurate information for budgeting, forecasting and actuals.
• Manage data security, governance and documentation, including OACS roles and permissions, data lineage, semantic layers and compliance with financial data access requirements.

About You  

To be successful in this role, you will need to possess the following attributes:

• Advanced OIC Expertise: Extensive hands-on experience in OIC (Gen3), including deep knowledge of the Oracle ERP Cloud Adapter, EPM Adapter, and REST/SOAP/FTP adapters and handling complex file-based integrations (FBDI/HDL).
• Enterprise EcoSystems: Proven experience supporting and maintaining integrations within Oracle ERP Cloud (Finance) and Oracle EPM, ensuring data consistency between transactional and reporting layers.
• System Interconnectivity: Demonstrated experience managing integrations with third-party legacy or bespoke systems using REST/SOAP APIs and SFTP protocols.
• Tertiary Qualification: A Bachelor’s or Master’s degree in Business (Accounting/Finance), Information Technology, Computer Science, or a related field is highly desirable
• Oracle Certification: Certification in Oracle Integration Cloud (OIC) or similar tools is highly desirable.

This role is Ongoing and is only open to applicants with relevant rights to work in Australia. 

For more information, please see the Position Description

How to apply  

Apply before the advertised closing date 11:59pm on 16 October 2026. All applications should include:   

·       a resume; and   

·       a cover letter which addresses the key selection criteria (within three pages). 

Other relevant information 

To be eligible for appointment to this role, applicants will possess corresponding work rights for the advertised employment period. Appointment to an ongoing role is only available to an Australian/New Zealand citizen or an Australian Permanent Resident.  Preferred applicants will be required to undertake pre-employment screening. DGS actively promotes diversity, inclusion and an equal opportunity workplace. We welcome applicants from all diverse backgrounds, including people with disabilities and Aboriginal and Torres Strait Islander peoples. All roles at DGS can be worked flexibly, however it may differ from role to role.