BI Analyst

CAE; Montreal; On-site; CAD 65,000 - 90,000; Full time

Benefits offered by this job

Flexible work arrangements

Job summary

CAE is seeking a BI Analyst for Civil Products in Montréal. The role focuses on designing and maintaining dashboards, data models, and ETL/ELT processes to drive strategic and operational decisions.

You will partner with stakeholders across functions to ensure data quality, governance, and actionable insights while supporting analytics roadmaps and AI initiatives. You’ll collaborate with business users to translate requirements into scalable analytics solutions, deliver data-driven

Qualifications

• Bachelor’s degree in a related field.
• 2–4 years of BI solution development and data analysis experience.
• Experience with BI and data visualization tools (Power BI/Tableau).
• Advanced SQL and relational database knowledge.
• Experience with data modeling and ETL/ELT processes.
• Knowledge of data governance and data quality principles.
• Strong communication in English and French.

Responsibilities

• Design, develop, and optimize dashboards, reports, and KPIs.
• Create scalable data models to support analytics.
• Document ETL/ELT processes and data integration.
• Integrate data from multiple systems for consolidated insights.
• Ensure data quality and accuracy across solutions.
• Define KPIs, metrics, and business rules.
• Investigate data and performance issues with root cause analysis.
• Develop automation to improve efficiency.
• Document technical and functional analytics solutions.
• Collaborate with stakeholders to translate needs into analytics.

Skills

Power BI

Tableau

SQL

Data modeling

ETL/ELT

Data governance

Analytical skills

Bilingual EN/FR

Education

Bachelor's degree in Computer Science, Information Systems, Business Intelligence, Software Engineering, Mathematics, Statistics, or a related field

Tools

Power BI

Tableau

SQL

Job description

BI Analyst - Civil Products

Description

As a key member of the Civil Products Business Intelligence team, the Business Intelligence Analyst designs, develops, and maintains analytical solutions that support strategic and operational decision-making across the organization. This role transforms data from multiple business systems into reliable, scalable, and high-performing dashboards, reports, and data models that meet business requirements.

The BI Analyst collaborates with business stakeholders, analysts, process owners, and subject matter experts to enhance the organization's analytics capabilities while supporting data quality, governance, accessibility, and continuous improvement initiatives.

Key Responsibilities

• Design, develop, maintain, and optimize dashboards, reports, and key performance indicators (KPIs) using business intelligence tools.
• Develop and maintain scalable data models that support reporting and analytics requirements.
• Create, maintain, and document ETL/ELT processes for data integration and transformation.
• Integrate data from multiple business systems to provide consolidated and actionable business insights.
• Ensure data quality, consistency, and accuracy across reporting and analytical solutions.
• Participate in the definition, documentation, and standardization of KPIs, metrics, and business rules.
• Investigate and resolve data, reporting, and performance-related issues through root cause analysis.
• Develop automation solutions that improve operational efficiency and reduce manual processes.
• Create and maintain technical and functional documentation for analytics solutions.
• Participate in testing, validation, implementation, and deployment activities for new solutions and enhancements.
• Partner with business stakeholders to understand requirements and translate business needs into analytical solutions.
• Provide data-driven insights and recommendations to support business decisions.
• Contribute to data governance initiatives and continuous improvement projects.
• Train and support end users in the effective use of business intelligence tools, dashboards, and reports.
• Support the evolution of the analytics roadmap and the adoption of business intelligence best practices.
• Contribute to strategic initiatives involving data, analytics, and artificial intelligence.
• Perform other related duties as assigned.

Minimum Qualifications

• Bachelor's degree in Computer Science, Information Systems, Business Intelligence, Software Engineering, Mathematics, Statistics, or a related field.
• 2 to 4 years of experience developing business intelligence solutions and performing data analysis.
• Experience with business intelligence and data visualization tools such as Power BI, Tableau, or similar platforms.
• Advanced knowledge of SQL and relational database concepts.
• Experience with data modeling and ETL/ELT processes.
• Knowledge of data governance, data quality, and master data management principles.
• Strong analytical and problem-solving skills.
• Ability to collaborate effectively with stakeholders across multiple business functions.
• Strong written and verbal communication skills in English and French.
• Ability to manage multiple priorities in a fast-paced environment.

Preferred Qualifications

• Experience developing automation solutions that improve reporting and operational processes.
• Experience supporting analytics, reporting, or business intelligence roadmaps.
• Exposure to artificial intelligence, advanced analytics, or data-driven transformation initiatives.
• Experience documenting technical and business processes.

What CAE Offers

• A culture that values innovation, collaboration, and continuous improvement.
• Opportunities for professional growth and career advancement within a global organization.
• Meaningful work that contributes to aviation safety and operational excellence worldwide.
• Flexible work arrangements and autonomy in managing your responsibilities.
• Exposure to international teams and customers across multiple regions.
• Recognition for your contributions and achievements.
• Competitive compensation and comprehensive benefits.

About CAE

With more than 10,000 employees across 35 countries, CAE is a global leader in training and operational support solutions for the civil aviation, defense and security, and healthcare industries.

Learn more at www.cae.com .

About CAE

At CAE, our mission is clear: to help make the world a safer place. For nearly 80 years, we've driven innovation in simulation, training, and mission readiness to support critical operations worldwide. By leveraging advanced technologies, we empower our customers to operate smarter, faster, and more sustainably. Join a purpose-driven organization where bold ideas are encouraged, collaboration drives progress, and your growth fuels our shared success.

Position Type

Regular

Equal Opportunity & Accommodations

CAE is committed to providing equal opportunities to all applicants, regardless of race, nationality, color, religion, sex, gender iden