Avenir Energy Ltd.

Business Intelligence (BI) & Data Analytics Lead

Business Intelligence (BI) & Data Analytics Lead
Notice info
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


eGydXdZTTl

Similar Jobs

EH

Data Analyst

logo
Job TypeFull-time
Salary
$1000 - $2000
Allport, AR
3 days ago
company-logo

Business Intelligence Lead - Operations

Waukesha Gas Engines
Job Typefull_time
 
Welland, ON
about 1 month ago
company-logo

Lead Data and Analytics Developer

NiSource
Job Typefull_time
Salary
$110200 - $165300
Columbus, OH
28 days ago
company-logo

Analyst - Accounting BI Reporting and Analytics

Con Edison
Salary
$80000 - $105000
New York, NY
about 1 month ago
company-logo

Senior Analyst - Accounting BI Reporting and Analytics

Con Edison
Salary
$95000 - $130000
New York, NY
about 1 month ago
company-logo

IT Data & Analytics Lead

Xcel Energy
Salary
$109500 - $155500
Minneapolis, MN
about 1 month ago
company-logo

BI Data Analyst

Luck Companies
Job TypeFull-time
 
Manakin Sabot, VA
24 days ago
company-logo

Lead Analyst - Intercompany Analytics

Avangrid
Job Typefull_time
 
Boston, MA
29 days ago
company-logo

Business Intelligence Analyst

STRIKE
Job TypeFull-time
 
Spring, TX
17 days ago
company-logo

Business Intelligence Analyst

BKV Corporation
Job Typefull_time
Salary
$75000 - $122000
Denver Metropolitan Area
20 days ago
company-logo

BI & Visualization Lead

Xcel Energy
Salary
$125900 - $178766
Minneapolis, MN
about 1 month ago
company-logo

Project Planning and Execution Data Analytics Lead

DPR Construction
Job TypeFull-time
 
Dallas, TX
about 1 month ago
company-logo

Business Intelligence Analyst

Clayco
Job TypeFull-time
 
St. Louis, MO
about 1 month ago
company-logo

Workforce Analytics Lead

PPL Corporation
Job Typefull_time
 
Louisville, KY
about 1 month ago
company-logo

SENIOR ANALYST, DATA ERM & SUPPLY CHAIN ANALYTICS

CenterPoint Energy
Job TypeFull-time
 
Houston, TX
about 1 month ago
company-logo

Lead Data Analyst

GE Vernova
Job Typefull_time
 
Markham, ON
21 days ago
company-logo

BI Business Analyst

CMC
 
Irving, TX
about 1 month ago
company-logo

Research and Business Intelligence Manager

Greenville Utilities
Salary
$70803 - $109740
Greenville, NC
about 1 month ago
company-logo

Project Director, Competitive Intel - Data & Analytics

NextEra Energy Resources
Job Typefull_time
 
Juno Beach, FL
about 1 month ago
company-logo

Data Analytics Strategy intern

Orbia
Job Typeinternship
 
Massachusetts, United States
about 1 month ago

Trending Jobs

company-logo

Foundry Professionals

Penticton Foundry
Job TypeFull-time
 
British Columbia, Canada
about 1 month ago
company-logo

Deckhand

Ballard Marine Construction
Job TypeFull-time
 
Bradenton, FL
about 2 months ago
company-logo

Apprentice Lineman

N Line Electric
Job TypeFull-time
Salary
$68640 - $106080
Longmont, CO
about 1 month ago
company-logo

HSE Operations Manager

ProPetro Services, Inc
Job Typefull_time
 
Midland, TX
27 days ago
company-logo

LCL66 Apprentice Lineman Distribution

CenterPoint Energy
Job TypeFull-time
 
Houston, TX
about 2 months ago
company-logo

Lineman, Apprentice

Imperial Irrigation District
Job TypeFull-time
Salary
$82706 - $95679
Imperial, CA
about 1 month ago
E

Quality Control Inspector

logo
Energyhire
Job TypeOther
Salary
$1200 - $3000
Houston, TX
9 days ago
company-logo

Inventory Materials Specialist

HF Sinclair
Job Typefull_time
 
Artesia, NM
20 days ago
WO

Field Service Technician

Westar Oilfield Rentals Inc
Job TypeFull-time
 
Fort St. John, BC
about 1 month ago
company-logo

EAST VALLEY NIGHT BILINGUAL JANITORIAL UNIT MANAGER( MESA,CASA GRANDE, GILBERT)

ENVIRONMENT CONTROL
Job TypeFull-time
Salary
$41600 - $47840
Mesa, AZ
about 1 month ago
company-logo

Manager, IT - BMO

Constellation
Job Typefull_time
 
Kennett Square, PA
about 1 month ago
E

Assistant Professor

logo
Energyhire
Job TypeContract
Salary
$2000000 - $2000000
Anthony, Kansas
about 21 hours ago
S

Electrical Lineman

Smarthire
Job TypeFull-time
Salary
$62400 - $72800
Austin, TX
about 2 months ago
company-logo

Land Coordinator

Covia
Job Typefull_time
 
Concord, NC
about 1 month ago
company-logo

Quality Plus Store Associate

Quality Oil Company LLC
Job TypePart-time, Full-time
 
Halifax, VA
about 1 month ago
LE

Préposé(e) à l'entretien ménager

Les Entretiens Uni-Net Inc.
Job TypePart-time
 
Montréal, QC
about 1 month ago
company-logo

Gas Mechanic Helper

National Grid
Salary
$66560 - $66560
Watertown, NY
about 1 month ago
company-logo

Quality Inspector

ACCIONA
Job Typefull_time
 
British Columbia, Canada
about 1 month ago
company-logo

Heavy Truck Driver

Halliburton
Job TypeFull-time
 
Bossier City, LA
about 1 month ago
company-logo

NIGHT BILINGUAL JANITORIAL SUPERVISOR(SOUTH EAST VALLEY)

ENVIRONMENT CONTROL
Job TypeFull-time
Salary
$41600 - $47840
Gilbert, AZ
about 1 month ago