Optimus SBR

Data Engineering Solutions Architect

Optimus SBR

full-time

Posted on:

Location Type: Hybrid

Location: Toronto • 🇨🇦 Canada

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

AzureETLMySQLPostgresRDBMSSQLSSIS

About the role

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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
data architecturedata modelingETLELTSQLdata ingestiondata transformationdata integrationdata governancedata warehousing
Soft skills
problem-solvingstakeholder managementcommunicationpresentation skillsconsultingproject scopingself-directedresults-driveninnovativedynamic