The Business Intelligence Analyst develops reports and dashboards, analyzes data, and collaborates with teams to improve decision-making processes.
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
Qualifications
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.
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.
Top Skills
Cloud Bi Platform
Etl Tools
Excel
Ms Sql Server
Power BI
SQL
Avenir Energy Toronto, Ontario, CAN Office
Toronto, Ontario, Canada
Similar Jobs
Financial Services
The Associate Product Delivery Manager will support large product initiatives and manage smaller projects, utilizing project management expertise to deliver solutions and drive results.
Top Skills:
ExcelJIRAPowerPointTeams
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The Account Executive will manage public sector client relationships, lead account planning, coordinate internal resources, and facilitate contract renewals while ensuring compliance and effective communication.
Top Skills:
Business AdministrationProject Management
eCommerce • Fintech • Real Estate • Software • PropTech
The role involves implementing AI and automation tools, managing marketing operations, building analytics infrastructure, and optimizing marketing technologies to enhance productivity and efficiency.
Top Skills:
AmplitudeBrazeGa4Google Tag ManagerHubspotIterableJavaScriptLookerMakeModeN8NPythonQuicksightRedshiftSalesforce Marketing CloudSnowflakeSQLTableauZapier
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
