Business Intelligence (BI) Analyst, Corporate Solutions

bba; Mont-Saint-Hilaire; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading engineering consulting firm in Mont-Saint-Hilaire is looking for a Business Intelligence professional. You will enhance data solutions, work with various stakeholders to optimize BI environments, and ensure data integrity. Ideal candidates will have at least 5 years of experience and strong expertise in SQL and PowerBI, along with a university degree in a relevant field. The company offers a flexible work schedule and comprehensive benefits.

Benefits

Annual base salary

Group insurance plan

Flexible working schedule

Retirement savings plan

Health and safety initiatives

Qualifications

• At least five years of business intelligence experience.
• Experience as a data warehouse administrator and/or developer.
• Participate in major transformation projects in agile mode.

Responsibilities

• Design, enhance and optimize the BI ecosystem including the data warehouse.
• Build and maintain interactive dashboards and reports with Power BI.
• Contribute to data governance and ensure information integrity.

Skills

SQL

PowerBI

Data integration solutions

Data governance

Business process understanding

Education

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

Tools

Snowflake

SAP Business Objects

Azure DevOps

Job description

Overview

Type of position: Regular

Your future role on our team

You’ll report to the Product Manager, Corporate IT Solutions, and play a key role in enhancing data across the organization. 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 and dashboards.

You’ll serve as a bridge between the 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, ensure information integrity and promote a data-driven corporate culture.

You’ll work closely with the firm’s various stakeholders (Finance, Sales, Project Management, HR), your team members and other IT partners (development, infrastructure and service centre).

With us, you’ll get the opportunity to:

• Develop and test applications and 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 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
• Build and maintain interactive dashboards and reports with Power BI and SAP Business Objects
• Evaluate and integrate new BI solutions to improve organizational capabilities
• Document BI processes and reports clearly and thoroughly

Do your qualities and values match our corporate culture?

• Results-driven
• Inspirational leadership
• Rigour and ethics
• Strong interest in the world of technology
• Passion for innovation
• Interest in solving highly complex challenges

Summary of certifications and job requirements

• University degree in computer science, statistics, engineering or a related field
• At least five years of business intelligence experience
• Strong understanding of business processes (finance, HR, sales and project management)
• Experience as a data warehouse administrator and/or developer
• Excellent command of SQL and PowerBI
• 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 located in English-speaking Canadian provinces and abroad; you may need to use English occasionally or daily, depending on current projects
• Advanced French skills to collaborate effectively with BBA offices and/or clients outside 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 all regular employees
• Onsite mobility premium
• Access to a time bank
• Cellphone program
• Group insurance plan from day one, including short-term and long-term disability insurance and a telemedicine program
• Retirement savings plan
• Annual vacation and sick leave
• Premium offered through the Employee Referral program

BBA considers many factors to determine annual base salaries, including but not limited to market, education, relevant and demonstrated work experience, technical assessment, qualifications, certifications and other relevant competencies.

At BBA, you get many benefits

• Flexible schedule that combines office presence and working from home
• 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, etc
• Growing business with many opportunities
• Inclusive culture that values diversity, respect and openness
• On site and at the office: Health, safety and the environment are a priority
• Involvement in innovative projects
• Collaborative culture among various departments and with our operations clients
• Recognition of complementary areas of expertise
• Agility and listening: Your ideas are transformed into concrete initiatives

About BBA

For over 40 years, we’ve been pushing the boundaries of engineering to serve our clients in the Energy and Natural Resources sector. At BBA, we develop innovative, flexible and sustainable solutions, from strategy to execution. BBA is one of Canada’s leading private consulting engineering firms, focused on practice (PCB), with a network of 18 offices. Our teams work closely to deliver projects that shape tomorrow’s industry at the local, national and international levels. Our people’s passion and excellence make BBA one of Canada’s Best Managed Companies. We have unique talents, and we’re committed to providing a workplace where you can be yourself. Job postings are written in gender-neutral language. Learn more about us by visiting our LinkedIn page and join the networks of our talent attraction specialists to speak with them directly.