---
title: 'Data Engineering Solutions Architect - Technology Services Group at Optimus SBR'
canonical: 'https://feeny.ai/job/data-engineering-solutions-architect-technology-services-group-optimus-sbr-xfaefzn1pn30'
type: 'job'
last_seen: '2026-09-07'
---

# Data Engineering Solutions Architect - Technology Services Group at Optimus SBR

- **Company:** Optimus SBR
- **Location:** Toronto, Canada
- **Employment:** full-time
- **Work type:** hybrid
- **Posted:** 2026-07-15
- **Last confirmed live:** 2026-09-07
- **Apply:** https://jobs.lever.co/optimussbr/61d6556f-d5ff-4d52-9f81-28dbf32bd881

## 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

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.

## About Optimus SBR

## Company Overview
- **One-liner**: Optimus SBR is an independent Canadian management consulting firm that helps organizations solve complex operational, strategic, and technological challenges.
- **Entity Type**: Private (independently owned, no series funding stage; has raised $115.5M in total funding per LinkedIn)
- **Headquarters**: Toronto, Ontario, Canada
- **Founded**: 2010
- **Founders**: Kevin Gauci (CEO) and co-founders from the merger of Optimus Consulting Group and Kemerer Group Inc.

## Core Business
- **Primary industry**: Management consulting, with specializations in financial services, government & public sector, healthcare, energy, and diversified industries.
- **Target customers**: B2B, enterprise, mid-market, and government clients.
- **Mission or purpose**: To build a consulting organization where employees come first, culture is key, and clients love to work with us — executing “what’s next” for leading firms.

## Products & Services
- **Strategy Consulting**: Advisory services to help clients make confident decisions and plan for growth.
- **Process Improvement & Risk Management**: Operational efficiency, compliance, and risk mitigation.
- **Program & Project Management**: Full lifecycle management integrating top methodologies.
- **Data & Analytics**: Customized solutions to derive value from data and drive operational excellence.
- **Technology & Digital Transformation**: Bridging business and technology gaps, including AI enablement.
- **Cyber Security**: Adaptive security solutions with risk management and incident response.
- **Change Management & Learning Development**: Experiential learning, virtual training, and organizational change support.

## Market Standing
- **Valuation/Market Cap**: Not publicly available (private company)
- **Key Metric**: Total Funding – $115.5M (LinkedIn estimate); Annual Revenue – not publicly disclosed (LinkedIn estimates $9M)
- **Notable Investors/Partners**: Not disclosed; funded through acquisitions (8+ acquisitions to date, including Unilytics, n-gen People Performance, KeyWillow Consulting, PMC, SEG Management Consultants)
- **Growth Signals**: Headcount grew nearly tenfold in a decade; consistently named a fastest-growing company in North America; recognized as a top employer; expanded offices twice; added AI, data analytics, and cyber security practice areas.

## Competitive Advantages
- **Largest independent Canadian management consulting firm** – offers a broad, integrated suite of services while remaining employee-owned and client-focused.
- **Employee-first culture** – regularly rated a best place to work; seven employee-created committees; strong emphasis on work-life balance and career development.
- **Deep industry expertise** – dedicated practices for financial services, government, healthcare, and energy, allowing tailored solutions.
- **Track record of acquisitions** – strategically built capabilities in data, learning, and public sector, creating a one-stop-shop for clients.

## Strategic Focus
- **Current priorities**: Continue expanding through targeted acquisitions; deepen AI and data analytics offerings; strengthen cybersecurity and digital transformation services; grow presence in the United States while maintaining Canadian leadership.
- **Direction for growth**: Scale the firm’s cross-industry expertise and invest in technology-enabled consulting to meet evolving client needs.

## Why Work Here
- **Culture highlights**: Employee-led committees, regular celebratory and professional development events, strong community feel. Consistently rated a top employer in North America.
- **Remote/hybrid/office policy**: Not explicitly stated, but headquarters at 33 Yonge Street, Toronto, suggests a hybrid office model; flexible health benefits and work-life balance are emphasized.
- **Notable perks**: Competitive compensation, annual performance bonuses, flexible health benefits, career development program with defined learning paths, and a supportive atmosphere for personal growth.
- **Engineering/consulting culture**: Focus on continuous learning, mentorship, and challenging projects across multiple industries. Open to hiring from industry or other consulting firms.

## Sources
1. [optimussbr.com](https://www.optimussbr.com/about/) – About page, history, team, values
2. [optimussbr.com](https://www.optimussbr.com/careers/) – Careers page, culture, benefits, open positions
3. [optimussbr.com](https://www.optimussbr.com/our-culture/) – Culture details, committees, learning paths
4. [linkedin.com](https://ca.linkedin.com/company/optimus-sbr) – LinkedIn profile, headcount, revenue estimate, funding, reviews

## Other roles at Optimus SBR

- [Manager, Risk - Technology Services Group](https://feeny.ai/job/manager-risk-technology-services-group-optimus-sbr-toronto-nr4tgy4v8ncr) — Toronto, Canada
- [Recruiter](https://feeny.ai/job/recruiter-optimus-sbr-toronto-0x3vch6j0brc) — Toronto, Canada
- [Senior Associate, Risk - Technology Services Group](https://feeny.ai/job/senior-associate-risk-technology-services-group-optimus-sbr-toronto-he9ctwrd5629) — Toronto, Canada
- [Senior Associate - Technology Services Group](https://feeny.ai/job/senior-associate-technology-services-group-optimus-sbr-toronto-bf5gtanc2sfp) — Toronto, Canada
- [Associate - Technology Services Group](https://feeny.ai/job/associate-technology-services-group-optimus-sbr-toronto-jcedr7hwj4aj) — Toronto, Canada
- [Senior Associate - Financial Services Group](https://feeny.ai/job/senior-associate-financial-services-group-optimus-sbr-toronto-my0zanvxbtwd) — Toronto, Canada
- [Associate - Financial Services Group](https://feeny.ai/job/associate-financial-services-group-optimus-sbr-toronto-wghbzqd64bp9) — Toronto, Canada
- [Analyst/Senior Analyst, Admin and Corporate Development](https://feeny.ai/job/analyst-senior-analyst-admin-and-corporate-development-optimus-sbr-toronto-ev5j50ycd951) — Toronto, Canada
- [Principal, Diversified Industries Group](https://feeny.ai/job/principal-diversified-industries-group-optimus-sbr-toronto-7df9sa3ekzs3) — Toronto, Canada
- [Manager/Senior Manager - Financial Services Group](https://feeny.ai/job/manager-senior-manager-financial-services-group-optimus-sbr-toronto-hj31z3cr23r4) — Toronto, Canada