Technical Data Business Analyst - Technology Services Group

The Position

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 S  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…