SYSTEMS INTEGRATOR 1 (Data Warehouse Administrator)

City of Toronto; Toronto; On-site; CAD 95,000 - 104,000; Full time

Job summary

City of Toronto is seeking a Systems Integrator 1 (Data Warehouse Administrator) to support and enhance Toronto Public Health’s Oracle-based data warehouse environment. The role emphasizes hands-on administration of OAS/OAC, ODI, OBIEE, and related Oracle technologies within a secure, multi-tier setup.

The successful candidate will collaborate with IT, business clients, and vendors to ensure reliable data services, documentation, and ongoing improvements in accordance with City policies.

Qualifications

• Experience administering OAS/OAC, OBIEE and/or ODI; asset to have both.
• Experience with Oracle RDBMS, PL/SQL and shell scripting.
• Experience maintaining/migrating reports with OAS/OBIEE in a Data Warehouse environment.
• Post-secondary education in Computer Science, Information Technology or related field, or equivalent.

Responsibilities

• Administers and supports Oracle-based Enterprise Data Warehouse across environments (Dev/Test/Prod).
• Monitors performance, logs, troubleshoots issues, and performs tuning in a multi-tier, high-availability setup.
• Installs, configures, patches, and supports Oracle analytics and middleware components (WebLogic) in Unix/Linux.
• Maintains RPD repositories and manages user access and LDAP/AD integrations.
• Supports ODI/ETL processes, data validation and integrity; assists migrations and upgrades.

Skills

OAS/OAC

OBIEE

ODI

PL/SQL

Shell scripting

Data warehouse

Performance tuning

Root-cause analysis

Communication

Problem solving

Education

CS/IT degree

Tools

Oracle WebLogic

Oracle RDBMS

Job description

Select how often (in days) to receive an alert: Create Alert

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 hands‑on expertise in OAS/OAC or ODI. Experience with both is an asset, along with Oracle WebLogic administration, performance tuning and troubleshooting in high-availability environments.
• Considerable experience with Oracle RDBMS, PL/SQL applications and shell scripting.
• Considerable experience maintaining and migrating reports using Oracle Analytics Server (OAS) and/or OBIEE within a Data Warehouse environment.
• Considerable experience with the BI Administration Tool (RPD) and OAS security setup, including LDAP integration with e-Directory and Active Directory.
• Post‑secondary education in Computer Science, Information Technology or a related discipline, or an approved equivalent combination of education and experience.

You must also have:

• Knowledge of Oracle database environments, including OLTP and OLAP, and familiarity with Oracle Data Integrator (ODI) administration and development.
• Technical knowledge of Oracle Analytics Server (OAS/OAC), OBIEE, Oracle WebLogic and related security components.
• Ability to support the installation, configuration, administration, sustainment and migration of Oracle analytics technologies in UNIX/Linux environments.
• Ability to support performance monitoring, troubleshooting, proactive problem detection and disaster recovery activities within enterprise Data Warehouse environments.
• Strong analytical and problem‑solving skills, including the ability to investigate technical issues and identify root causes.
• Ability to work effectively with multidisciplinary technical and business teams and coordinate with internal and external partners.
• Strong verbal and written communication skills, including the ability to prepare technical documentation and explain technical issues to different audiences.
• Strong customer service orientation and the ability to manage competing priorities and meet deadlines.

Equity, Diversity and Inclusion

The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City’s commitment to employment equity .