SYSTEMS INTEGRATOR 1 (Data Warehouse Administrator)

Job ID: 67643 Job Category: Information & Technology Division & Section: Public Health, Operations & Business Services Work Location: Union Station- 65 Front Street West, Toronto, M5J 1E6 Job Type & Duration: Full-time, Permanent Vacancy Hourly Rate: $52.38 - $57.39 Shift Information: Monday to Friday, 35 hours per week Affiliation: L79 Full-time Number of Positions Open: 1 Posting Period: 13-Oct-2026 to 28-Oct-2026 Job Description Reporting to the Senior Systems Integrator, Business Intelligence (BI) & Data Services, the Systems Integrator 1 (Data Warehouse Administrator) will support the administration, sustainment and ongoing improvement of Toronto Public Health’s Oracle-based data warehouse environment. The role requires strong hands-on experience with Oracle Analytics Server (OAS/OAC) or Oracle Data Integrator (ODI), with experience in both considered an asset. The successful candidate will support related Oracle technologies and services, including OBIEE, Oracle WebLogic, Oracle databases, RPD administration, security, performance monitoring and troubleshooting within a multi-tier, high-availability environment. The position will also support implementation, testing, documentation, system upgrades and migrations, troubleshooting and continuous improvement activities. The successful candidate will work closely with TPH IT, business clients, Corporate IT partners and vendors to support reliable and effective data warehouse services in accordance with established City of Toronto and Toronto Public Health policies and procedures. Major Responsibilities: Administers, sustains and supports Toronto Public Health’s Oracle-based Enterprise Data Warehouse environment across Development, Test/UAT and Production, including Oracle Analytics Server (OAS/OAC), OBIEE, Oracle Data Integrator (ODI) and related Oracle technologies. Monitors system performance, availability and logs; troubleshoots technical issues and supports proactive problem detection, performance tuning and recovery within a multi-tier, high-availability environment. Installs, configures, patches, upgrades and supports Oracle analytics and middleware components, including Oracle WebLogic, within Linux/Unix environments. Maintains Oracle Analytics repositories (RPD), including subject areas, metadata and semantic layers, and supports user access and security configuration, including LDAP/Active Directory integration. Supports the ongoing operation and maintenance of ODI/ETL processes, including job monitoring, troubleshooting, error recovery, data validation and data integrity. Uses Oracle RDBMS, PL/SQL and shell scripting to support Data Warehouse administration, automation, troubleshooting and ongoing sustainment activities. Maintains and supports OAS/OBIEE reports and assists with the migration of reports and related components between environments or platform versions. Reviews system performance, logs and technical issues; conducts root-cause analysis, identifies risks and recommends corrective actions and improvements to processes, standards and service delivery. Liaises and coordinates with TPH IT, business clients, Corporate IT partners and external vendors to support technical deliverables, resolve issues and provide updates on Data Warehouse activities. Supports the development and execution of test strategies, test cases and test scripts for system, performance, usability and acceptance testing. Leads or supports implementation, upgrade, migration and rollout activities, including technical walkthroughs, implementation planning and Go/No-Go cut-over decisions. Prepares and maintains technical documentation, procedures, status information, lessons learned and training materials for staff and end users. Key Qualifications: Your application for the role of Systems Integrator 1 (Data Warehouse Administrator) should describe your qualifications as they relate to: Considerable experience administering and supporting OAS/OAC, OBIEE and/or ODI, with strong …

View the full posting and apply