BI Data Engineer

Company Overview

Gerrie Electric is one of the largest independent electrical distributors with twenty-four key locations in Ontario and over 400 employees. We are a proud family owned, Canadian company and are headquartered in Burlington, ON. We are proud to be a Platinum Club winner of Canada’s Best Managed Companies. Having been in business since 1957, we are an established and well-respected company in the industry.

Culture

Our core purpose is Customer First- Employee Driven. We strive for an inspiring culture and integrity in all that we do.

Our success is powered by our people. We invest in the training & development of our employees and encourage career growth across all areas. We celebrate success and show recognition for a job well done.

We believe a more diverse and inclusive environment brings strength to our organization, helps our customers to succeed and creates a significant competitive edge.

What you will be doing

This is a replacement role for an existing member of the team.

Annual Salary $80,000 - $100,000

The BI Data Engineer organizes, manages, and optimizes company data so it can be effectively leveraged for informed decision-making, transforming raw data into actionable insights through data architecture, reporting, and analytics

Key Accountabilities

Design and Optimize Data Architecture and Integration

Build, maintain, and optimize SQL queries, data pipelines, and integrations across systems.

Ensure data integrity, consistency, and availability for analytics and reporting.

Adapt and evolve data solutions quickly to meet changing business needs.

Develop and Maintain Business Intelligence Solutions

Design, develop, and enhance Power BI dashboards and reports.

Ensure performance, scalability, and reliability across BI environments.

Continuously improve data models and visualizations to support business objectives.

Enable Strategic, Data-Driven Decision Making

Collaborate with business leaders to translate strategic objectives into actionable analytics.

Provide insights and recommendations that inform planning, performance, and growth.

Act as a thought partner to help the organization make smarter, faster decisions.

Uphold Data Governance, Security, and Quality

Enforce data governance policies, standards, and security protocols.

Identify and troubleshoot data discrepancies and quality issues.

Maintain compliance with privacy, retention, and security requirements.

Training and User Enablement

Provide training, documentation, and coaching to users and analysts on BI tools and best practices.

Create user guides and knowledge resources to support data literacy.

Partner with corporate trainers to foster a data-driven culture across the organization.

Skills and Experience Required

Bachelor's degree in Computer Science, Information Technology, or a related discipline.

An equivalent combination of education, professional certifications, and relevant experience will be considered.

Brings strong data and analytics expertise, combining technical proficiency, attention to detail, and a collaborative mindset to support data-driven decision-making and business performance.

5–8 years of progressive experience in business intelligence, data engineering, or analytics, with hands-on experience in SQL, Power BI, ETL processes, and data modeling.

Data & Analytics Expertise
Strong skills in SQL, Power BI, and data modeling/ETL processes, enabling efficient data extraction, transformation, and visualization. Capable of building scalable data solutions to support reporting and insights.

Data Quality & Performance Optimization
Focused on maintaining high data quality, accuracy, and integrity. Applies best practices to optimize data performance, ensuring reliable and efficient analytics environments.

Systems & Technical Capability
Experienced in managing data workflows and leveraging tools to support reporting, dashboards, and business intelligence initiatives. Ensures consistency and usability of data across systems.

Collaboration & Problem Solving
Works effectively with cross-functional teams to understand data needs and deliver actionable insights. Demonstrates strong problem-solving skills in addressing data challenges and improving processes.

Professional Approach & Data Governance
Committed to data security and best practices, maintaining confidentiality and compliance standards. Brings a proactive, detail-oriented approach to continuously improving data processes and outcomes.

We believe in taking care of our people

Major medical + dental coverage for yourself and your dependents (flex plan options available)

Employee Assistance Program

Global travel coverage

Pension plan with contribution matching

Training, development and career growth opportunities

Tuition re-imbursement program

Promote from within culture

A diverse and inclusive workplace

Caring and nurturing environment

Don't have all of these qualifications? Feel free to send in your resume, we can train you on what you need to know or there might be another role that fits better.

Words that our employees use to describe us

Inclusive, team-oriented, motivating, happy, forward thinking, innovative, successful

*Flexible interview options are available!