Business Analyst

Dollarama; Mount Royal; On-site; CAD 70,000 - 90,000; Full time

Job summary

Dollarama in Montreal seeks a Business Data Analyst within the Project Management Office to bridge business needs and IT, focusing on analytical products and system implementations. You will gather requirements from Finance, Operations, Merchandising, and Logistics and design Power BI solutions.

You will contribute to BI governance, data quality, and reporting; build Power BI data models, train users, and support cross-functional projects through the full lifecycle from design to deployment.

Qualifications

• Minimum of 3 years of BI experience.
• Minimum of 2 years of advanced Power BI development.
• Significant experience as a Business Analyst.
• Strong proficiency in English and French communication.

Responsibilities

• Lead workshops to capture analytics or business needs.
• Translate requirements into functional specs for IT.
• Create Power BI reports and data models.
• Ensure data governance, quality, and security.
• Develop BI templates and standardized reports.
• Support dashboards and user training.
• Assist PMO on system implementation projects.

Skills

Power BI development

Stakeholder communication

Analytical thinking

Business processes understanding

Tools

Power BI

SAP

WMS systems

Visio

Job description

Job Summary

Working within the Project Management Office in a dynamic environment, the Business Data Analyst plays a key role in the success of various projects, notably analytical products and system implementations by acting as the liaison between business teams and the IT team. This role requires the ability to understand stakeholders’ analytical or process needs (Finance, Operations, Merchandising, Logistics, etc.), formalize these requirements, and propose innovative solutions while adhering to industry best practices and constraints. The analyst actively contributes to requirements gathering, documentation, development of analytical solutions (such as Power BI), data standardization and quality, and participates in the full lifecycle of analytical or system implementation projects—from design to training and support. In addition to analytical and BI projects, the business data analyst can also participate in various cross functional projects touching system implementations, testing, and general support during project lifecycles.

Key Accountabilities

• Lead workshops with stakeholders to understand and formalize analytical or business process-related needs, acting as a primary point of contact between the IT team and business departments.
• Translate business requirements into clear functional specifications for IT developers or functional analysts.
• Conduct analyses in Power BI for various stakeholders and design innovative solutions that will be standardized by the IT team.
• Play an active role in BI governance: consistency, standardization, data quality, and integrity. Ensure adherence to best practices regarding security, RLS, performance, etc.
• Design, develop, and optimize Power BI data models (Direct Lake, Import, DirectQuery).
• Develop interactive, high performance, and visually consistent reports aligned with internal standards.
• Provide support for reports and dashboards.
• Contribute to the continuous improvement of BI standards, templates, processes, and best practices.
• Validate and test developed systems or developed reports with users.
• Support and advise stakeholders on optimal use of BI tools.
• Support the PMO team on system implementation related projects.

Job Requirements

• Minimum of 3 years of experience in BI.
• Minimum of 2 years of experience in advanced Power BI development.
• Significant experience as a Business Analyst.
• Strong proficiency in Excel and PowerPoint.
• Knowledge of the retail or manufacturing sector (asset).
• Knowledge of supply chain, warehousing and distribution process’ (asset)
• Proficiency in understanding detailed business process’
• Experience in a SAP environment and WMS systems (asset).
• Knowledge of process mapping tools such as Visio is an asset.
• Ability to understand source tables, data flows, and conceptual and logical models.
• Strong communication and ability to explain complex concepts to non-technical audiences.
• Proactivity, attention to detail, and strong customer orientation.
• Ability to manage multiple priorities and work in varied contexts simultaneously.
• Ability to adapt quickly to change and work under pressure with stakeholders at different levels and departments.
• Strong proficiency in English and French, spoken and written.