Business Intelligence (BI) Analyst

Avenir Energy; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A growing propane distribution company in Toronto seeks a Business Intelligence (BI) Analyst for a 1-year term. The role focuses on developing reports and dashboards using Power BI and SQL, requiring strong data analysis skills and collaboration with multiple departments. Ideal candidates have 3–5 years in analytics and a related degree. Competitive compensation and a respectful work environment are offered.

Qualifications

• 3–5 years of experience in data analysis or business intelligence.
• Proficiency in creating Power BI reports and dashboards.
• Strong analytical skills with attention to detail.

Responsibilities

• Collect and analyze large data sets ensuring accuracy.
• Develop and maintain dashboards to support decision-making.
• Write and optimize SQL queries for data extraction.

Skills

Data analysis

Power BI

SQL query development

Problem-solving

Communication

Education

Bachelor’s degree in Computer Science or related field

Tools

Power BI

MS SQL Server

ETL tools

Job description

Business Intelligence (BI) Analyst – 1 year term

About Avenir Energy Ltd.

Avenir Energy Ltd. is one of Canada’s largest and fastest-growing propane distribution companies. We are a fast-paced, customer-focused, field-based business with operations across the country and a commitment to excellence. With over 400 dedicated team members, we are driven to become the propane distributor of choice in North America.

At Avenir Energy, we offer a dynamic, respectful, and collaborative work environment where every team member plays a key role in our success.

Position Summary

As a Business Intelligence (BI) Analyst, you will support the development and maintenance of data reports, dashboards, and analytical tools that help business teams make informed decisions. You’ll work with Power BI and SQL to turn data into insights, ensuring information is accurate, accessible, and aligned with business needs. This role is ideal for someone who enjoys problem-solving, data visualization, and collaborating across departments.

Please note, this is a 1 year term role

Key Responsibilities

• Collect, clean, and analyze large data sets from multiple sources to ensure accuracy and consistency.
• Develop and maintain Power BI dashboards and reports to monitor key business metrics and support data-driven decision-making.
• Identify trends, patterns, and insights that help guide business strategy and performance improvement.
• Write and optimize SQL queries to extract, transform, and validate data for reporting and analysis.
• Collaborate with stakeholders to define requirements and translate business needs into effective analytical solutions.
• Support data quality, governance, and process improvement initiatives to enhance reporting reliability and efficiency.

Qualifications

• Bachelor’s degree or diploma in Computer Science, Information Technology, Business Analytics, or a related field.
• 3–5 years of experience in data analysis, business intelligence, or analytics.
• Proficiency in Power BI, including report creation and dashboard design.
• Strong knowledge of MS SQL Server and SQL query development.
• Familiarity with data visualization and data modeling concepts.
• Strong analytical and problem-solving skills with attention to detail.
• Effective communication and collaboration skills for working with both technical and non-technical users.
• Ability to manage multiple priorities in a fast-paced environment.
• Asset: Certification such as Microsoft Power BI Data Analyst Associate; experience with Excel, cloud BI platform
• Asset: ETL tools and processes, data ingestion, and architecture.

Avenir Energy is committed to accommodating applicants with disabilities throughout the hiring process. Please let us know if you require accommodation at any stage. By applying, you acknowledge that Avenir Energy may use third-party systems that employ Artificial Intelligence in recruiting and that employment offers are contingent on the completion of background checks, as required by company policy.

We thank all applicants for their interest; however, only candidates selected for an interview will be contacted.