Data Engineering Solutions Architect Technology Services Group

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: 13 hours ago

Vacancies: 1 Vacancy

Job Summary

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. Youre 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 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 Canadas Most Admired Corporate Cultures we help organizations get done what isnt.

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.

Culture is Everything. Period.

Thats why weve 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.

Whats in It for You

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.

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.

So whats next

At Optimus SBR were all about creating a space where everyone belongs and can thrive. Were committed to diversity and inclusion welcoming people from all backgrounds. Were proud to back missions like the BlackNorth Initiative to drive real change. Lets 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 processsuch as accessible meeting rooms or captioning for virtual interviewsplease let us know. Your needs will be met with respect and confidentiality. We look forward to connecting with you!

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

The PositionContinued 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 dis...