BI Analyst

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

Benefits offered by this job

Flexible work arrangements

Career growth opportunities

Comprehensive benefits

Job summary

CAE Inc. is seeking a BI Analyst for Civil Products in Montreal. You will design and maintain dashboards and data models, build ETL/ELT processes, and partner with stakeholders to deliver data-driven insights.

You will ensure data quality and contribute to governance while supporting analytics roadmaps and automation initiatives. You will work in a fast-paced environment, collaborating with international teams, applying best practices, and supporting end users with training and documentation to

Qualifications

• Bachelor's degree in CS/IS/BI/SE/Math/Stats or related field.
• 2–4 years of BI solution development and data analysis experience.
• Advanced knowledge of SQL and relational databases.
• Experience with data modeling and ETL/ELT processes.
• Knowledge of data governance and data quality.
• Strong analytical and problem-solving skills.
• English and French communication abilities.

Responsibilities

• Design, develop, maintain, and optimize dashboards, reports, and KPIs.
• Develop and maintain scalable data models for reporting and analytics.
• Create, maintain ETL/ELT processes for data integration.
• Integrate data from multiple systems for consolidated insights.
• Ensure data quality, consistency, and accuracy across solutions.
• Define, document, and standardize KPIs, metrics, and rules.
• Investigate and resolve data, reporting, performance issues.
• Develop automation to improve efficiency.
• Create and maintain documentation for analytics solutions.
• Provide training and support to end users.

Skills

Analytical thinking

SQL proficiency

Education

Bachelor's degree in Computer Science/Information Systems/Business Intelligence/Software Engineering/Mathematics/Statistics

Tools

Power BI

Tableau

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.

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.

Welcome to CAE!

Welcome to CAE! As a global leader in Civil Aviation and Defense & Security across 40 countries, we advance together as One CAE, fueled by thousands of passionate individuals operating in a culture where everyone can thrive. We hold ourselves accountable for building an inclusive community at every level, and our comprehensive benefits support you professionally and personally. Together, we are All For shaping a future where safety, sustainability, and inclusivity lead the way. Join us and be part of something bigger—where your impact reaches beyond CAE and helps shape the world of tomorrow.