Solutions Architect Data, Digital Team

Toronto Police Service; Toronto; On-site; CAD 150,000 - 200,000; Full time

Job summary

A municipal police service in Toronto is seeking a Solutions Architect for its Data Digital Team. The role involves leading data architecture efforts, designing digital experiences, and implementing technical data strategies. Ideal candidates would have an undergraduate degree in a related field, over 5 years of experience, and skills in data management, SQL, and cloud technologies. This is a 24-month contract position offering a competitive salary.

Qualifications

• Minimum 5 years of experience in data architecture and design activities.
• Experience with both on-premise and cloud-based data solutions.
• Proficient in data modeling and SQL development.

Responsibilities

• Lead design and execution of technical data strategy.
• Collaborate with teams to implement enterprise data architecture.
• Supervise and mentor junior staff.

Skills

Data architecture

Problem-solving

SQL programming

Cloud solutions

Agile methodology

Communication skills

Education

Undergraduate degree in Computer Science, Engineering, or Analytics

Certification in Data Modelling

Tools

SQL Server

Oracle

Microsoft Fabric

AWS

Azure

Job description

Posting Title : Solutions Architect Data, Digital Team

Job ID # : 7607

Salary : $71.75 - $83.75

Shift : Days

Hours : 35 hours

Status : 24 Month Contract

Location : 40 College Street, Toronto Police Service Headquarters

Department : Data Management

Vacancies : 1

Job Code : A13ACA

Opening Date : October 29, 2025

Must Apply By : November 11, 2025

The Toronto Police Service is looking for a candidate that shares our core values :

Service at our Core Do the right thing Connect with Compassion Reflect and Grow

The Toronto Police Service is the fourth largest municipal police service in North America. With over 5,000 police officers and approximately 2,500 civilian employees, we are dedicated to delivering best in class police services, in partnership with our communities by being where the public needs the Service the most, by embracing partnerships to create safe communities and by focusing on the needs of the City.

The Opportunity

You will be part of a team who will be designing and building our digital experiences.? You will have a chance to collaborate with communities, business partners, police officers and your colleagues to develop and validate hypotheses to impact policing in Toronto.

This unique opportunity will allow you to learn various platforms and technologies and contribute to continuously improving our digital delivery skillsets as we grow as a team and into multiple teams.? If you are a curious individual who loves to learn, loves change and an environment where you can be expressive and challenged by other ideas, we need you on this team!

The Toronto Police Service is looking for a forward thinking and driven candidate with experience in leading digital transformation projects in a diversity of environments, combined with proven problem-solving skills to aid in the identification of root cause issues and develop creative solutions.

What can I expect to do in this role?

Reporting to the Manager, Data Management, the Solutions Architect - Data will be responsible for leading the design and execution of the Toronto Police Service technical data strategy for the Digital Program and other related initiatives. Working closely with teams across the organization this role will develop, visualize, implement, and maintain an overall organizational data architecture to support TPS product lines and related operations. The architecture includes data model designs, database development standards, implementation and management of data design practices across datamarts, warehouses, Application Programming Interfaces (APIs), and analytics systems.

The Solutions Architect Data has thorough knowledge of data privacy, security, and legislative requirements to ensure the data architecture is designed accordingly and to automate the requirements wherever possible. The role is also responsible for ensuring that data designs support TPS platforms and digital transformation with an emphasis on the governance and evaluation of Artificial Intelligence (AI) and Machine Learning (ML) applications. Required to lead teams and collaborate effectively with stakeholders.

Furthermore, the Solutions Architect Data will design, lead, and implement projects and deliverables. Tey will lead teams and collaborate effectively with stakeholders and supervise junior staff and assigns tasks.

Duties and Responsibilities

Leads TPS data architecture efforts including data model design, database development standards.

Creates, implements and maintains data mesh / fabric, knowledge graphs and related tools for the Service.

Informs the implementation and management of datamarts, warehouses, APIs and analytics systems.

Collaborates with stakeholders on data security, retention, classification, and use to define data standards.

Supervises team members and assigns tasks, responsible for team performance.

Informs standards of end-to-end data lifecycle use including platforms, data models, and solution testing.

Leads the creation of data processes, standards, and methods across data use cases.

Writes professional data system design documents.

Liaises with external data partners and other data specialists to maintain current knowledge and collaboration opportunities using data.

Supports in AI / ML application review and design.

Proactively manages vendor partners, business and technical subject matter experts.

Collaborates with subject matter experts, Command members, partner agencies and community stakeholders.

Responsible for ongoing collaboration to ensure successful implementation and sustainability of the Platforms and Digital transformation strategy.

Exercises professional judgement, strategic thinking, and skill proficiency to propose, support, and / or complete simultaneous complex projects.

Provides required updates using accessible project management tools and proven methodologies to the PMO Manager, CTO, Digital Program Manager, and other stakeholder groups as required.

Develops, prepares and leads the maintenance of up-to-date data artifacts including :

• Knowledge graphs
• Data mesh / fabric
• Metadata management systems
• Data models for Service products and applications

Identifies alignments of data architecture efforts with the Service s strategic priorities and goals.

Leads teams during project implementations. Motivates and engages team members, conveys clear expectations for assignments and holds people accountable for achieving their goals.

Establishes and supports project-working groups and steering committees as required, including creating terms of reference, scheduling and chairing meetings.

Documents project benefits, challenges and lessons learned.

Documents minutes of meetings and action items in a timely manner.

Performs typical duties inherent to the position.

Education / Experience

An undergraduate degree in a related field (Computer Science, Engineering, or Analytics) or an approved equivalent combination of education, training and experience.

A certification in Data Modelling is preferred.

Minimum 5 years of experience, which includes :

• Leading data architecture and data design activities
• Modelling experience within a large organization within information management, business intelligence, and data analytics
• Use of common patterns, frameworks and reference architectures for information management, digital transformation and platform technology design
• Designing both on premise and cloud-based data solutions (AWS, Azure, GCP, Microsoft Fabric) and hybrid architectures to enable use cases in analytics and AI / ML
• Working in agile methodology teams
• Proficient in data modelling and design including SQL development, database administration such as SQL Server, Oracle, DB2, MySQL, MongoDB, NoSQL
• Experience in knowledge graph design involving various technologies
• In depth knowledge of methods and skills including data abstraction, SQL programming and database optimization.

Skills / Competencies

Familiar with data lake, data fabric & mesh, architectures.

Knowledgeable in big data solutions based on open-source technology and familiarity with Hive, Python, Hadoop.

Comfortable with ambiguity and conversant with the application of methodologies to bring structure to projects.

Understanding of policing would be considered an asset.

Familiar with cloud-based platform technologies and how these can be composed into robust solutions.

Familiar with Service Design principals.

Possess strong oral and written communication skills.

Effective troubleshooting and problem-solving skills to aid in the identification of root cause issues and develop creative solutions. Proven ability to transfer knowledge both within and between business units.

Strong business understanding and ability translate operations into data designs.

Strong ability to balance trade-offs and drivers across multiple areas that impact data architecture decisions.

Contact

Lisa Petko, A / Senior Talent Acquisition Advisor

Talent Acquisition

Email : Notes

Competencies may be measured through various selection tools such as test(s) and / or interview.