Manager, Data & Business Intelligence Architecture

Optimus SBR; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A management consulting firm in Toronto is seeking an experienced Manager for Data & Business Intelligence Architecture. In this role, you will lead impactful data-driven solutions, manage diverse teams, and drive strategy for modern data ecosystems. Ideal candidates have over 7 years of experience in data strategy and a strong track record in delivering BI solutions. The firm values collaboration, innovation, and cultural fit, offering growth and leadership development opportunities.

Benefits

Growth Opportunities

Diverse Workplace

Flexibility and Autonomy

Leadership Development

Qualifications

• 7+ years of progressive experience in data strategy, BI, and analytics domains.
• Proven track record delivering enterprise data and BI solutions, including ETL/ELT pipelines.
• Strong knowledge of SQL and experience with both cloud and on-premises data ecosystems.

Responsibilities

• Lead complex data architecture, BI, and integration projects.
• Engage with client stakeholders to understand and shape enterprise data needs.
• Develop data integration and visualization strategies aligned with business goals.

Skills

Business Intelligence

SQL

Power BI

Data Visualization

Tableau

Education

Bachelor of Computer Science

Post-graduate degree or additional professional designation

Tools

ETL/ELT pipelines

Cognos

QlikView

Data Warehouse

SSIS

Job description

About the Role

Join a dynamic and engaging team that thrives on collaboration, innovation, and growth. The Manager Data & Business Intelligence Architecture role offers an exciting opportunity to lead and deliver impactful data-driven solutions across diverse industries. You will work with clients to architect modern data ecosystems, lead multi-disciplinary teams, and shape data strategies that drive meaningful business outcomes. If you're passionate about solving complex challenges and mentoring others while working on the cutting edge of technology and business intelligence, this role is for you.

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 Canada's Most Admired Corporate Cultures, we help organizations achieve what isn't possible alone.

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, hard-working, and bold. We believe the world needs more of that, and we are doing our part.

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

Responsibilities

1. Lead complex data architecture, BI, and integration projects from strategic planning through execution.
2. Engage with both technical and non-technical client stakeholders to understand and shape enterprise data needs and flows.
3. Lead discovery efforts to understand data usage and consumption, mapping systems and platforms across the enterprise.
4. Develop data integration and visualization strategies aligned with business goals.
5. Provide strategic recommendations for managing structured and unstructured data using modern tools and best practices.
6. Guide project teams and junior consultants in delivering quality standards.
7. Translate business objectives into scalable technical solutions that balance governance, performance, and usability.
8. Build trusted advisor relationships by delivering insights through compelling presentations and reports.
9. Support business development through proposal creation, scoping, and client pitches.
10. Provide day-to-day direction, coaching, and mentoring to project teams, and support employees' career development through the Career Development Program (CDP).
11. Contribute to the life and culture of Optimus SBR.

Required Qualifications

• 7+ years of progressive experience in data strategy, BI, and analytics domains.
• Proven track record delivering enterprise data and BI solutions, including ETL/ELT pipelines, data warehousing, and data modeling.
• Strong knowledge of SQL and experience with both cloud and on-premises data ecosystems.
• Proficiency in BI tools such as Power BI, Tableau, and Erwin Data Modeler, with an understanding of data visualization best practices.
• Experience across multiple data domains, including engineering, governance, architecture, and analytics.
• Previous management consulting or client-facing experience is strongly preferred.
• Strong interpersonal, written, and presentation communication skills.
• Ability to synthesize complex technical content for executive and non-technical audiences.
• Self-motivated, agile, entrepreneurial, with strong initiative.
• Project management experience or familiarity with Agile/Waterfall methodologies is an asset.

Required Education

• Related university degree (e.g., Bachelor of Computer Science, B. Comp).
• Post-graduate degree (e.g., MBA), PMP, or additional professional designation.

What's in It for You

Growth Opportunities: Build your career through challenging, impactful projects and continuous learning.

Diverse Workplace: Collaborate with professionals from diverse backgrounds fostering innovation.

Flexibility and Autonomy: Take ownership of your work and drive meaningful results.

Leadership Development: Develop skills through mentorship and career progression opportunities.

Next Steps

At Optimus SBR, we are committed to creating an inclusive environment where everyone can thrive. We value diversity and inclusion and support initiatives like the BlackNorth Initiative to foster real change. Let's build something meaningful together, where your voice matters and fearless ideas can shine.

Accommodation

We are dedicated to ensuring our recruitment process is inclusive and accessible. If you require accommodations to participate fully, such as accessible meeting rooms or captioning, please let us know. Your needs will be met with respect and confidentiality. We look forward to connecting with you!

Experience: Manager

Key Skills

Business Intelligence, Cognos, SQL, Power BI, QlikView, Data Visualization, SSRS, Tableau, SSIS, Data Modeling, Data Warehouse, Data Analysis

Employment Type: Full-Time

Vacancy: 1