Data Engineering Solutions Architect - Technology Services Group

Optimus SBR • Toronto, ON

9d • CA$110,000 - CA$160,000 • Hybrid

About The Position

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.

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.
• 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.
• 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.
• 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.
• University degree in a related field.

Nice To Haves

• Knowledge of BI/reporting tools, visualization platforms, and their data consumption patterns (asset).
• Experience supporting project scoping, estimation, and proposal development (asset).
• Additional cloud or on-premise data platforms are considered assets.

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

Benefits

• Annual Bonus
• Retirement savings through our Group RRSP program
• Company equity for Managers and above
• Maternity and Parental Leave with top up compensation
• Work in a Hybrid model (when client projects permit)
• 12 Optimus Days paid
• Top-tier health benefits
• Life & disability insurance
• Health Spending Dollars

What This Job Offers

• Job Type: Full-time
• Career Level: Manager