Job Type: Maximum Term (No longer than 2 years)
Job Category: Information Technology
About Icon Water
Icon Wateris an iconic Canberra business with a history ofproviding essential services to Canberra for over 100years.
We are the ACT's supplier of essential water and wastewater services and have proudly served our community for over 100 years – sourcing, treating and supplying water, and managing Canberra's wastewater network. Our work is essential to the health, prosperity and liveability of the region, and we are committed to environmental, social and financial sustainability in everything we do.
Icon Water is a purpose driven organisation where everyone contributes to our core business, ensuring high quality drinking water and sustainable wastewater treatment. Icon Water's culture is driven by our values of care, connection, community and courage. These are values we see in action every day as we challenge ourselves to meet the expectations of our community.
Job Description
Are you ready to be part of a team that keeps the heart of Canberra flowing? Join Icon Water – Make a Difference in Canberra's Essential Services
This is a12 monthopportunity to jointheDigitalTechnology Group as a Senior Data and Support Specialist. This role has primary responsibility formaintainingand administering the Oracle Utilities Analytics services that support Icon Water's Asset Systems.
Key responsibilities of the roleinclude:
Install, administer,maintainand improve the Oracle Utilities Analytics (OUA) services and other data related services that support the company's Asset Systems suite.
Define, review, develop andmaintainreports using OUA (OBIEE) and BI Publisher.
Manage andmaintainthe synchronisation of data between WAM, MWM and OUA using the Oracle Goldengate platform.
Ensure the availability and performance of OUA reporting and data services meets SLA requirements.
Ensure OUA server resources are optimised, resilient and performance tuned.
Undertake data warehouse management, including ensuring the integrity of all ETL functions.
Undertake scheduled health checks and proactively manage,patchandmaintainthe OUA and data systems to ensure data security, provideoptimalperformance and minimise downtime.
Investigate & resolve escalated incidents and problems relating to OUA, data and reporting, within agreed timescales, ensuring key stakeholders are kept informed on progress.
Who we are looking for: We are looking forsuitablecandidateswithextensive experience using Oracle Business IntelligenceEnterpriseEdition (OBIEE) (mandatory), OracleData Integrator (mandatory) and extensive experience with PL/SQL (mandatory). You will also require:
Significant experiencewith Oracle Golden Gate (mandatory)
Significant experiencein Oracle BI Publisher (mandatory)
Excellent soft skills and collaborative skills (Mandatory)
Experience with Oracle Utilities Analytics (desirable)
Experience with Oracle Utility Applications (WAM and MWM Applications)
Working knowledge of data management in Amazon Web Services (AWS) environments (desirable)
Ifyou'reready to make a real impact and be part of a company that values yourexpertise, apply now.
#J-18808-Ljbffr