City of Toronto

SYSTEMS INTEGRATOR 1

City of Toronto • $108K — $119K *
Toronto, ON M3C 0E3In-Person
Information Technology
5 - 7 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Post-secondary education in computer science or related discipline, or equivalent experience.
  • Considerable experience in Oracle database development, including SQL and PL/SQL (Oracle19c).
  • Strong background in data analysis and reporting using SQL and Oracle PL/SQL.
  • Experienced in large-scale enterprise IT database solutions, both OLTP and OLAP.
  • Proficiency in data mining, analytics, and visualization using BI tools like Tableau or Jasper Soft.
  • Knowledge of Oracle APEX for medium to large scale system development.

Responsibilities

  • Establish business relationships with clients to understand their needs.
  • Prepare project charters, statements of work, and project plans.
  • Identify risks and devise action plans for mitigation.
  • Lead project delivery teams in accomplishing work packages.
  • Coordinate with internal and external groups to achieve deliverables.
  • Present project status reports and variance explanations.
  • Document 'Lessons Learned' from post-implementation reviews.

Benefits

  • Full-time, permanent position with a Monday to Friday schedule.
  • Opportunity to work in a supportive office environment at Metro Hall, downtown Toronto.
  • Professional development and training to enhance client and staff engagement.
  • Collaboration with multidisciplinary teams fostering a diverse work culture.
  • Access to IT solutions impacting community support services.
Full Job Description
Job ID: 67159
Job Category: Information & Technology
Division & Section: Toronto Shelter and Support Services (TSSS), Program Support Information and Technology
Work Location: Metro Hall, 55 John Street, Toronto
Job Type & Duration: Full-time, Permanent
Hourly Rate: $52.38 - $57.39
Shift Information: Monday - Friday, 35 hours per week
Affiliation: L79 Full-time
Number of Positions Open: 1
Posting Period: 16-Sep-2026 to 30-Sep-2026

Reporting to the Senior Systems Integrator (Development), this Systems Integrator 1 (Oracle DB/BI Developer) will analyze and develop standard and ad hoc/BI reports using Oracle tools. We are looking for your expertise and advice related to the development, implementation, configuration and sustainment of the Toronto Shelter and Support Services information technology systems and solutions.

Major Responsibilities:

The primary responsibilities of this position include, but are not limited to the following:
  • Establishes and maintains business relationships with clients to discuss/assess client's needs.
  • Prepares project charter, statements of work and project plans.
  • Identifies risks and prepares action plans to mitigate.
  • Conducts or leads team in delivery of projects or work packages.
  • Liaises and co-ordinates with internal & external groups on accomplishment of deliverables.
  • Prepares and presents status report and variance explanation for projects or work packages.
  • Prepares findings and "Lessons Learned" from post-implementation project reviews.
  • Assesses, analyzes, evaluates and recommends process & policy alternatives for projects and work packages.
  • Redesigns business principles, processes, policies and standards by recommending best practices and improvements to current processes.
  • Determines business requirements and builds consensus amongst clients.
  • Prepares Business Plans, Gap Analysis, Logical Data Models and Design documents for proposed solutions that leverage information & technology as part of the solution.
  • Provides input to Data Management teams on transformation of clients' business requirements.
  • Recommends improvements to current methodology, process, standards, and policies.
  • Assists staff in understanding of business processes and logic.
  • 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 and conducts walk-through of deliverables to identify potential problems.
  • Prepares training material and documentation for use by clients and staff; and conducts training for clients and their staff.
  • Collaborates with clients on "Go / No Go" cut-over decisions e.g. roll-outs.


Key Qualifications:

Your application must describe your qualifications as they relate to:
  1. Post-secondary education in computer science or related discipline or the equivalent combination of education and/or experience.
  2. Considerable experience in Oracle database development including SQL and PL/SQL (Oracle19c), data/object modelling, data normalization, ETL Process, application performance optimization, plus experience in a high-availability, clustered environment.
  3. Considerable experience in data analysis, using SQL and Oracle PL/SQL coding techniques to extract, and report upon information, business trends, insights and metrics from data stored in the database.
  4. Considerable experience in large scale enterprise IT database solutions (both OLTP and OLAP) and sustainment; implementing systems and solutions, and resolving technical, design and performance issues.
  5. Considerable experience in Data Mining, Data Analytics, and Data Visualization, designing and converting reports using industry standard BI tools such as Tableau, Jasper Soft or equivalent.


You must also have:
  • Knowledge of Oracle APEX to develop/sustain medium to large scale systems.
  • Ability to lead projects or teams in all phases of the project or system development life cycle, using software development and project management methodologies to ensure deliverables are met.
  • Ability to work with competing demands, prioritizing and meeting deadlines.
  • 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.
  • Understanding of application deployment approaches, and standard dev-QA-Production cycles.
  • Understanding of privacy, security and auditing; and how these can be reviewed, monitored, and enhanced with regards to systems implementation.


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