Systems Integrator

Job : 58767
Job Category: Information & Technology
Division & Section: Public Health, Operations & Business Services
Work Location: 65 Front St W, Toronto, M5J 1E6
Job Type & Duration: Full-time, Temporary 16 months Vacancy, Possibilty of extension
Hourly Rate and Wage Grade: $52.38- $57.39
Shift Information: Monday to Friday, 35 hours per week, 7 hours per day
Affiliation: L79 Full-time
Number of Positions Open: 1
Posting Period: 5-Jan-2026 to 19-Jan-2026
HR Contact: Bushra Sani,
Division Contact: Nikhil Prasad,

Reporting to the Senior Systems Integrator, Business Intelligence (BI) & Data Services, Systems Integrator 1 (Data Warehouse Admin) will provide expertise and advice related to the Data warehouse (DW) environment sustainment / configuration and support along with maintaining implemented data extracts- transform-load (ETL) solutions and Databases for Toronto Public Health information technology systems and solutions. This Systems Integrator 1 (Data Warehouse Admin) takes initiative and is able to lead the planning, documenting and ongoing support activities of various software systems, with an emphasis on:
Data Warehouse (DW) applications sustainment & process review, software deployment and administration, creation & execution of automation scripts / test plans, implementing software version (patches) update, reviewing and updating DW procedures, and recommending changes to improve service delivery. Additionally, this DW admin must have excellent communication and interpersonal skills to effectively work with various business, TPH IT, and Corporate IT partners.

All activities performed must adhere to established TPH and City of Toronto (CoT) policies and procedures.

• Plans, support & implement Oracle Enterprise Data warehouse (EDW) related applications, Oracle Business Intelligence Enterprise Edition (OBIEE);
  Map viewer, Oracle Web Logic server;
  Oracle Data Integrator (ODI), and data integration via Extract-Transform-Load (ETL) environment for all stages (Development, Test / UAT, Production).
• Using Oracle OBIEE repository (RPD) to create, customize and maintain the End User Layers (Presentation Layer, Physical layer, Business Model & Mapping Layer), creates / updates business subject areas and folders, and defines analytical facilities (semantic layer) for end users, control & maintain the user access.
• Analyzes and develops standard and ad-hoc/BI reports using Oracle tools (OBIEE).
• Evaluates the performance, systems log, installs and configures multi-tiered Oracle Application Server (OAS), Oracle Business Intelligence (OBIEE) and Oracle data integrator (ODI) environment on Linux platform.
• Identifies risks and prepares action plans to mitigate.
• Liaises and co-ordinates with internal & external groups / vendors on accomplishment of deliverables.
• Prepares and presents status report of DW environments and explanation for variances, issues, projects or work packages.
• Prepares findings & “Lessons Learned” from post-implementation reviews, trouble shootings and root-cause analysis
• Assesses, analyzes, evaluates and recommends process & policy alternatives for BI & DW projects & work packages.
• Assist in preparation of DW Logical Data Models and Design documents for proposed solutions that leverage existing DW Start Schema model.
• Updates / maintains Data Warehouse databases / data models using Data modelling tool;
  Ensures data integrity and validation rules in ETLs
• Provides input to BI & DW development team on transformation of clients’ business requirements.
• Recommends improvements to current methodology, process, standards, and policies.
• Assists staff in development implementation for OBIEE, ODI and repository (RPD) using MUD (multi-user development) environment.
• Liaises with staff in development of test strategy, test cases & test scripts for system performance, usability and acceptance testing of system solutions developed.
• Leads team to draft implementation & rollout strategies and plans.
• Conducts walk-through of deliverables to identify potential problems.
• Prepares training material and documentation for use by end users and staff.
• Collaborates with clients on “Go/No Go”…