Avenir Energy Ltd.

Business Intelligence (BI) & Data Analytics Lead

LocationDartmouth, NS
Job TypeFull-time

About This Job


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. As a full-time member of our team, you’ll enjoy:

Comprehensive Benefits: Full coverage for health, dental, paramedical, and life insurance, including virtual healthcare
Employee Assistance Program (EAP): Confidential support for you and your family to help improve health and well-being
Retirement Planning: RRSP and TFSA options with employer-matching contributions to help you plan for your financial future
Work-Life Balance: Generous vacation, floater days, and flexible time-off programs to ensure you have time to recharge
Incentive Programs: Annual performance-based rewards for both individual and company achievements


Job Description:

As the Business Intelligence (BI) & Data Analytics Lead, you will play a critical role in delivering high-quality, actionable insights and dashboards to support data-driven decision-making. Leveraging your expertise in Power BI, SQL, and programming, you will design and maintain scalable analytics solutions that ensure our business teams have timely and accurate data to drive strategic initiatives.


Key Responsibilities:

Develop, design, and maintain interactive Power BI reports and dashboards to support business needs and strategic goals
Write and optimize complex SQL queries and stored procedures to extract, transform, and load data from MS SQL Server databases
Implement automated data pipelines to ensure real-time or scheduled data availability based on business requirements
Use programming skills to develop custom solutions for data processing, automation, and reporting enhancements
Collaborate with business users to define reporting requirements and ensure solutions meet their needs
Troubleshoot and resolve any issues with data integrity, reports, or performance in Power BI and SQL Server
Ensure adherence to best practices for data visualization, data modeling, and database optimization
Document processes, technical specifications, and reporting procedures for team reference and training purposes
Provide technical support for existing reports, including monitoring and troubleshooting any report or database-related issues
Stay up to date with new technologies, Power BI features, and trends in data analytics and programming to continuously improve solutions


Qualifications

Bachelor’s degree in computer science, Information Technology, Business Analytics, or a related field
5 years’ experience of experience in Business Intelligence, Data Analytics, or a related field with a focus on Power BI
Expertise in Power BI report creation, dashboard design, and data visualization best practices
Solid proficiency in MS SQL Server, including writing complex queries, stored procedures, and performance tuning
Medium to high proficiency in general programming skills, including but not limited to scripting languages (e.g., Python, C#, JavaScript)
Experience with ETL processes and integrating data from multiple sources
Experience leveraging Azure services (Azure Data Lake Storage, Azure Data Factory, Azure Databricks, Power BI Embedded in Azure, etc.,.)
Strong analytical and problem-solving abilities with a focus on delivering actionable insights
Excellent communication skills with the ability to explain technical concepts to non-technical users
Attention to detail and a strong commitment to data accuracy and quality
Ability to manage multiple tasks and prioritize in a fast-paced environment


Preferred Skills (Optional):

Experience with cloud platforms such as Azure, AWS, or Google Cloud
Knowledge of other reporting tools or business intelligence platforms (e.g., Tableau, Qlik)
Experience with data warehousing and data modeling concepts

Avenir Energy is committed to accommodating applicants with disabilities throughout the hiring process. Please let us know if you require accommodation at any stage of the hiring process. By applying for a position with Avenir Energy, you understand that we use third party systems and recruiting agencies that may employ the use of Artificial Intelligence within their programs for finding, screening, assessing, and/or selecting candidates. You also understand that offers of employment are contingent upon the successful completion of appropriate background checks. The type of checks performed is determined by the role and Avenir Energy’s employment policies. You will be notified during the hiring process which checks you are required to complete. We thank you for your interest. Only candidates selected for an interview will be contacted.


Powered by JazzHR


EwGWKtnv7D

Similar Jobs

company-logo

Business Intelligence (BI) & Data Analytics Lead

Avenir Energy Ltd.
Job TypeFull-time
 
Dartmouth, NS
15 days ago
company-logo

Business Intelligence Operations Lead

Innio
 
Waukesha, WI
4 days ago
company-logo

Business Intelligence Operations Lead

Waukesha Gas Engines
Job TypeFull-time
 
Welland, ON
4 days ago
company-logo

Commercial Analytics Engineering Lead

Phillips 66
Job TypeFull-time
 
Houston, TX
5 days ago
company-logo

Commercial Analytics Engineering Lead

Phillips 66
Job TypeFull-time
 
Houston, TX
5 days ago
company-logo

IT Business Intelligence Analyst III | Power BI

Arizona Public Service (APS)
 
Phoenix, AZ
26 days ago
company-logo

Business Data Analytics Intern

Pacific Gas and Electric Company
Job TypeFull-time
 
Livermore, CA
28 days ago
company-logo

Business Data Analytics Intern

Pacific Gas and Electric
Job TypeFull-time
Salary
$47840 - $72800
Livermore, CA
29 days ago
company-logo

Business Intelligence Analyst

Senergy Petroleum
Job TypeFull-time
 
Phoenix, AZ
10 days ago
company-logo

Business Intelligence Analyst

Southern Company
Job TypeFull-time
 
Atlanta, GA
16 days ago
company-logo

Business Intelligence Analyst

Georgia Power Company
Job TypeFull-time
 
Atlanta, GA
16 days ago
company-logo

Business Intelligence Analyst

Global Partners LP
 
Waltham, MA
24 days ago
company-logo

Business Analyst – Data & Insights

Conservice
 
Logan, UT
25 days ago
company-logo

Senior Business Intelligence Developer

Marathon Petroleum Corporation
Job TypeFull-time
 
San Antonio, TX
11 days ago
company-logo

Senior Business Intelligence Developer

Marathon Petroleum Corporation
Job TypeFull-time
 
Findlay, OH
11 days ago
company-logo

Senior Business Intelligence Analyst (Senior - Manager)

Halliburton
Job TypeFull-time
 
Houston, TX
4 days ago
company-logo

Senior Data Scientist- Commercial Analytics.

Vistra Corp.
Job TypeFull-time
 
Irving, TX
2 days ago
company-logo

Business Intelligence Developer/Specialist

Owen Electric Company, Inc.
Job TypeFull-time
 
Saint Augustine, FL
4 days ago
company-logo

Analytics Developer

Ergon Inc.
Job TypeFull-time
 
Flowood, MS
4 days ago
company-logo

Senior Analyst - Data Strategy and Analytics

Enercare
Job TypeFull-time
 
Markham, ON
10 days ago

Trending Jobs

company-logo

Nuclear Technical Intern - Mid Atlantic

Constellation
Job TypeInternship
 
Lusby, MD
25 days ago
company-logo

Apprentice Lineman

Brink Constructors, Inc.
Job TypeFull-time
 
Rapid City, SD
24 days ago
company-logo

Deckhand (Houston)

John W. Stone Oil Distributor, LLC
 
Houston, TX
25 days ago
company-logo

Electrical Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, Pennsylvania
3 months ago
company-logo

Director, Financial Planning & Analysis - Energy (Enterprise)

Pilot Thomas Logistics
Job TypeFull-time
 
Grapevine, TX
25 days ago
company-logo

Quality Engineer

Jedco Inc.
Job TypeFull-time
 
Grand Rapids, MI
19 days ago
company-logo

Apprentice Lineman I

San Patricio Electric Cooperative, Inc.
Job TypeFull-time
 
Sinton, TX
9 days ago
company-logo

Solar Electrician

MN8 Energy
Job TypeFull-time
 
California, United States
23 days ago
company-logo

Gas Foreman

Peak Utility Services Group
Job TypeFull-time
 
Lawton, OK
24 days ago
company-logo

Sr. Polymer Scientist

ExxonMobil
Job TypeFull-time
 
Baytown, TX
23 days ago
company-logo

contract landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Lafayette, Louisiana
about 2 months ago
company-logo

Apprentice Power Lineman

Proline Power Corp.
Job TypeFull-time, Apprenticeship
 
Red Deer, AB
29 days ago
SD

Service Manager

Supertech Diesel Truck Specialists
Job TypeFull-time
 
Langley, BC
22 days ago
company-logo

Finishing Helper Entry Level- Dayshift

Bonnell Aluminum
Salary
$41600 - $41600
Carthage, TN
19 days ago
company-logo

Oil and Gas Land and Title Analyst - SAM Associate II

Bank of America
Job TypeFull-time
 
Dallas, Texas
19 days ago
company-logo

Meter Technician

ONEOK
Job TypeFull-time
 
Odessa, TX
25 days ago
SD

Service Manager

Supertech Diesel Truck Specialists
Job TypeFull-time
 
Nanaimo, BC
22 days ago
company-logo

Senior Landman

Greenlake Energy
Job TypeFull-time
 
Austin, Texas
16 days ago
company-logo

Senior Investigator

Dominion Energy
Job TypeFull-time
 
Norfolk, VA
25 days ago
company-logo

Assembler/Production

Uptalent
Job TypeContract
Salary
$37440 - $49920
Oklahoma City, OK
18 days ago