Data Analyst

McDougall Energy Inc.; Sault Ste. Marie; On-site; CAD 50,000 - 80,000; Full time

Job summary

A Canadian energy solutions provider is looking for a skilled Data Analyst. This role involves gathering data from multiple sources, ensuring data integrity, analyzing trends, and creating reports to aid decision-making processes. The ideal candidate will have a degree in a relevant IT field, proficiency in SQL, Python, and strong Excel skills. This position offers competitive compensation and various benefits, including a generous vacation policy.

Benefits

Competitive Compensation

4 weeks paid vacation

Employer Health & Dental Benefits

Group RRSP

Employee Assistance Program (EAP)

Healthcare & Lifestyle Spending Account

Qualifications

• Demonstrated ability to identify opportunities to streamline data collection and improve data quality.
• Experience working with data analysis tools and programming languages.
• Strong communication skills; both verbal and written.

Responsibilities

• Gather data from multiple sources including databases and cloud platforms.
• Ensure integrity and accuracy of the data collected.
• Transform data into structured formats suitable for analysis.
• Summarize findings and create reports and visual representations of data.

Skills

SQL

Python

R

SAS

Microsoft Excel

Tableau

Power BI

Education

College Diploma or University Degree in IT-related field

Tools

Informatica

ETL tools

Job description

COME GROW WITH US!

McDougall Energy is a Canadian family-owned business that distributes quality petroleum products and services reliably and responsibly. We are dedicated to delivering customized solutions that meet customers’ needs, improve lives, and enrich communities.

At McDougall Energy, we believe every team member has a role in fulfilling our purpose. That's why we give our people the trust, support, and opportunities they need to do their best work. We invite you to join us as we continue to connect customers with the energy solutions of today and tomorrow.

We are proud to be recognized as a Platinum Club member of Canada's Best Managed Companies, having consecutively retained our designation since 2011.

About The Opportunity

McDougall Energy is seeking an analytical and technically skilled IT professional to fulfill the position of Data Analyst. Reporting to the Director, Information Technology, this role collects, processes and analyzes large data sets and works with stakeholders to turn raw data into actionable insights that drive informed decisions across the McDougall Group of Companies.

• Gather data from multiple sources, such as databases, spreadsheets, cloud platforms, Application Programming Interfaces, and external data providers
• Ensure the integrity, accuracy, and completeness of data collected
• Review data for errors, inconsistencies, and missing values
• Transform data into structured formats suitable for analysis
• Apply statistical techniques to interpret data sets, paying attention to trends and patterns that could be valuable for diagnostic and predictive analytics
• Summarize findings and create clear reports, charts, dashboards and other visual representations of data to make complex data digestible for stakeholders
• Track key performance indicators and create regular performance reports to monitor business outcomes
• Present findings to management, operations teams, or clients, translating complex data into simple narratives
• Ensure all data handling complies with relevant data protection and privacy laws, such as Personal Information Protection and Electronics Document Act (PIPEDA), Personal Health Information Protection Act (PHIPA), or Payment Card Industry Data Security Standard (PCI DSS)

About You

• College Diploma or University Degree in an IT-related field such as Computer Sciences
• Experience in solution architecture, design, building and implementation of solutions
• Thrive in a highly collaborative workplace
• Demonstrated ability to identify opportunities to streamline data collection, processes, improve data quality, analysis techniques and implement best practices for management
• Experience working with data analysis tools and programming languages such as SQL, Python, R, or SAS
• Strong proficiency in Microsoft Excel and data visualization platforms, Tableau, Power BI, etc.
• Familiarity with databases, data warehousing concepts, and ETL processes
• Experience in Project Management techniques and phases
• Working knowledge of reporting tools within a SQL environment
• Knowledge of Informatica or other ETL tools is considered an asset
• Strong communication skills; both verbal and written

What We Offer

• Competitive Compensation
• 4 weeks paid vacation
• Employer Health & Dental Benefits
• Group RRSP
• Employee Assistance Program (EAP)
• Healthcare & Lifestyle Spending Account

Are you ready to power your career and make a difference at McDougall Energy? Get energized and apply online today!

McDougall Energy is committed to an inclusive, barrier‑free recruitment and selection process and workplace. If you require any accommodation, please notify us and we will work with you to meet your needs. Confidentiality of all applicants assured. Only those selected for interviews will be contacted and we thank all other applicants for their interest.