Business Intelligence Analyst – Finance, Corporate Solutions

Job summary

Design, maintain, and optimize the BI ecosystem, including data warehouses, analytical models, dashboards, and data integration solutions, while using AI tools to generate business insights. Partner with Finance and other business and IT teams to define KPIs, improve data governance and quality, support applications, and deliver tailored analytics solutions.

Job details

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 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. With us, 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 Do your 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 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 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 At BBA, 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 About BBA 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.

What you’ll do

Design, maintain, and optimize the BI ecosystem, including data warehouses, analytical models, dashboards, and data integration solutions, while using AI tools to generate business insights. Partner with Finance and other business and IT teams to define KPIs, improve data governance and quality, support applications, and deliver tailored analytics solutions.

Requirements

Requires a university degree in computer science, statistics, engineering, or a related field, plus at least five years of business intelligence experience applied to finance. Candidates need strong SQL and Power BI skills, knowledge of finance and accounting processes, data warehousing and modeling, Snowflake, AI use cases, and advanced English and French.

Benefits

• Annual Premium Program
• Onsite Mobility Premium
• Time Bank
• Cellphone Fee Reimbursement
• Group Insurance
• Disability Insurance
• Telemedicine Program
• Retirement Savings Plan
• Annual Vacation
• Sick Leave
• Employee Referral Premium
• Flexible Schedule
• Work From Home

Listed skills

• Power BI · Preferred
• SQL · Preferred
• Financial analysis · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Business Intelligence
• Financial Analysis
• Power BI
• SQL
• Data Warehousing
• Data Modeling
• Snowflake
• SAP BusinessObjects
• Artificial Intelligence
• Data Integration
• Dashboard Development
• Data Governance
• Business Process Modeling
• Agile Project Delivery
• Azure DevOps
• Finance And Accounting Processes

Job areas

• Data & Analytics
• Finance & Accounting
• Technology
• Consulting

More jobs from BBA Consultants