Mars Canada Business Analytics Analyst Co-op

Mars•Bolton, ON

About The Position

The purpose of this role is to support the Mars Wrigley Trade Planning Management (TPM) application and help manage the organization's central analytics repository. This includes managing the underlying analytic solutions for the Sales organization, ensuring they are up-to-date, accurate, and optimized for business needs. The role also involves improving dashboards, streamlining backend data ETL processes, and contributing to the enhancement of the analytics infrastructure. This is an important role in the development and management of Mars One Reporting Systems, including Power BI, CAS, and Kinaxis systems.

Requirements

1-3 years of IT experience in BI and data analytics.
Analytical and critical thinking abilities to solve business problems using data driven approaches.
Ability to effectively communicate technical information and data insights to non-technical stakeholders.
Experience with big data architectures and data modeling to efficiently process large volumes of data.
Experienced working with data analytics and visualization tools like Power BI and Tableau.
Versed in programming languages commonly used for data analysis (e.g. Python, R, SAS, MATLAB, Java, etc.).
Knowledge of database systems like MS SQL / MySQL and SQL for data retrieval and manipulation as well as other tabular data model expressions like DAX/MDX.
Familiar with Cloud Platforms, particularly Azure.
Experienced in data extraction, data cleaning and data processing (ELT and ETL) with Spark / PySpark.

Nice To Haves

Knowledge of SAP, TPM Applications and prior CpG experience would be an asset.

Responsibilities

Provide support to BI Lead in managing the central repository that captures all tools used by the Canadian organization (Analytics Hub Canada).
Assist in managing the analytic solutions for the Sales organization, including assisting users in troubleshooting, bug fixes, and working on enhancing them.
Optimize and work on enhancing productionized dashboards and data pipelines for our business intelligence layer.
Support the administration and management of Trade Planning Management (TPM) application (CAS) for the Canadian organization by helping maintain its backend functionality, governance process, supporting users with troubleshooting various issues and participating in testing of new upgrades.