Senior Oracle Reporting Specialist

Department of Government Services; City of Melbourne; Sur place; AUD 140 000 - 180 000; Plein temps

Résumé du poste

The Department of Government Services seeks a Senior Oracle Reporting Specialist to lead design and delivery of high-performance reporting using Oracle Analytics Cloud (OACS) and BI Publisher. You will architect data models for financial and procurement data, maintain security frameworks, document data lineage, and support complex ETL processes.

The role requires expert Oracle ERP/SQL skills, ODI/OCI familiarity, and a commitment to compliant, auditable reporting across budgeting, forecasting

Qualifications

• Advanced Oracle Reporting toolsets and visualization delivery for enterprise-scale solutions.
• Deep knowledge of Oracle ERP schemas and highly optimized SQL for complex financial data.
• Experience with data integration and ETL tools (ODI, OCI) for high-integrity data movement.
• Ability to design secure data access with row-level governance and semantic layer management.
• Documentation of data lineage and metadata mappings for long-term production support.

Responsabilités

• Lead BI reporting design and delivery across Oracle ERP, EPM and ADW.
• Architect robust data models and optimized SQL for financial data.
• Support ETL processes and ensure high-integrity data flows with ODI/OCI.
• Reconcile ERP and EPM data for budgeting, forecasting and actuals.
• Manage data security, governance and data lineage documentation.

Connaissances

OACS reporting

SQL optimization

Oracle ERP knowledge

ODI & OCI familiarity

Data governance & security

Outils

BI Publisher

Oracle Analytics Cloud (OACS)

ODI

Oracle DB schemas

Description du poste

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

• 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.

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.