Job ID: 55783
Job Category: Engineering & Technical
Division & Section: Deputy City Manager Infrastructure Services Office, Strategic Capital Coordination Office
Work Location: City Hall, 100 Queen St. W. Toronto, ON M5H 2N2
Job Type & Duration: Full-time, Temporary (12 month) vacancy
Salary: $113,683.00- $155,216.00
Shift Information: Monday to Friday, 35 hours per week
Affiliation: Non-Union
Number of Positions Open: 1
Posting Period: 09-Jul-2025 to 23-Jul-2025

JOB SUMMARY:

Reporting to the Manager of Strategic Initiatives, the Senior Data Solutions Integrator supports the City’s capital works program by developing systems, datasets, and performance metrics. The role involves coordinating with internal divisions (e.g., ECS, TW, TS, TTC) and external stakeholders (e.g., provincial bodies, utilities, developers) to align infrastructure data with the City’s annual capital delivery cycle.
The Senior Data Solutions Integrator leads infrastructure data analysis, tool development, and performance evaluation for the SCCO. This includes leading business needs assessments and systems planning, and creating communications tools such as dashboards, reports, and websites. The role relies on leveraging tools like Tableau, SharePoint, SQL, QGIS/ArcGIS, Python, and R.

KEY QUALIFICATIONS:

• Post-secondary education in a discipline pertinent to the job function (e.g., Computer Science, Statistics, Data Analytics) or an approved equivalent combination of education and experience (e.g., Engineering, Business Administration).
• Hands-on experience with data integration, and data warehousing including organizing, compiling, manipulating, analyzing and summarizing large datasets.
• Extensive experience in advanced data analytics, coding/programming, interpretation of data, and statistical/AI modeling using Python, R, SQL, or other equivalent tools.
• Considerable experience designing, developing and maintaining automated Business Intelligence Reports, e.g. dashboards, unit performance, etc., using Tableau, PowerBI or equivalent tools.
• Relevant experience in project management, and/or business planning.
• Proficiency in GIS (Geographic Information Systems), spatial analysis, spatial databases, cartography and mapping.
• Strong research, analytical and conceptual thinking skills that can be applied to raw data manipulation/ data modelling, financial analysis, and asset management reporting.
• Excellent written and verbal communication skills to support preparing comprehensive reports and presentations, and summarizing information to support evidence-based decision-making.
• Highly developed interpersonal, negotiation, conflict resolution, and problem-solving skills, with the ability to collaborate, interact and communicate effectively with City Divisions, Agencies, and Boards and Commissions; and to forge solid, effective internal and external relationships.

• Implements detailed plans regarding program specific requirements.
• Plans and develops methods and procedures for collecting, organizing and analyzing data and interpreting results for use in decision making and applies data analytics system planning and operations, data analytics technology, data planning, data policy, and data engineering.
• Performs on-demand, large-scale, exploratory and targeted data research and analysis with integration and analysis tools of large datasets and applies statistical analysis and modeling for applications.
• Uses leading-edge data analytic techniques to analyze large data sets with innovative and analytically-sound deliverables.
• Applies multi-disciplinary concepts to develop and implement innovative solutions to complex problems.
• Designs, performs and interprets data-intensive applied research using varied data sources to support divisional program decisions.
• Develops prototypes, proofs of concepts, algorithms, predictive models, data mining and discovery and custom analysis that leverage the value of available data sets.
• Works with various research methods.
• Uses several data-intensive programming languages and statistical software packages.
• Applies GIS/spatial analysis, web hosting and/or graphical user interface (GUI) development and editing.
• Develops, maintains and implements data management, deployment and use strategy for the division with a focus on employing existing data assets in new ways and leveraging novel, dynamic data sources for evidence-based decision-making.
• Works with various internal and external partners and private sector collectors, disseminators and analysts to collect and analyze data on behalf of the unit.
• Works with partners on developing and implementing a data collection, management, and analysis and dissemination strategy.
• Works with private sector partners to make City data or analysis results available for use by third parties.
• Researches best practices and prepares briefing notes, technical documentation to support analysis, including positions and policies, relating to data management, analysis and dissemination for the unit.
• Ensures that data collection, management, analysis and dissemination are of high technical quality, that recommendations are consistent with the Unit’s and City’s strategic plans and results are produced in a timely and efficient manner.
• Fosters successful relationships and synergies with unit staff and staff of divisional partners and agencies through consultation and mediation, participation, presentations and verbal and written communication.
• Prepares correspondence, presentations and reports to City Council, Standing Committees, Councillors and public inquiries related to divisional matters.