Business Intelligence Analyst – Finance, Corporate Solutions

BBA Consultants; Mont-Saint-Hilaire; Hybrid; CAD 85,000 - 125,000; Full time

Benefits offered by this job

Flexible schedule

Hybrid work environment

Group insurance from day one

Retirement savings plan

Annual vacation and sick leave

Referral bonus

Job summary

BBA Consultants in Mont-Saint-Hilaire, QC, Canada seeks a Business Intelligence Analyst – Finance to transform data into strategic insights for finance and cross‑functional teams. You’ll design and optimize BI systems, dashboards and data models to support the organization’s AI journey and data governance.

You’ll collaborate with Finance, Accounting, Sales and HR, drive KPIs, and ensure data integrity while delivering analytics solutions that empower decision-makers.

Qualifications

• University degree in computer science, statistics, engineering or a related field
• At least five years of business intelligence experience applied to finance
• Proficient with finance and accounting business processes and a solid understanding of HR, sales and project management business processes
• Excellent command of SQL and PowerBI
• Experience defining and implementing AI use cases
• Proficient with data warehousing and modelling principles
• Experience with Snowflake
• Participation in major transformation projects in agile mode
• Advanced English skills to facilitate collaboration with other BBA offices and/or clients in English-speaking Canadian provinces and internationally; you may need to use English occasionally or daily, depending on current projects
• Advanced French skills to facilitate collaboration with other BBA offices and/or clients in Québec
• Asset: experience in a services firm
• Asset: knowledge of Maconomy (Deltek) and SAP Business Objects
• Asset: experience with Azure DevOps

Responsibilities

• Build and maintain interactive dashboards and reports with Power BI and SAP Business Objects
• Leverage AI tools to accelerate data analysis, identify trends and generate relevant business recommendations
• Develop and test data integration solutions
• Perform technical analyses and estimate the effort required based on business needs
• Adhere to processes to minimize data quality risks and proactively identify potential data issues
• Design, maintain and optimize BI environments and models
• Contribute to solution architecture and detailed design
• Modify and support existing applications
• Define roles and responsibilities for data ownership and management
• Identify and recommend opportunities to improve systems
• Perform unit and integration tests
• Lead business process modelling workshops
• Document BI processes and reports clearly and thoroughly

Skills

SQL

Power BI

Education

University degree in computer science, statistics, engineering or a related field

Tools

Snowflake

Azure DevOps

SAP Business Objects

Maconomy (Deltek)

Job description

Business Intelligence Analyst – Finance, Corporate Solutions

Mont-Saint-Hilaire, QC, Canada

Type of position: Regular

You’ll report to the Product Manager, Corporate IT Solutions, and play a key role in helping the organization get more value from its data. Your mission will be to turn data into strategic insights that empower business teams to make informed, fact-based decisions. You’ll design, enhance and optimize the BI ecosystem, including the data warehouse, analytical models, dashboards and the foundations of the organization’s AI strategy.

You’ll serve as a bridge between technical teams and business units, helping stakeholders identify needs, define key performance indicators (KPIs) and implement tailored analytics solutions. You’ll also actively contribute to data governance, information integrity, the organization’s AI journey and the promotion of a data-driven corporate culture.

You’ll work closely with the Finance and Accounting group, business stakeholders across the organization (Sales, Project Management, HR), your team members and other IT groups, including development, infrastructure and the service centre.

Withus, you’ll get the opportunity to

• Build and maintain interactive dashboards and reports with Power BI and SAP Business Objects
• Leverage AI tools to accelerate data analysis, identify trends and generate relevant business recommendations
• Develop and test data integration solutions
• Perform technical analyses and estimate the effort required based on business needs
• Adhere to processes to minimize data quality risks and proactively identify potential data issues
• Design, maintain and optimize BI environments and models
• Contribute to solution architecture and detailed design
• Modify and support existing applications
• Define roles and responsibilities for data ownership and management
• Identify and recommend opportunities to improve systems
• Perform unit and integration tests
• Lead business process modelling workshops
• Document BI processes and reports clearly and thoroughly

Doyour qualities and values match our corporate culture?

• Results-driven
• Inspirational leadership
• Rigorous and ethical
• Strong interest in the world of technology
• Fascination for innovation
• Interest in solving the most complex challenges

Summaryof certifications and job requirements

• University degree in computer science, statistics, engineering or a related field
• At least five years of business intelligence experience applied to finance
• Proficient with finance and accounting business processes and a solid understanding of HR, sales and project management business processes
• Excellent command of SQL and PowerBI
• Experience defining and implementing AI use cases
• Proficient with data warehousing and modelling principles
• Experience with Snowflake
• Participation in major transformation projects in agile mode
• Advanced English skills to facilitate collaboration with other BBA offices and/or clients in English-speaking Canadian provinces and internationally; you may need to use English occasionally or daily, depending on current projects
• Advanced French skills to facilitate collaboration with other BBA offices and/or clients in Québec
• Asset: experience in a services firm
• Asset: knowledge of Maconomy (Deltek) and SAP Business Objects
• Asset: experience with Azure DevOps

An overview of BBA’s total rewards

• Annual base salary
• Annual premium program for regular employees
• Onsite mobility premium
• Time bank
• Cellphone fee reimbursement
• Group insurance plan from the first day of employment, including disability insurance and a telemedicine program
• Retirement savings plan
• Annual vacation and sick leave
• Premium for employee referrals

BBA considers many factors when determining the annual base salary, including market, education, relevant and demonstrated work experience, technical assessment, qualifications, certifications and other relevant skills

AtBBA, you get many benefits

• A flexible schedule that combines office presence and working from home
• A caring environment where everyone’s ideas are listened to and there’s no perception of hierarchy
• Friendly, eco-mindful and high-tech workspaces
• Committees involved in important causes: diversity, social commitment and more
• A growing business with many opportunities
• An inclusive culture that values diversity, respect and openness
• On site and at the office: Health, safety and the environment are a priority
• Participation in innovative projects
• A collaborative culture among various departments and with our operations clients
• Valuing complementary expertise
• Agility and listening: Your ideas are transformed into concrete initiatives

AboutBBA

BBA is one of Canada’s leading private consulting engineering firms, with over 45 years of experience serving the energy and natural resources industry.

Our people are the foundation of our success. Their passion and excellence have earned us recognition as one of Canada’s Best Employers and Best Managed Companies , and we’re committed to fostering a workplace where everyone feels empowered to grow, lead and be themselves.

Our teams bring together engineering, environmental and commissioning expertise to deliver practical, innovative and sustainable solutions—from strategy to execution. With 20 offices across Canada, the U.S. and Latin America, we combine local presence with international reach, offering clients close collaboration and field-ready support.

Learn more about our culture and projects on LinkedIn or connect with our talent team.