City of Toronto

SYSTEMS INTEGRATOR 1

City of Toronto • $104K — $114K *
Toronto, ON M3C 0E3In-Person
Information Technology
Less than 5 years of experience
Reposted Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • University degree in computer science or equivalent education and experience.
  • Significant experience with Oracle Analytics Server (OAS), Oracle Business Intelligence Enterprise Edition (OBIEE), and Oracle Data Integrator (ODI).
  • Proficient in Oracle RDBMS PL/SQL applications and shell scripting.
  • Experience in developing reports using Oracle BI tools within data warehouse environments.
  • Strong knowledge of Oracle BI Administration Tool (RPD) and security setups.

Responsibilities

  • Plan and implement Oracle Enterprise Data Warehouse (EDW) applications and data integration processes.
  • Manage and update Oracle repository to customize End User Layers for better data accessibility.
  • Analyze and create usage reports leveraging Oracle tools and upload them to repositories like SPLUNK.
  • Evaluate and configure Oracle Application Servers in a multi-tier environment.
  • Identify system risks and prepare mitigation plans.

Benefits

  • Comprehensive health benefits package.
  • Professional development opportunities available.
  • Work-life balance with a standard 35 hours per week schedule.
  • Collaborative work environment in a public health setting.
  • Opportunity to contribute to meaningful public health initiatives.
Full Job Description
Job ID: 63864
Job Category: Information & Technology
Division & Section: Public Health, Operation and Business
Work Location: Union Station- 61 Front Street West, Toronto, M5J 1E6
Job Type & Duration: Full-time, Permanent Vacancy
Hourly Rate and Wage Grade: $50.41 - $55.24
Shift Information: Monday to Friday, 35 hours per week, 7 hours per day
Affiliation: L79 Full-time
Number of Positions Open: 1
Posting Period: 20-JUL-2026 to 03-AUG-2026

Job Description:Reporting to the Senior Systems Integrator, Business Intelligence (BI) & Data Services, Systems Integrator 1 (Data Warehouse System 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 and 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 counterparts, TPH IT, and Corporate IT partners. All activities performed must adhere to established TPH and City of Toronto (CoT) policies and procedures.

Major Responsibilities:
  • Plans, support & implement Oracle Enterprise Data warehouse (EDW) related applications; Oracle Analytics Server (OAS), Oracle Business Intelligence Enterprise Edition (OBIEE); Map viewer, Oracle Web Logic server; Oracle Data Integrator (ODI), and data integrations via Extract-Transform-Load (ETL) environment for all stages (Development, Test / UAT, Production).
  • Manages / sustains / updates Oracle 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 usages logs reports using Oracle tools (OBIEE, OAS, ODI), upload it to SPLUNK, other repositories.
  • 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 systems related risks and prepares action plans to mitigate.
  • Liaises and co-ordinates with internal & external groups / vendors on accomplishment of tasks / 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.
  • Understands DW Logical Data Models and Design documents for proposed solutions that leverage existing DW Start Schema model and provide inputs
  • Updates / maintains Data Warehouse databases / data models using Data modelling tool.
  • Ensures data integrity and validation rules in ETLs, maintenance and sustainment.
  • Recommends improvements to current methodology, process, standards, and policies.
  • Assists staff in development/ implementation for OBIEE/ OAS, ODI and repository (RPD) using MUD (multi-user development) environment.
  • Liaise 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" cut-over decisions, e.g., rollouts.

Key Qualifications:Your application must describe your qualifications as they relate to:
  1. University degree in computer science or the approved equivalent combination of education and experience.
  2. Considerable experience in OAS / OAC, OBIEE, Power BI, Tableau & ODI Administration, Performance monitoring/tuning, managing Oracle WebLogic, troubleshooting Load Balancer / network issues in multi-tier High-availability architecture.
  3. Considerable experience in Oracle RDBMS PL/SQL applications, and shell scripts.
  4. Considerable experience in developing / maintaining reports using Oracle Analytics Server or Oracle Business Intelligence (BI) suites in data warehouse environments.
  5. Considerable experience with Oracle database (OLTP and OLAP) and Oracle Data Integrator (ODI) ETL tool in administration and development capacity.
  6. Considerable experience in BI Administration Tool (RPD)and OBIEE security setup including LDAP (e-Directory, AD) integration.


You must also have:
  • Technical knowledge of Oracle BI, Oracle Analytics Server (OAS / OAC), ODI and J2EE/WebLogic applications and in security components.
  • Ability to install, configure and administer the Oracle Fusion Middleware (OFM) i.e. OAS, OBIEE, ODI in enterprise environment on UNIX/Linux server operating systems.
  • Ability to work with Oracle 19c sustainment, implementation and integration with single sign-on authentication mechanisms including MSAD, LDAP, e-Directory, Oracle Internet Directory.
  • Ability to perform logical and physical application server designs, develop and implement procedures that support, maintain and enhance the Oracle Analytics Server (OAS), OBIEE & ODI environment
  • Ability to develop and implement procedures that enable proactive problem detection and avoidance, including disaster recovery planning and implementation.
  • Ability to work effectively with a group of multidisciplinary staff in a project team setting.
  • Ability to effectively communicate both orally and in writing.
  • Strong analytical and problem-solving skills, listening and interacting skills are essential.
  • Strong customer service orientation.
  • Ability to work with competing demands prioritizing and meeting 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.

About City of Toronto

City of Toronto provides its users with information on the lifestyles, business, and locations of Toronto. Lifestyle information consists of health, energy, services, children’s services, arts, culture, festivals, events, housing, and transportation. Business-related information consists of investments, startups, reports, event planning, and city-based partnerships. Furthermore, it provides its users with history, facts, images, events, and attractions of Toronto. City of Toronto is based in Ontario.

City of Toronto Careers

There has never been a better time to explore the diverse job opportunities at the City of Toronto—the hub of professional growth and innovation in the region.

Work You’ll Experience

Join the City of Toronto’s dynamic team to assist in transforming the city through public service and innovative leadership. The City of Toronto offers a unique position in the marketplace, combining public administration with cutting-edge initiatives that enhance the lives of its residents. Engage with a team of skilled professionals dedicated to fostering a culture of diversity, equity, and inclusion. The City of Toronto is not just a place of employment; it is a place where careers flourish and where the professional environment encourages continuous personal and professional development.

City of Toronto Jobs and Employment

The City of Toronto is building a market-leading workforce that supports the city’s vision through strategic leadership and proactive management. This team helps to master the challenges of urban growth and community service.

Innovative Work

At the City of Toronto, innovation isn’t just a buzzword—it's a practical approach to solving real-world issues that affect millions of people. With projects that range from improving municipal services to enhancing urban sustainability, employees at the City of Toronto push the boundaries of what is possible in public service.

Professional Growth and Development

The City of Toronto is committed to nurturing the careers of its employees with unmatched training, development programs, and leadership opportunities. Whether through professional development workshops, leadership training, or diversity training, the City ensures that every team member has the tools to succeed.

Explore Career Opportunities

From internships to full-time positions, the City of Toronto offers a range of job opportunities that cater to various skills and career aspirations. Positions in healthcare, engineering, finance, urban planning, and more are available, providing a broad spectrum of career paths for job seekers.

The City of Toronto Employment Culture

The City’s employment culture is centered on creating a supportive and inclusive workplace. This culture is evident in its commitment to diversity and innovation, where each team member’s contributions are valued and celebrated.

Stay Connected with City of Toronto Careers

Join the Team

Search open positions that match your skills and interests. The City of Toronto looks for passionate, curious, creative, and solution-driven team players. Explore the various benefits, from health insurance to retirement plans, that make the City of Toronto a premier employer.

Keep Up to Date

Stay informed with career tips, insider perspectives, and industry-leading insights—all from the professionals who are part of the City of Toronto team.

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding career opportunities that await at the City of Toronto.

SEARCH CITY OF TORONTO JOBS

READ CAREERS BLOG

Learn more about City of Toronto
Size
10,001 employees
Industry
Education, Government & Non-Profit
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at City of Toronto

More Information Technology Jobs

Find similar SYSTEMS INTEGRATOR 1 jobs:

NationwideToronto, ON