Optimussbr

Optimussbr

Data Engineering Solutions Architect - Technology Services Group

Toronto

Sponsorship not specified$110k-$160kDetected 6 days ago
SwiftSQLPostgreSQLMySQLDatabricksAzureData EngineeringNegotiationRecruitingLeadershipCommunicationProblem SolvingMentoringPublic SpeakingAdaptability

About the role

  • Continued growth has created an exciting opportunity for a Data Engineering Solutions Architect (Manager/Senior Manager Level) to join our Technology Services Group.
  • You're comfortable engaging directly with clients, wearing multiple hats, and navigating shifting priorities while delivering high-quality technical solutions.

Responsibilities

  • 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.
  • Manage schema lifecycle and change control, including versioning, impact assessment, and controlled deployment across environments.
  • 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.
  • Contribute to solution design, architecture documentation, project plans, and technical deliverables.
  • Support delivery of high-quality consulting engagements with a focus on value, clarity, and outcomes.

Requirements

  • 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.
  • Advanced experience with SQL and SQL scripting across multiple RDBMS platforms.
  • Experience converting OLTP systems into OLAP data warehouses and data marts.
  • Knowledge of BI/reporting tools, visualization platforms, and their data consumption patterns (asset).
  • Experience delivering technology or data projects in a client-facing consulting environment.
  • Strong problem-solving skills with the ability to structure ambiguous challenges into actionable solution paths.
  • You are ambitious, adaptable, and energized by solving complex problems in fast-paced environments.
  • Technical Qualifications
  • Demonstrated capability to reverse-engineer, deploy, and manage schema changes across environments.
  • Proven ability to design and build ETL/ELT pipelines using tools such as SSIS, ADF, Alteryx, Power Automate, or similar.
  • Consulting & Professional Services Experience
  • Candidates with consulting experience will be given strong preference.
  • Ability to manage stakeholder relationships, clarify complex requirements, and facilitate discussions between business and technical teams.
  • Comfortable preparing and delivering presentations, architectural artifacts, and recommendations to clients and executive audiences.

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.
  • Maternity and Parental Leave with top up compensation

Benefits

  • Retirement savings through our Group RRSP program
  • Company equity for Managers and above
  • Maternity and Parental Leave with top up compensation
  • Top-tier health benefits
  • 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.
  • A Taste of Some of the Great Benefits at Optimus
  • Life & disability insurance
  • Health Spending Dollars

Company info

  • 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
  • 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.
  • 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.
  • 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.

Equal opportunity

  • We're committed to diversity and inclusion, welcoming people from all backgrounds.
  • Accommodation We are committed to ensuring that our recruitment process is inclusive and accessible to everyone.
Apply directly at Optimussbr →Create a free account for alerts like thisView Optimussbr immigration profile

This listing is sourced directly from Optimussbr's careers page and normalized into a canonical job model.