BI Analyst-EN

CAE; Montreal; Hybrid; CAD 70,000 - 95,000; Full time

Job summary

CAE is seeking a BI Analyst for the Civil Products team in Montreal. You will design, develop, and maintain analytical solutions transforming data from multiple sources into dashboards, reports, and data models to support strategic decisions.

You will collaborate with stakeholders to improve analytics capabilities, data quality, governance, and continuous improvement initiatives. The role requires 2–4 years of BI experience, strong SQL, and proficiency with Power BI or Tableau.

Qualifications

• 2–4 years of BI solution development and data analysis experience.
• Strong SQL knowledge and relational databases.
• Ability to translate business requirements into analytics solutions.

Responsibilities

• Design, develop, and maintain dashboards, reports, and KPIs.
• Build scalable data models to support reporting.
• Create and document ETL/ELT processes for data integration.
• Collaborate with stakeholders to align analytics with business needs.
• Ensure data quality and governance across outputs.

Skills

BI experience

SQL

Data modeling

Power BI/Tableau

English/French

Education

Bachelor's degree in CS/IS/BI

Tools

Power BI

Tableau

Job description

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.

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 identity or expression, sexual orientation, disability, neurodiversity, veteran status, age, or other characteristics protected by law. We encourage applicants who may not meet every qualification to apply. Reasonable accommodations are available—contact your recruiter or email [e-mail] if needed.

Data Privacy

Privacy Statement | CAE As part of our process, we may use AI‑supported tools to help review applications, with human decision‑making at every step. CAE thanks all applicants for their interest. However, only those whose background and experience match the requirements of the role will be contacted.