City of Toronto

DATA SPECIALIST

City of Toronto$89K — $132K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Post-secondary degree/diploma in Database System Management or Computer Science or equivalent experience.
  • Extensive experience in data management systems, focusing on integrity, security, and backup/recovery.
  • Considerable experience with database concepts and design, system/network architecture, and monitoring tools.
  • Proficient in one or more tools such as Oracle APEX, SQL Developer, and PostgreSQL.
  • Strong background in Quality Assurance and Test processes.

Responsibilities

  • Implement detailed plans and recommend policies for program-specific requirements.
  • Supervise, motivate, and train staff, fostering teamwork and high-quality work.
  • Manage daily operations including scheduling, performance monitoring, and approving leave.
  • Administer and provide input on the budget, ensuring expenditures remain within limits.
  • Lead projects involving modeling and analysis of spatial datasets.
  • Design and build complex models using advanced statistical and predictive techniques.
  • Investigate and apply cutting-edge machine learning methodologies.

Benefits

  • Comprehensive benefits package.
  • Opportunity for professional development and training.
  • Supportive work environment encouraging innovation.
  • Access to cutting-edge technologies and techniques in data analytics.
Full Job Description
Job ID: 63897

Job Category: Engineering & Technical

Division & Section: Toronto Water, Technology & Customer Experience

Work Location: 60 Tiffield Road

Job Type & Duration: Full Time, Temporary (12 month) Vacancy

Salary Range: $89,337.00 -$132,880.00, TM5110, wage grade PTM2

Shift Information: 35 hours per week

Affiliation: Non-Union

Number of Positions Open: 1

Posting Period: 31-Aug-2026 to 15-Sep-2026

Major Responsibilities:

  • Implements detailed plans and recommends policies/procedures regarding program specific requirements.
  • Supervises, motivates and trains assigned staff, ensuring effective teamwork, high standards of work quality and organizational performance, continuous learning and encourages innovation in others.
  • Supervises the day to day operation of all assigned staff including the scheduling, assigning and reviewing of work. Authorizes and coordinates vacation and overtime requests. Monitors and evaluates staff performance, approves salary increments, hears grievances and recommends disciplinary action when necessary.
  • Provides input into and administers assigned budget, ensuring that expenditures are controlled and maintained within approved budget limitations.
  • Leads tasks and projects related to the modelling, analysis, and interpretation of divisional and other spatial datasets.
  • Designs, tests, and builds complex models to solve complex divisional analytics problems, identifying opportunities for using advanced statistical and predictive modelling techniques.
  • Investigates and implements cutting edge machine learning techniques.
  • Develops, implements, and evaluates work plans for divisional data projects and tasks.
  • Explores, analyses, and advises the Team Lead and Manager on the value and applications of, and challenges associated with, emerging datasets.
  • Works with various research methods.
  • Builds processes and methods to ingest and analyze large datasets from structured and unstructured data sources such as GPS-probe data, sensor-based data, and other large datasets.
  • Conducts peer and literature reviews on novel modelling and analysis techniques in spatial data science.
  • Establishes and applies best practices in documenting processes, models, analyses, and code.
  • Keeps abreast of the latest research in the relevant fields, spatial data analytics and machine learning.
  • Serves as a subject matter expert on decisions or questions related to data analytics and modelling.
  • Prepares reports and submissions (e.g. briefing notes, staff reports, and other correspondences) for the Division and City Council.
  • Works with internal and external partners and private sector collectors, disseminators and analysts to collect and analyze data on behalf of the Division.
  • Develops strategies to ensure information is available and accessible for stakeholders including Council, the public, and staff.
  • Attends and presents at conferences and technical working groups, spatial analytics, data analysis, and/or machine learning.
  • Fosters and maintains effective working relationships and networks with divisional staff, other government agencies, and other data science professionals.
  • Monitors and evaluates the functionality of applications developed at the Division, and makes recommendations for enhancements.
  • Ensures compliance with safety and security matters under Occupational Health & Safety legislation and Divisional safety and security policies.
  • Support the Division's production databases and participate in after-hours standby/on-call rotations during holidays and emergency events.
  • Monitor and optimize database performance, capacity, and availability. Develop tools and processes for alerting, reporting, and resource utilization, and collaborate with corporate database administrators and technical specialists to manage database environments and licensing.
  • Establish and maintain database backup, recovery, disaster recovery, and business continuity standards. Provide backup and recovery services and support the implementation of related IT policies and procedures.
  • Plan and execute data conversions, migrations, and database reorganizations to support system integration, consolidation, legacy system upgrades, and server virtualization initiatives.
  • Research and evaluate new database technologies and software releases. Recommend enhancements, standards, and solutions to support evolving information architecture, high availability requirements, and industry best practices.
  • Refresh development, testing, and training databases to support the software development lifecycle. Participate in testing, training, acceptance activities, and quality and security reviews.


Key Qualifications:
  1. Post-secondary degree or diploma in Database System Management or Computer Sciences, or an equivalent combination of education and related experience.
  2. Extensive experience providing implementation analysis and support in data management systems, data integrity, security, backup and recovery.
  3. Considerable work experience with database concepts and design; system/network architecture, operations, protocols, design and development techniques; application support; system and services monitoring tools to support and implement database software and service activities.
  4. Considerable work experience in one or more of the following tools and technical environment but not limited to: Bomgar, OEM, SSRS/SSMS, SQL Developer, Oracle APEX 24.x, MS SQL 2017 to 2022, Oracle 19c, PostgreSQL, Microsoft Power Apps.
  5. Considerable work experience in Quality Assurance and Test processes.

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

Similar Jobs

More Jobs at City of Toronto

More Information Technology Jobs

Find similar DATA SPECIALIST jobs: