Business Intelligence (BI) Analyst

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

Job summary

A propane distribution company in Dartmouth is seeking a Business Intelligence (BI) Analyst for a 1-year term to develop data reports and dashboards. The ideal candidate will analyze large data sets using Power BI and SQL, ensuring data accuracy and supporting strategic decisions. Qualifications include a bachelor’s degree and 3–5 years of relevant experience. This role promotes collaboration in a fast-paced environment.

Qualifications

• 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 SQL query development.

Responsibilities

• Collect, clean, and analyze large data sets from multiple sources.
• Develop and maintain Power BI dashboards and reports.
• Identify trends and insights to guide business strategy.

Skills

Data analysis

Business intelligence

Power BI

SQL

Data visualization

Problem-solving

Communication

Collaboration

Education

Bachelor’s degree in Computer Science, Information Technology, or related field

Tools

Power BI

MS SQL Server

Excel

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.