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 Oracle Reporting Toolsets & Visualisation Delivery: Expert-level capability in designing, developing, and deploying enterprise-grade reporting solutions using Oracle Analytics Cloud (OACS) and Oracle BI Publisher. Deep Oracle ERP Schema Knowledge & SQL Optimization : Extensive experience designing robust logical data models, writing highly optimized SQL queries against complex Oracle database tables, and ensuring all reporting solutions align with corporate financial standards and best practices.

Data Integration, Pipeline Collaboration & ETL Engineering : Practical familiarity with tools like Oracle Data Integrator (ODI) and Oracle Cloud Infrastructure (OCI) services to facilitate seamless, reliable, and high-integrity data movement from various transactional source systems into an Autonomous Data Warehouse (ADW).

Analytics Security Frameworks & Row-Level Governance : The technical ability to design and configure complex application roles, object-level permissions, and strict Row-Level Security (RLS) policies to protect sensitive financial data and guarantee compliance with rigorous privacy and data governance protocols. Semantic Layer Management & Technical Documentation : Experience modelling complex business logic and data lineages within the semantic layer, ensuring that all transformations, metadata mappings, and calculations remain completely transparent, auditable, and sustainable for long-term production support.

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.