BI Analyst / Data Analyst

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

• Gather, analyse and document business and data requirements.
• Translate the business teams’ requirements into functional requirements, user stories, acceptance criteria and data specifications.
• Identify the data required to support analyses, reports, dashboards or operational processes.
• Map business concepts to source data and target data structures.
• Define and document business rules, as well as data transformation, validation, quality and traceability rules.
• Analyse data sources and assess their availability, quality and suitability for the client’s needs.
• Collaborate on the design of data models, consumption layers and BI solutions.
• Maintain an end-to-end view of data flows, from source systems through to reports, dashboards or analytical solutions.
• Prepare and facilitate analysis, mapping and validation workshops with stakeholders.
• Collaborate with product managers, developers, data engineers, architects, BI teams and source system managers.
• Support functional validation activities, acceptance testing and the resolution of issues.
• Produce and maintain clear, comprehensive and actionable functional documentation for delivery and support teams.
  
  

Required Skills

Required qualifications to be successful in this role

• Experience in BI analysis, data analysis, functional analysis or business analysis.
• Very good command of SQL and the ability to analyse large volumes of data.
• Experience with Power BI, Tableau or other data visualisation and analysis solutions.
• Good understanding of ETL/ELT concepts, data integration, transformation, quality and traceability.
• Ability to read, understand and interpret conceptual, logical and physical data models.
• Ability to document business rules, transformation rules, validation rules and functional specifications.
• Experience with modern data environments, ideally within the Microsoft Azure, Fabric, Synapse, Databricks ecosystem or comparable technologies.
• Experience in an Agile, Scrum, Kanban or SAFe environment.
  
  

Technical strengths

• Knowledge of Azure, Microsoft Fabric, Azure SQL, Synapse, Databricks or Snowflake.
• Knowledge of AWS or other cloud data platforms.
• Experience with Microsoft SQL Server, T-SQL, views, stored procedures or query optimisation.
• Understanding of data models such as star schemas, Data Vault, data marts or data products.
• Experience in documenting ‘As-Is’ and ‘To-Be’ processes.
• Experience in the retail, distribution, logistics or shared services sectors.
• Experience in preparing data for BI, advanced analytics or AI use cases.
  
  

Key requirements

• Approximately 5 to 7 years’ experience in BI analysis, data analysis, functional analysis or business analysis.
• A bachelor’s degree in computer science, information systems, administration or analytics, or equivalent experience.
• Ability to work independently in a client-facing environment.
• Strong communication, workshop facilitation and consultancy skills.
• Ability to explain data-related issues in layman’s terms to business and technical stakeholders.
• High degree of autonomy, a sense of initiative and attention to detail in documentation.
• Excellent analytical, problem-solving and summarising skills.
• Bilingual in French and English.
• Based in the Montreal area or available to work with clients in Montreal.
  
  

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

At CGI, we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter.

That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.

To learn more about accessibility at CGI, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Come join our team - one of the largest IT and business consulting services firms in the world.