Data Analyst: Drive Insights with SQL & Dashboards

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

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.