Find similar career opportunities
BI Analyst / Data Analyst Category: Business Analysis (functional and technical)
Main location: Canada, Montréal
Position ID:J1126-0149
Employment Type: Full Time
Position Description: The BI analyst / data analyst acts as a specialist at the intersection of business needs, operational processes, data and analytical solutions.
They analyse the needs of business teams, document processes, define functional requirements and data needs, and then translate these into clear, actionable specifications for the delivery teams. They help to make data more accessible, consistent, traceable and reusable, whilst supporting the production of reports, dashboards, analyses and metrics that enable better decision-making.
A senior BI analyst / data analyst who is self-reliant and able to contribute quickly to analysis, documentation, validation and collaboration with delivery teams, without necessarily being positioned as a data architect or specialist BI developer.
Your future duties and responsibilities: 1. Gather, analyse and document business and data requirements.
2. Translate the business teams' requirements into functional requirements, user stories, acceptance criteria and data specifications.
3. Identify the data required to support analyses, reports, dashboards or operational processes.
4. Map business concepts to source data and target data structures.
5. Define and document business rules, as well as data transformation, validation, quality and traceability rules.
6. Analyse data sources and assess their availability, quality and suitability for the client's needs.
7. Collaborate on the design of data models, consumption layers and BI solutions.
8. Maintain an end-to-end view of data flows, from source systems through to reports, dashboards or analytical solutions.
9. Prepare and facilitate analysis, mapping and validation workshops with stakeholders.
10. Collaborate with product managers, developers, data engineers, architects, BI teams and source system managers.
11. Support functional validation activities, acceptance testing and the resolution of issues.
12. Produce and maintain clear, comprehensive and actionable functional documentation for delivery and support teams.
Required qualifications to be successful in this role: Required skills
1. Experience in BI analysis, data analysis, functional analysis or business analysis.
2. Very good command of SQL and the ability to analyse large volumes of data.
3. Experience with Power BI, Tableau or other data visualisation and analysis solutions.
4. Good understanding of ETL/ELT concepts, data integration, transformation, quality and traceability.
5. Ability to read, understand and interpret conceptual, logical and physical data models.
6. Ability to document business rules, transformation rules, validation rules and functional specifications.
7. Experience with modern data environments, ideally within the Microsoft Azure, Fabric, Synapse, Databricks ecosystem or comparable technologies.
8. Experience in an Agile, Scrum, Kanban or SAFe environment.
Technical strengths
1. Knowledge of Azure, Microsoft Fabric, Azure SQL, Synapse, Databricks or Snowflake.
2. Knowledge of AWS or other cloud data platforms.
3. Experience with Microsoft SQL Server, T-SQL, views, stored procedures or query optimisation.
4. Understanding of data models such as star schemas, Data Vault, data marts or data products.
5. Experience in documenting 'As-Is' and 'To-Be' processes.
6. Experience in the retail, distribution, logistics or shared services sectors.
7. Experience in preparing data for BI, advanced analytics or AI use cases.
Key requirements
1. Approximately 5 to 7 years' experience in BI analysis, data analysis, functional analysis or business analysis.
2. A bachelor's degree in computer science, information systems, administration or analytics, or equivalent experience.
3. Ability to work independently in a client-facing environment.
4. Strong communication, workshop facilitation and consultancy skills.
5. Ability to explain data-related issues in layman's terms to business and technical stakeholders.
6. High degree of autonomy, a sense of initiative and attention to detail in documentation.
7. Excellent analytical, problem-solving and summarising skills.
8. Bilingual in French and English.
9. Based in the Montreal area or available to work with clients in Montreal.
Skills: 
