Analytics Engineer
Key Skills for This Role
Full Job Posting
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 to 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 a detail-oriented and motivated Analytics Engineer to join our Business Analytics & Reporting team. Reporting to the Manager, Business Analytics and Reporting, this role is responsible for building and supporting end-to-end analytics solutions, from data integration and modeling to dashboard development and reporting, helping drive consistent, data-informed decisions across the organization.
This position offers meaningful exposure to ERP systems, cross functional processes, and continuous improvement initiatives, making it an excellent opportunity for someone looking to build a strong, well‑rounded career.
Responsibilities Include
- Designing Medallion architecture layers, particularly Gold layer development
- 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 Business Intelligence tools
- Creating consistent definitions for metrics and business logic
- Data quality testing and validation
- Creating documentation and data lineage
- Working with Business Analysts and business stakeholders to translate requirements into data structures
- Preparing the organization for future front-end/visualization technologies
- Key contributor in the establishment of a centralized reporting framework
ABOUT YOU
Bachelor’s degree in Computer Science, Statistics, Information Systems or Business
Bachelor's degree in Accounting or Finance would be considered an asset
Five (5) to ten (10) years’ proven experience working within analytics
Experience working with Tableau, advanced SQL, data modelling, DBT and cloud data platforms
Strong proficiency working with Microsoft Office; specifically in Excel
Strong analytical and problem-solving skills
Strong interpersonal and communication skills; both verbal and written
Ability to work collaboratively in a team-based environment
Demonstrated ability to manage in a fast-paced environment with ability to manage a high volume of data; with strong attention to detail
Excellent time management and organization skills; ability to effectively prioritize and committed to deadlines
Experience working with a large ERP system is an asset
Ability to regularly work within our Sault Ste Marie, ON Head Office
WHAT WE OFFER
- We offer career growth and development through on-the-job training, professional courses, and peer learning in a friendly and inclusive work environment that allows you to thrive both personally and professionally.
- We offer a comprehensive total rewards package including:
- Salary Range: $100,000 - $105,000 per year
- 4 Weeks Paid Vacation
- Employer-matched Group RRSP
- Employer-paid Health & Dental Benefits
- Employee Assistance Program (EAP)
- Healthcare & Lifestyle Spending Account
- Life & Disability Insurance
- Employee & Customer Referral Programs
- Employee Discount & Perks Programs
- Are you ready to power your career and make a difference at McDougall Energy? Get energized and apply online today at www.mcdougallenergy.com/careers .
- 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. McDougall Energy does not use AI in the recruitment process.
About McDougall Energy
Canadian family-owned fuel distributor serving homeowners, businesses, motorists, and wholesale energy customers across Ontario.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at McDougall Energy
Accounting Assistant
Sault Ste. Marie, CAN
McDougall Energy is seeking an Accounting Assistant to support finance operations, maintain accurate account records, and help uphold internal controls. Candidates should have an accounting, business, or related postseco
Office Administration
Burford, CAN
McDougall Energy is hiring a contract Office Administrator to provide administrative support to dispatch and help coordinate transportation activities. The role includes customer calls, POS payments, inventory reconcilia
IT Operations Analyst
St. Thomas, CAN
McDougall Energy is seeking an IT Operations Analyst to support corporate technology solutions and mission-critical operations. The role combines user support, troubleshooting, infrastructure and application monitoring,
Professional Delivery Driver
Burford, CAN
Professional Delivery Driver
Ottawa, CAN
Accounting Assistant
Sault Ste. Marie, CAN
Professional Delivery Driver
Greater Sudbury, CAN
Office Administration
Burford, CAN
IT Operations Analyst
St. Thomas, CAN
Professional Delivery Driver
Burford, CAN
Professional Delivery Driver
Burford, CAN
Professional Delivery Driver
Ottawa, CAN
Office Administration
Burford, CAN