Business Analyst
- Mont-Royal, QC, Canada
Applications open in a new tab.
Job details
- Posting language
- English
- Posted
Original 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.
We thank all interested applicants. Only those selected for an interview will be contacted by our recruitment team.
More about this job
Responsibilities
The Business Data Analyst acts as a liaison between business teams and IT to formalize analytical needs and propose innovative solutions. They are responsible for requirements gathering, developing Power BI models, ensuring data quality, and supporting system implementation projects.
Requirements
Candidates must have at least 3 years of BI experience and 2 years of advanced Power BI development. Proficiency in business process analysis and strong communication skills are required, with knowledge of retail, manufacturing, or supply chain sectors considered an asset.
Skills
- Business Analysis
- Power BI
- Data Modeling
- Requirements Gathering
- Functional Specifications
- BI Governance
- Data Quality
- Excel
- PowerPoint
- SAP
- WMS Systems
- Process Mapping
- Visio
- Stakeholder Management
- Data Analysis
- Project Lifecycle
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Logistics
- Retail
- Manufacturing
Keywords
- Business Analyst
- Power BI
- Data Analysis
- BI Governance
- Direct Lake
- Import
- DirectQuery
- SAP
- WMS
- Visio
- Process Mapping
- Data Modeling
- Requirements Gathering
- Functional Analysis
- Retail
- Manufacturing
- Supply Chain
- Warehousing
- Distribution
- Project Management Office
- Data Quality
- Data Integrity
- Performance Optimization
- Stakeholder Management
- Business Intelligence