Hybrid Data Engineering Solutions Architect

at Optimus SBR

• Job title: Data Engineering Solutions Architect
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: Azure, ETL, MySQL, Postgres, RDBMS, SQL, SSIS
• Location requirements: Hybrid, Toronto, Canada

About the role

• Data Engineering Solutions Architect at Optimus SBR designing modern data solutions and collaborating with a high-performing team to transform data usage.

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.

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.
• Knowledge of BI/reporting tools, visualization platforms, and their data consumption patterns (asset).
• 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).
• 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.

Benefits

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