Analytics Engineer: Data Modeling, SQL & Tableau

Mcdougall-Energ; Sault Ste. Marie; On-site; CAD 100,000 - 105,000; Full time

Job summary

McDougall Energy in Sault Ste. Marie, ON is seeking an Analytics Engineer to join our Business Analytics & Reporting team. You will build end-to-end analytics solutions from data integration to dashboarding, helping drive data-informed decisions across the organization.

You will work with ERP systems, data models, SQL, Tableau, and data quality practices while collaborating with analysts and stakeholders to translate requirements into scalable data structures and centralized reporting.

Qualifications

• Bachelor’s degree in Computer Science, Statistics, Information Systems or Business.
• Five (5) to ten (10) years’ proven analytics experience.
• Experience with Tableau, advanced SQL, data modelling, DBT and cloud data platforms.
• Strong proficiency with Microsoft Excel.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork skills.
• Ability to work in a fast-paced environment with high data volume.
• Experience with a large ERP system is an asset.
• Ability to work regularly at Sault Ste Marie Head Office.

Responsibilities

• Building and maintaining curated analytical datasets.
• Creating dimensional models, fact/dimension tables and data marts.
• Writing and optimizing SQL views.
• Establishing reusable datasets that can feed Tableau and other BI tools.
• Creating consistent definitions for metrics and business logic.
• Data quality testing and validation.
• Creating documentation and data lineage.
• Working with Business Analysts and stakeholders to translate requirements into data structures.
• Preparing the organization for future front-end/visualization technologies.
• Key contributor in establishing a centralized reporting framework.

Skills

Tableau

Advanced SQL

Data modelling

DBT

Cloud data platforms

Excel

Analytical skills

Communication

Teamwork

Time management

Education

Bachelor's degree in Computer Science/Statistics/Information Systems/Business

Bachelor's degree in Accounting or Finance (asset)

Tools

Tableau

DBT

SQL

Job description

McDougall Energy in Sault Ste. Marie, ON is seeking an Analytics Engineer to join our Business Analytics & Reporting team. You will build end-to-end analytics solutions from data integration to dashboarding, helping drive data-informed decisions across the organization.

You will work with ERP systems, data models, SQL, Tableau, and data quality practices while collaborating with analysts and stakeholders to translate requirements into scalable data structures and centralized reporting.