Technical Data Business Analyst Technology Services Group

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: 5 hours ago

Vacancies: 1 Vacancy

Job Summary

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.

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 Canadas Most Admired Corporate Cultures we help organizations get done what isnt.

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.

Thats why weve 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.

Whats in It for You

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.

Responsibilities

Business Analysis & Consulting

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:

o Business Requirement Documents (BRDs)

o Functional Requirements Documents (FRDs)

o User stories and acceptance criteria

o Process maps swimlane diagrams and data flow diagrams

o System-to-system data mapping

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

Technical Analysis & SQL

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.

Power BI & Tableau Development

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.

Tableau-Specific Expertise

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.

Power BISpecific Expertise

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.

Qualifications

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.

Required Skills

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.

Desirable Skills

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

So whats next

At Optimus SBR were all about creating a space where everyone belongs and can thrive. Were committed to diversity and inclusion welcoming people from all backgrounds. Were proud to back missions like the BlackNorth Initiative to drive real change. Lets build something meaningful together where your voice matters and fearless ideas can shine.

Accommodation

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 processsuch as accessible meeting rooms or captioning for virtual interviewsplease 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.

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.

Required Experience:

The PositionContinued 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 professi...