Find work in Canada.

330,238 jobs across our Canadian network. How we count

Jobs in Canada

Email me new jobs Save this search

Added 4 months ago
Lead Engineer, Bridges (relocation provided)
WSP in Canada
Winnipeg, Manitoba
Full-time
Lead complex and standard bridge projects from concept through detailed design, ensuring high‑quality and technically sound outcomes.
Added 4 months ago
Geotechnical Lead
AECOM
Saskatoon, Saskatchewan
$100,000 to $135,000 CAD / year
Full-time
…have extensive experience in the geotechnical analyses and design of foundations, dams, retaining structures, embankments, excavation support systems, trenchless construction including…
Added 2 months ago
Data Engineering Solutions Architect - Technology Services Group
Optimus SBR
Toronto, ON
Full-time
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…
Added 2 months ago
Ingénieur(e) en ponts et ouvrages d'art
AtkinsRéalis
Montreal, QC
Full-time
Carrying out structural design for bridges and civil engineering structures.
Added 2 months ago
Lead Structural Engineer & Team Leader
GHD Group Pty Ltd
Calgary, AB
Full-time
Due to the continued growth GHD is looking for a Structural Lead Engineer & Team Leader to join our growing Canadian Operations. This position will support our Design Delivery Organization…
Added 2 months ago
Field Engineer - Tunnel & Underground
EBC Inc.
Vancouver, British Columbia
At EBC, we think outside the box to design and deliver major infrastructure projects that transform the Canadian landscape. Driven by excellence and innovation, we leverage our expertise to…
Added 1 month ago
Manufacturing Engineer II
Garland Commercial Ranges Ltd
Mississauga, Ontario
$70,000 to $80,000 CAD / year
Full-time
…and in-house manufactured parts. Performs analyses to develop design options or recommendations for structures, systems and…
Added 10 days ago
Mechanical Engineer, Senior - Nuclear, Bowmanville EOI
Hatch
Mississauga, ON
Are you looking to take the next step in your career? Hatch is currently seeking a highly motivated Senior Mechanical Engineer- Nuclear to join our team in Bowmanville.
Added 2 months ago
Transmission Line Engineer 2 - Grid
Sargent & Lundy
Toronto, ON · North York, ON
Full-time
Perform structural analysis and design of pole, lattice, framed, and guyed structures.
Added 12 days ago
AI Engineer - Canada
Pulsora
Remote, Canada
$60,000 to $70,000 CAD / year
Full-time · Remote
LLM Integration & Development: Design, develop, and deploy production-grade applications leveraging various LLMs, context optimization, etc.
Added 12 days ago
Technical Analyst
SaskTel
Regina, SK
Full-time
Database Administration - Plans, designs, automates, implements, and supports the physical structures for databases.
Added 12 days ago
Project Manager, Bridges
Associated Engineering
Calgary, AB
Full-time
You will become an integral part of the Transportation Structures Group and will be responsible for undertaking project management of standard and/or major bridge projects for a variety of…
Added 12 days ago
Bridge Engineer-in-Training
Associated Engineering
Edmonton, AB
Full-time
Associated Engineering, a proudly Canadian, Employee-owned Company is seeking an experienced and dedicated Bridge Engineer-in-Training to join our team in our Edmonton office. In this role…
Added 11 days ago
Junior Structural Engineer
Haag, a Salas O'Brien Company
Woodbridge, ON
Full-time
We are seeking a Junior Structural Engineer to join our growing team in Woodbridge, Ontario. Our firm specializes in the design of complex heavy industrial facilities, including projects…
Added 12 days ago
Facility Preservation Engineer – Civil
Global Cellulose Fibers
Grande Prairie, AB
Analysis, design, fabrication, installation and repair of concrete, steel, aluminum, wooden structures
Added 12 days ago
Co-op/Intern Software Engineer, Data Modeling & Integration
Kinaxis Inc.
Ottawa, ON
Internship
Knowledge/experience in object-oriented design, data structures, and algorithms.
Added 11 days ago
Forward Deployed Solution Engineer – Applied AI FDE
ServiceNow
Montreal, QC
Full-time
It all started when engineer Fred Luddy wrote code that automated a tedious task for his coworker, Phyllis. She cried tears of joy. That moment inspired Fred to build a company that could…
Added 4 months ago
Intermediate Civil Engineer
Mallot Creek
Elora, Ontario
$95,000 to $115,000 CAD / year
Full-time
The Intermediate Civil Engineer is part of a multi-disciplinary team responsible for management and delivery of a variety of construction projects. As an experienced designer, specifically…
Added 4 months ago
Intermediate to Senior Marine Structural Engineer – Burnaby
Ausenco
Burnaby, British Columbia
Full-time
Experience in the design and construction of marine structures in the arctic would be an asset.
Added 2 months ago
Software Engineer
Ribbon Communications
Ottawa, Ontario
Full-time
…such as RAII, golang concurrency models, channels, lock-free structures. Strong knowledge of domain-driven design(DDD)…
Added 2 months ago
Geotechnical Engineer (Rock Engineering) - Intermediate/Senior
Stantec
Burnaby, BC
Full-time
…designing and managing the construction of complex geotechnical structures, our team does rock-solid…
Added 2 months ago
Senior Geotechnical Engineer (26030)
GEMTEC Consulting Engineers and Scientists Limited.
Hanwell, New Brunswick
Full-time
Complete geotechnical design for shallow and deep foundations, retaining structures, embankment dams, roadway embankments, railways, excavation support systems, tunnels, trenchless…
Added 2 months ago
Manufacturing Engineer
Ultra Maritime
Dartmouth, Nova Scotia
Full-time
The Manufacturing Engineer works with Design Engineering, Quality Assurance and Production Support to design, monitor and optimize the manufacturing processes for existing and new product…
Added 2 months ago
Chief Mine Engineer
Gowest Gold Ltd
Timmins, Ontario
Full-time
…properties are strategically positions along key geological structures, including the underexplored Pipestone Fault, associated with the gold-rich Porcupine-Destor Fault system, which has…
Added 2 months ago
Lead Business Solutions Engineer
Zymeworks Inc.
Vancouver, British Columbia
$105,000 to $161,000 CAD / year
As the Lead Business Solutions Engineer, you are a hands-on technical lead for all enterprise systems and integrations that serve General & Administrative functions (such as Finance, HR and…

Optimus SBR

Data Engineering Solutions Architect - Technology Services Group

Toronto, ON, Canada

Pay: Compensation: Salary Range is $110,000-$160,000 CAD
Job type: Full-time
Posting language: English
Posted: Jul 15, 2026

Apply About employer

Applications open in a new tab.

Original job description

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:

o SQL Server

o Databricks

o MySQL

o PostgreSQL

o (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

\n\n

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.

Apply 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. A university degree is required, and prior experience in a client-facing consulting environment is strongly preferred.

Skills

Data Architecture
Data Modeling
ETL/ELT Development
SQL Scripting
Azure Data Factory
SSIS
Alteryx
Power Automate
Erwin
Databricks
Stakeholder Management
Client Delivery
Requirement Gathering
Schema Lifecycle Management
Data Governance
OLAP Design

Benefits

Annual Bonus
Group RRSP Program
Company Equity
Maternity And Parental Leave Top Up
Health Benefits
Life Insurance
Disability Insurance
Health Spending Dollars

Visa sponsorship

Not detected in the job text

Keywords

Data Engineering
Solutions Architect
ERD
Normalization
Metadata
SQL Server
MySQL
PostgreSQL
Data Warehouse
Data Marts
OLTP
OLAP
BI Tools
Consulting
Project Scoping
Schema Change Control
Azure
Data Pipelines
Technical Documentation
Management Consulting

Report this job