Junior Data Analyst jobs in Canada

Continued growth has created an exciting opportunity for a Technical Data Business Analyst to join our Technology Services Group.

In this role, you will work at the intersection of business analysis, data analytics, and BI solution delivery. You will collaborate with high-performing professionals across diverse industries, supporting clients as they modernize their data capabilities, enhance decision-making, and implement effective technology solutions.

The ideal candidate combines strong business analysis expertise with technical proficiency in SQL, Power BI, Tableau, and data interpretation. You are curious, adaptable, and motivated to translate complex business problems into structured, data-driven insights and requirements.

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

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.

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

• Lead and support end-to-end business analysis activities for data, analytics, and technology projects.
• Facilitate requirements workshops and interviews to gather business needs, data requirements, user stories, and functional specifications.
• Develop clear and complete business analysis documentation, including:
  • Business Requirement Documents (BRDs)
  • Functional Requirements Documents (FRDs)
  • User stories and acceptance criteria
  • Process maps, swimlane diagrams, and data flow diagrams
  • System-to-system data mapping
  • Requirements traceability matrices
• Participate in project planning, status reporting, and preparation of client deliverables, presentations, and recommendations.
• Support identification of project risks and issues and contribute to the development of mitigation plans.
• Communicate complex data and technical concepts clearly to both technical and non-technical stakeholders.

• Conduct advanced data analysis using SQL to explore datasets, validate requirements, troubleshoot issues, and support solution design.
• Write and optimize queries to join, filter, cleanse, aggregate, and quality-check data from multiple sources.
• Perform data profiling to understand data quality, structure, lineage, and constraints.
• Interpret data models, schemas, and metadata to ensure alignment between business requirements and technical capabilities.
• Support data integration, data warehousing, and analytics initiatives by translating business needs into precise data specifications.

• Design and develop dashboards, reports, and visualizations using Power BI and Tableau, applying best practices in UI/UX, data storytelling, and analytics.
• Identify and define KPIs and metrics in collaboration with stakeholders.
• Translate analytical findings into meaningful insights that support business decision‑making.
• Produce strong documentation for BI assets, including data sources, calculations, measures, logic, and business rules.

• Build advanced Tableau features, including LOD Expressions, Table Calculations, and calculated fields.
• Demonstrate familiarity with Tableau Server/Online, Tableau Prep, publishing workflows, and administration basics.

• Develop sophisticated Power BI models using DAX, measures, and calculated columns.
• Analyze and optimize existing datasets, reports, and published scripts.
• Understand architectural implications across Power BI Pro, Premium, and Embedded environments.

• Minimum 3 years of experience as a Business Analyst or Business Systems Analyst.
• Minimum 3 years of hands‑on experience developing dashboards and analytics using Power BI and Tableau.
• Strong SQL skills with experience performing data profiling, validation, and technical analysis.
• University degree in a related field or equivalent professional experience.

• Excellent analytical, problem‑solving, and critical‑thinking abilities.
• Superior consulting and client relationship management skills.
• Strong communication, facilitation, and interpersonal skills, with the ability to bridge technical and non‑technical audiences.
• High‑quality writing and documentation skills; ability to produce clear, structured deliverables.
• Ability to thrive in fast‑paced environments and meet aggressive timelines.
• Entrepreneurial, adaptable, and eager to learn.
• Strong work ethic, enthusiasm, and commitment to professional growth.

• Experience gathering data‑oriented requirements and collaborating with data engineering or analytics teams.
• Familiarity with data modeling, data warehousing concepts, and data integration workflows.
• Exposure to ETL/ELT concepts or tools (e.g., Alteryx, ADF, SSIS) is an asset.
• Basic experience with Python for data manipulation, scripting, or automation.
• Experience working with Agile, waterfall, or hybrid project delivery methodologies.
• Prior technology advisory or management consulting experience.
• Certifications such as CBAP, PMP, or BI/analytics platform certifications (e.g., Tableau, Power BI).

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.

We 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!

Submit your application with your resume today! While we appreciate all applications, only selected candidates will be contacted for interviews.