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 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 rapid-paced environments. You’re comfortable engaging directly with clients, wearing multiple hats, and navigating shifting priorities while delivering high-quality technical solutions.About UsOptimus 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 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.Culture is Everything. Period.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.What’s in It for You?Growth Opportunities: Build your career through challenging, impactful projects and continuous learningDiverse Workplace: Collaborate with professionals from unique backgrounds, fostering innovationFlexibility & Autonomy: Enjoy the freedom to take ownership of your work and drive meaningful resultsLeadership Development: Develop your skills through mentorship and career‑progression opportunitiesResponsibilitiesData Architecture & ModelingAnalyze business and technical requirements to design scalable, efficient data architecturesBuild 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 governanceReverse engineer existing databases and schemas into ERDs,



ensuring accuracy, traceability, and clarityManage schema lifecycle and change control, including versioning, impact assessment, and controlled deployment across environmentsTranslate source system structures into consolidated, analytics‑ready data models for data warehouses and martsData Engineering & ETL/ELT DevelopmentDesign 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 technologiesDevelop and optimize data ingestion, transformation, and integration workflows across diverse data sourcesImplement ETL/ELT best practices to ensure reliability, accuracy, scalability, and performanceSupport the creation of data warehouses, data marts, and reusable data assets for analytics, reporting, and visualizationTroubleshoot pipeline, performance, and data quality issues with a hands‑on, solution-focused approachDatabase PlatformsWork with and design solutions across multiple database platforms, including:SQL ServerDatabricksMySQLPostgreSQL(Additional cloud or on-premise data platforms are considered assets)Client & Project DeliveryFacilitate requirement gathering sessions with clients to understand business needs and data-related challengesTranslate complex technical concepts into clear, actionable recommendations for both technical and non-technical audiencesContribute to solution design, architecture documentation, project plans, and technical deliverablesWork collaboratively with cross-functional teams to ensure solution alignment with client objectivesSupport delivery of high-quality consulting engagements with a focus on value, clarity, and outcomesQualificationsTechnical Qualifications5-7 years of relevant experience in data engineering, data architecture, or combined rolesStrong, hands-on experience with data modeling tools (e.G., Erwin) and ERD best practicesDemonstrated capability to reverse-engineer, deploy, and manage schema changes across environmentsAdvanced experience with SQL and SQL scripting across multiple RDBMS platformsProven ability to design and build ETL/ELT pipelines using tools such as SSIS, ADF, Alteryx, Power Automate, or similarExperience converting OLTP systems into OLAP data warehouses and data martsKnowledge of BI/reporting tools, visualization platforms,



and their data consumption patterns (asset)Consulting & Professional Services ExperienceCandidates with consulting experience will be given strong preferenceExperience delivering technology or data projects in a client-facing consulting environmentAbility to manage stakeholder relationships, clarify complex requirements, and facilitate discussions between business and technical teamsStrong problem-solving skills with the ability to structure ambiguous challenges into actionable solution pathsComfortable preparing and delivering presentations, architectural artifacts, and recommendations to clients and executive audiencesExperience supporting project scoping, estimation, and proposal development (asset)Personal AttributesSelf-directed, with the ability to thrive in a fast-paced, dynamic environmentStrong verbal, written, and presentation communication skillsResults-driven, with the ability to meet aggressive timelines and manage competing prioritiesInnovative, dynamic, and entrepreneurial in approachStrong work ethic, energy, enthusiasm, and commitment to professional growthEducationUniversity degree in a related fieldCompensationSalary Range: $110,000-$160,000 annually (subject to negotiation and subject to the candidate meeting the specific skills, experience, education, and qualification requirements)At Optimus SBR, we’re all about creating a space where everyone belongs and can thrive. We’re committed to diversity and inclusion, welcoming people from all backgrounds. We’re proud to back missions like the BlackNorth Initiative to drive real change. Let’s build something meaningful together, where your voice matters and fearless ideas can shine.AccommodationWe 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 process—such as accessible meeting rooms or captioning for virtual interviews—please let us know. Your needs will be met with respect and confidentiality. We look forward to connecting with you!Vacancy Status: Existing vacancy within our organization.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.#J-18808-Ljbffr

📌 Data Engineering Solutions Architect - Technology Services Group - $110,000 - $160,000 A Year (Toronto)
🏢 Optimus SBR
📍 Toronto