Technical Data Business Analyst - Technology Services Group

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 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 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 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 opportunitiesResponsibilitiesBusiness 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:Business Requirement Documents (BRDs)Functional Requirements Documents (FRDs)User stories and acceptance criteriaProcess maps, swimlane diagrams, and data flow diagramsSystem-to-system data mappingRequirements 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 stakeholdersTechnical 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 specificationsPower 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 rulesTableau-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 basicsPower BI–Specific 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 environmentsQualifications 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 experienceRequired 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 growthDesirable 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, what’s next?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!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.