Systems Integrator 1 (Data Warehouse Administrator) Job In Canada | Job Openings Hub

If you are looking for a full-time Systems Integrator 1 (Data Warehouse Administrator) job with real-world impact, an exciting opportunity is available. The job is for individuals offered by City of Toronto for those who are willing to work as a Systems Integrator 1 (Data Warehouse Administrator). City of Toronto, located in Toronto, has an opening for a Systems Integrator 1 (Data Warehouse Administrator) in Public Health, Operations & Business Services Division. City of Toronto is offering permanent full-time employment with a competitive hourly rate and strong development opportunities.

If you have post-secondary education in Computer Science, Information Technology or related discipline and considerable experience administering and supporting OAS/OAC, OBIEE and/or ODI with Oracle RDBMS and PL/SQL, you will find a good chance to join their team.

Job Overview

Job Requirements

City of Toronto is looking for a Systems Integrator 1 (Data Warehouse Administrator) to join Toronto Public Health, Operations & Business Services.

• 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
• Knowledge of Oracle database environments, including OLTP and OLAP, and familiarity with Oracle Data Integrator (ODI) administration and development
• Ability to support 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 ability to investigate technical issues and identify root causes

Bonus skills:

• Technical knowledge of Oracle Analytics Server (OAS/OAC), OBIEE, Oracle WebLogic and related security components
• Experience with Oracle Analytics repositories (RPD), including subject areas, metadata and semantic layers
• Experience supporting ongoing operation and maintenance of ODI/ETL processes, including job monitoring and error recovery
• Ability to work effectively with multidisciplinary technical and business teams and coordinate with internal and external partners
• Strong verbal and written communication skills, including ability to prepare technical documentation and explain technical issues to different audiences
• Strong customer service orientation and ability to manage competing priorities and meet deadlines

Key Responsibilities

As a Systems Integrator 1 (Data Warehouse Administrator), you will support the administration, sustainment and ongoing improvement of Toronto Public Health’s Oracle-based data warehouse environment.

• Administer, sustain and support 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)
• Monitor system performance, availability and logs; troubleshoot technical issues and support proactive problem detection, performance tuning and recovery within multi-tier, high-availability environment
• Install, configure, patch, upgrade and support Oracle analytics and middleware components, including Oracle WebLogic, within Linux/Unix environments
• Maintain Oracle Analytics repositories (RPD), including subject areas, metadata and semantic layers, and support user access and security configuration including LDAP/Active Directory integration
• Support ongoing operation and maintenance of ODI/ETL processes, including job monitoring, troubleshooting, error recovery, data validation and data integrity
• Use Oracle RDBMS, PL/SQL and shell scripting to support Data Warehouse administration, automation, troubleshooting and sustainment activities
• Maintain and support OAS/OBIEE reports and assist with migration of reports and related components between environments or platform versions
• Review system performance, logs and technical issues; conduct root-cause analysis, identify risks and recommend corrective actions and improvements
• Support development and execution of test strategies, test cases and test scripts for system, performance, usability and acceptance testing
• Prepare and maintain technical documentation, procedures, status information, lessons learned and training materials for staff and end users, and lead or support implementation, upgrade, migration and rollout activities

About City of Toronto

The City of Toronto is an equal opportunity employer dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that it serves. The City is committed to creating an accessible and inclusive organization in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Toronto Public Health’s Oracle-based data warehouse environment supports reliable and effective data services in accordance with City policies and procedures.

Benefits of Working as a Systems Integrator 1 (Data Warehouse Administrator)

This position offers multiple benefits that you will receive if you are selected for Systems Integrator 1 (Data Warehouse Administrator).

• Permanent full-time employment with hourly rate $52.38 – $57.39, 35 hours per week, Monday to Friday
• Work location at Union Station – 65 Front Street West, Toronto, M5J 1E6
• Affiliation L79 Full-time with City of Toronto benefits and pension
• Equal opportunity employer with commitment to employment equity and inclusiveness
• Barrier-free and accessible employment practices with accommodation available upon request
• Opportunity to work with Oracle-based Enterprise Data Warehouse technologies and high-availability environments
• Work closely with TPH IT, business clients, Corporate IT partners and vendors
• Strong hands-on experience development in Oracle Analytics Server, ODI, and related technologies

How to Apply?

Please apply on company site via City of Toronto careers. Job ID: 67643. Posting Period: 13-Oct-2026 to 28-Oct-2026. City of Toronto employees must apply via Internal Job Posting Portal. Application deadline is 28-Oct-2026.