Data Engineering Solutions Architect - Technology Services Group

The Position

Continued growth has created an exciting opportunity for a Data Engineering Solutions Architect 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.

Optimus S  is a leading management consulting firm and an award-winning workplace. Recognized by Great Place to Work® as one of the Best Workplaces™ in Professional Services 2024, and by Waterstone Human Capital® as one of Canada’s Most Admired Corporate Cultures™, we help organizations get done what isn’t. Our team of committed consultants swiftly takes action to deliver innovative and impactful results.

We are the largest independently owned Canadian management‑consulting firm – a place where people and culture come first. Our market positioning is based on attracting the best people who are insatiably curious, entrepreneurial thinkers, hard‑working, and bold.

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 built on culture, we value our people and their growth. Each of us embodies the entrepreneurial spirit and has something unique to contribute. From employee‑championed committees to celebratory events and learning paths, we cultivate a positive and engaging work environment.

• Growth Opportunities:
  Build your career through challenging, impactful projects and continuous learning
• Diverse Workplace:
  Collaborate with professionals from unique backgrounds, fostering innovation
• Flexibility & 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

• 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

• 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

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

• 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,…