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:

1. 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.
2. Considerable experience with Oracle RDBMS, PL/SQL applications and shell scripting.
3. Considerable experience maintaining and migrating reports using Oracle Analytics Server (OAS) and/or OBIEE within a Data Warehouse environment.
4. Considerable experience with the BI Administration Tool (RPD) and OAS security setup, including LDAP integration with e-Directory and Active Directory.
5. 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.

NOTE TO INTERNAL FULL-TIME AND PART-TIME CITY OF TORONTO EMPLOYEES:

City of Toronto employees must apply to full-time or part-time employment opportunities posted on the City's Internal Job Posting Portal.

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.

The City of Toronto is committed to creating an accessible and inclusive organization. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require Code-protected accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs. Disability-related accommodation during the application process is available upon request. Learn more about the City's Hiring Policies and Accommodation Process.