Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 3 months ago
OG
Technology Consulting Lead
Onni Group of Companies
Vancouver, BC
- Full-time
Familiarity with tools such as Claude, Claude Code, Linear, Slack, Databricks, Microsoft Azure, or simil
Added 3 months ago
B
Senior Analyst, Application Integration
Brookfield
Toronto, ON
- Full-time
Experience with Snowflake, Databricks, SQL Server, ADO (Azure DevOps), Jira, Informatica & Qualytics
Added 3 months ago
B
Principal Cloud Security Engineer
BMO
Toronto, ON · BMOPLACE
- Full-time
We are seeking an enthusiastic and passionate professional for a Senior Cloud, AI & Data Security Engineer role who wants to design and implement security solutions for systems and services…
Added 3 months ago
P
Deals Value Creation Analytics Senior Associate
PwC
Toronto, ON · Montreal, QC
- Full-time
Experience integrating disparate data sources and structuring, cleansing, and transforming data using tools such as Alteryx, SQL, Python, Databricks, or Power Query
Added 3 months ago
M
Senior Manager, Advanced Analytics
MNP
Ottawa, ON · Toronto, ON
- Full-time
Make an impact with MNP Digital as a Senior Manager, Advanced Analytics. You will be an integral part of the team responsible for leading and collaborating with the Business Intelligence…
Added 3 months ago
DT
Senior Solutions Principal
Dell Technologies
Toronto, ON
- Full-time
· Hands-on experience with at least one major public cloud (AWS, Azure, or GCP) and one or more leading data platforms (e.g., Snowflake, Databricks, Cloudera, BigQuery, Redshift, Synapse).
Added 3 months ago
SG
Staff Machine Learning Engineer
SCIENTIFIC GAMES
Montreal, QC
- Full-time
Familiarity with Databricks, Azure ML, SageMaker, Vertex AI, or equivalent ML platforms
Added 3 months ago
SI
IT Architect, Architecture & Analytics – Enterprise Analytics
Saputo Inc.
Montreal, QC · Saint-Laurent, QC
- Full-time
…join our Data Engineering & Analytics team. Reporting to the Senior Director of Data Engineering & Analytics, this role will play a critical part in the design and evolution of our…
Added 3 months ago
M
Senior Data Specialist
McKesson
Mississauga, ON
- Full-time
Flex & Connect model requiring 2 days per week in office
Added 3 months ago
Senior Data Engineer
Talents LGS
Montreal, QC
As part of the growth of our Hybrid Cloud & Data practice (AI, Analytics & Data Services), we are looking for a Senior Data Engineer – Hybrid Cloud & Data to participate in the design,…
Added 3 months ago
B
Senior Data Engineer
BrainStation
Toronto, Ontario
- $120,000 to $145,000 CAD / year
- Full-time
As a Senior Data Engineer you’ll be tasked with designing, building, and maintaining scalable data platforms and pipelines. Your deep knowledge of data platforms such as Azure Fabric,…
Added 3 months ago
MC
Data Scientist
Meridian Credit Union
Toronto, ON
- Full-time
Proficiency in Microsoft Azure, including Azure Data Factory, Azure Databricks, and Azure Synapse Analytics.
Added 3 months ago
BC
Director, Data, AI, & Automation Services
Bird Construction
Calgary, AB · Vancouver, BC · Mississauga, ON
- Full-time
Lead the modernization and operation of Bird's enterprise data platform, including lakehouse, Azure Databricks, semantic models, enterprise data models, metadata, data pipelines, and…
Added 4 months ago
B
Senior Data Engineer
BrainStation
Toronto, Ontario
- $120,000 to $145,000 CAD / year
- Full-time
As a Senior Data Engineer you’ll be tasked with designing, building, and maintaining scalable data platforms and pipelines. Your deep knowledge of data platforms such as Azure Fabric,…
Added 4 months ago
S
Architecte en IA agentique - Intelligence Engineering / Agentic AI - Sr. Architect - Intelligence Engineering
Slalom
Montreal, Quebec
- Full-time
…réinvention de flux de travail humains sur Amazon Web Services, Azure et Google Cloud. Cela comprend l’architecture de systèmes multiagents, de flux de travail autonomes propulsés par des…
Added 4 months ago
S
Agentic AI Architect - Intelligence Engineering (Toronto)
Slalom
Toronto, Ontario · Greater Toronto Area, Canada
- Full-time
As a Senior Architect or Architect in Intelligence Engineering, you’ll design and deliver innovative AI/ML and agentic AI solutions as part of intelligent products and automating /…
Added 3 months ago
PS
Senior Applied AI Engineer
Public Sector Pension Investment Board
Montreal, QC
- Full-time
Comfortable across cloud platforms - we run primarily on Azure (Databricks, AKS) and Google Cloud (Vertex AI)
Added 2 months ago
P
Senior Applied Researcher AI/ML ( CAD)
PointClickCare
Canada
- Full-time
Experience working with large datasets using big data frameworks (e.g. Azure Data Lake, Apache Spark or Databricks)
Added 4 months ago
B
Senior Data Engineer
BrainStation
Toronto, Ontario
- $120,000 to $145,000 CAD / year
- Full-time
As a Senior Data Engineer you’ll be tasked with designing, building, and maintaining scalable data platforms and pipelines. Your deep knowledge of data platforms such as Azure Fabric,…
Added 4 months ago
A
Senior Software Engineer, Full-stack (Distribution Center)
Afresh
Ontario
- $137,000 to $205,000 CAD / year
- Full-time
Python, PostgreSQL, GraphQL, Databricks, DBT, Terraform/OpenTofu, Azure, pair programming, test-driven development
Added 4 months ago
B
Manager, Data Engineer
Brookfield
Toronto, Ontario
- Full-time
…expertise in data engineering, particularly with platforms like Databricks and Snowflake, to spearhead the design, implementation, and optimization of our data models. The ideal candidate…
Added 4 months ago
P
Senior Site Reliability Engineer, AI Infrastructure
PointClickCare
Mississauga, Ontario
- $139,000 to $155,000 CAD / year
- Full-time
…and leading incident response across cloud environments like Databricks, Azure AI suites. The team collaborates closely with research, platform, data, and security teams across the AI…
Added 3 months ago
O
Senior Data Engineer
OMERS
Toronto, ON · Head Office Toronto
- Full-time
The Senior Data Engineer will join the Software Engineering team that leads the delivery of data and application solutions that enable OMERS Global Investments (GI) and Corporate teams to…
Added 3 months ago
S
Senior Data Engineer
ShyftLabs
Toronto, ON
- Full-time
ShyftLabs is seeking an experienced Senior / Lead Data Engineer to lead the design, architecture, and delivery of enterprise-scale data platforms for Fortune 500 organizations. This is a…
Added 3 months ago
PF
Decision Science Analyst
Pattison Food Group
Langley (District), BC · Langley Office - Langley BC
- Full-time
Working knowledge of cloud environments, such as Azure, GCP or AWS. Experience with big data tools such as Spark and Databricks is an asset.

Closed listing

Optimus SBR

Data Engineering Solutions Architect - Technology Services Group

Toronto, ON, Canada

Compensation: Salary Range is $110,000-$160,000 CAD · Full-time

This opening has closed.

The original listing is kept below for reference.

Find open jobs More jobs with this employer

About employer

Job details

Pay: Compensation: Salary Range is $110,000-$160,000 CAD
Job type: Full-time
Closing date: Oct 20, 2026
Posting language: English
Posted: Sep 20, 2026

Similar jobs hiring now

Search current openings

Original job description

Archived listing. The details below describe a past opening.

Continued growth has created an exciting opportunity for a Data Engineering Solutions Architect (Manager/Senior Manager Level) to join our Technology Services Group.

In this role, you will design and build modern data solutions that combine robust data engineering practices with strong data architecture and modeling discipline. You will collaborate with a team of high-performing professionals and entrepreneurial thinkers who share a passion for helping clients transform how they use data.

You are ambitious, adaptable, and energized by solving complex problems in fast-paced environments. You’re comfortable engaging directly with clients, wearing multiple hats, and navigating shifting priorities while delivering high-quality technical solutions.

About Us
Optimus SBR is a leading management consulting firm and award-winning workplace where we help organizations get done what isn’t.

Our team of committed consultants takes swift action to deliver innovative, impactful results. As the largest independently owned Canadian management consulting firm, we are a place where people and culture come first. Our success is driven by attracting individuals who are insatiably Curious, Entrepreneurial Thinkers, Authentic, and Bold.

Our Awards and Recognitions:

Best Workplaces™ in Canada National List 2026
Best Workplaces™ with the Most Trusted Executive Team 2026
Best Workplaces™ for Young Talent 2026
Best Workplaces™ for Women 2026
Best Workplaces™ in Professional Services 2025
Globe and Mail – Canada's Top Growing Companies 2025
Waterstone Human Capital - Canada’s Most Admired Corporate Cultures™ 2025

Culture is Everything. Period.
That’s why we’ve been consistently rated one of the best places to work in North America – and are one of the fastest growing. As a firm that was built on culture, we value our people and their growth. Each of us embody the entrepreneurial spirit and have something unique to contribute to the fabric of our organization. From employee-championed committees to celebratory events and learning paths, these are just a few of the ways we cultivate a positive and engaging work environment.

What’s in It for You?

Growth Opportunities: Build your career through challenging, impactful projects and continuous learning
Diverse Workplace: Collaborate with a team of professionals from unique backgrounds, fostering innovation
Flexibility and Autonomy: Enjoy the freedom to take ownership of your work and drive meaningful results
Leadership Development: Develop your skills through mentorship and career progression opportunities

Responsibilities:
Data Architecture & Modeling

Analyze business and technical requirements to design scalable, efficient data architectures
Build logical and physical data models using industry-standard tools such as Erwin (or equivalent)
Design high-quality Entity Relationship (ER) diagrams following best practices in normalization, naming conventions, metadata, and data governance
Reverse engineer existing databases and schemas into ERDs, ensuring accuracy, traceability, and clarity
Manage schema lifecycle and change control, including versioning, impact assessment, and controlled deployment across environments
Translate source system structures into consolidated, analytics-ready data models for data warehouses and marts

Data Engineering & ETL/ELT Development

Design and build end-to-end data pipelines using both low-code/no-code and code-based tools, including SSIS, Azure Data Factory (ADF), Alteryx, Power Automate, and related technologies
Develop and optimize data ingestion, transformation, and integration workflows across diverse data sources
Implement ETL/ELT best practices to ensure reliability, accuracy, scalability, and performance
Support the creation of data warehouses, data marts, and reusable data assets for analytics, reporting, and visualization
Troubleshoot pipeline, performance, and data quality issues with a hands-on, solution-focused approach

Database Platforms

Work with and design solutions across multiple database platforms, including:
SQL Server
Databricks
MySQL
PostgreSQL
(Additional cloud or on-premise data platforms are considered assets)

Client & Project Delivery

Facilitate requirement gathering sessions with clients to understand business needs and data-related challenges
Translate complex technical concepts into clear, actionable recommendations for both technical and non-technical audiences
Contribute to solution design, architecture documentation, project plans, and technical deliverables
Work collaboratively with cross-functional teams to ensure solution alignment with client objectives
Support delivery of high-quality consulting engagements with a focus on value, clarity, and outcomes

Qualifications:
Technical Qualifications

5-7 years of relevant experience in data engineering, data architecture, or combined roles
Strong, hands-on experience with data modeling tools (e.g., Erwin) and ERD best practices
Demonstrated capability to reverse-engineer, deploy, and manage schema changes across environments
Advanced experience with SQL and SQL scripting across multiple RDBMS platforms
Proven ability to design and build ETL/ELT pipelines using tools such as SSIS, ADF, Alteryx, Power Automate, or similar
Experience converting OLTP systems into OLAP data warehouses and data marts
Knowledge of BI/reporting tools, visualization platforms, and their data consumption patterns (asset)

Consulting & Professional Services Experience

Candidates with consulting experience will be given strong preference
Experience delivering technology or data projects in a client-facing consulting environment
Ability to manage stakeholder relationships, clarify complex requirements, and facilitate discussions between business and technical teams
Strong problem-solving skills with the ability to structure ambiguous challenges into actionable solution paths
Comfortable preparing and delivering presentations, architectural artifacts, and recommendations to clients and executive audiences
Experience supporting project scoping, estimation, and proposal development (asset)

Personal Attributes

Self-directed, with the ability to thrive in a fast-paced, dynamic environment
Strong verbal, written, and presentation communication skills
Results-driven, with the ability to meet aggressive timelines and manage competing priorities
Innovative, dynamic, and entrepreneurial in approach
Strong work ethic, energy, enthusiasm, and commitment to professional growth

Education

University degree in a related field

Interview recording & AI notetakers
During the interview process, we may use transcription or AI notetaking tools. To protect privacy, legal compliance, and interviewer/candidate experience, the use of these tools is not permitted without your prior consent. We will ask for your consent and if you wish to decline, handwritten notes are welcome.

Compensation: Salary Range is $110,000-$160,000 CAD

Salary ranges are designed to be competitive. Individual compensation is determined by skills, qualifications, and experience and is subject to negotiation and subject to the candidate meeting the specific requirements or the role. Exceptional candidates may be considered above the top of the range, and pay can increase quickly for those who make a big impact in the role.

A Taste of Some of the Great Benefits at Optimus
Financial

Annual Bonus
Retirement savings through our Group RRSP program
Company equity for Managers and above
Maternity and Parental Leave with top up compensation

Flexibility

Work in a Hybrid model (when client projects permit)
12 Optimus Days paid

Health

Top-tier health benefits
Life & disability insurance
Health Spending Dollars

So, what’s next?
At Optimus SBR, we’re all about creating a space where everyone belongs and can thrive. We’re committed to diversity and inclusion, welcoming people from all backgrounds. We’re proud to back missions like the BlackNorth Initiative to drive real change. Let’s build something meaningful together, where your voice matters and fearless ideas can shine.

Accommodation
We are committed to ensuring that our recruitment process is inclusive and accessible to everyone. If you require any accommodations to remove barriers and fully participate in the interview process - such as accessible meeting rooms or captioning for virtual interviews - please let us know. Your needs will be met with respect and confidentiality. We look forward to connecting with you!

Vacancy Status: Existing vacancy within our organization.

Submit your application with your resume today! While we appreciate all applications, only selected candidates will be contacted for interviews.

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.

About employer

More about this job

Responsibilities

Design and build scalable data architectures and end-to-end data pipelines using both low-code and code-based tools. Collaborate with clients to translate business requirements into technical data models and high-quality consulting deliverables.

Requirements

Requires 5-7 years of experience in data engineering or architecture with strong proficiency in SQL and data modeling tools like Erwin. Preference is given to candidates with a university degree and a background in client-facing professional services consulting.

Skills

Data Architecture
Data Modeling
ETL/ELT Development
SQL
Azure Data Factory
SSIS
Alteryx
Power Automate
Erwin
Databricks
SQL Server
PostgreSQL
MySQL
Requirement Gathering
Solution Design

Benefits

Annual Bonus
Group RRSP
Company Equity
Maternity And Parental Leave Top Up
Hybrid Work Model
12 Optimus Days Paid
Health Benefits
Life Insurance
Disability Insurance
Health Spending Dollars

Visa sponsorship

Not detected in the job text

Keywords

Data Engineering
Solutions Architect
Data Modeling
ERD
Normalization
Data Governance
Azure Data Factory
SSIS
Alteryx
Power Automate
SQL Server
Databricks
MySQL
PostgreSQL
OLTP
OLAP
Data Warehouse
Data Marts
Management Consulting
Stakeholder Management
Schema Lifecycle
Metadata
Business Intelligence
Data Ingestion
Data Integration
Technical Documentation
Project Scoping
Professional Services
Data Pipelines
RDBMS

Report this job

Work requirements

Jobs in Canada