Financial Analyst - Richmond, Canada - Tree Island Industries

Tree Island Industries

Verified Company

Richmond, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

COMPANY BACKGROUND
***
This position is a Co-op opportunity in our Finance department from May-December 2023.

The key responsibility of this role is to assist with the monthly demand forecasting process (RPP), which involves extraction, transformation, and load of data into models in order to develop a rolling 12-month sales forecast.

While the forecast is being generated through processes within IBM Planning Analytics, you will be required to look into trends and analyze market indicators and events that could affect demand and report findings in an internal Newsletter.

The second key accountability of this role is to support the annual budgeting process.

The Analyst will assist the budgeting process by preparing an Industry Outlook Report (IOR) reporting on macro-economic indicators and third-party industry reports.

The IOR (due October 1st) will be done with the assistance and under the supervision of the Financial Controller.

RESPONSIBILITIES
Demand Forecast
Oversee the monthly forecasting processes, primary responsibilities are as follows:

Up-keep of raw materials consumption database, including extract, analyze, transform & load data from IBM TM1 and IBM Cognos.
Prepare materials for the monthly demand planning meetings with Sales, Production & Planning and Management team in the form of a Market Update report.

Annual Sales Budgeting
Support the annual sales budgeting process, primary responsibilities are as follows:

Research and analyze key macro-economic and relevant markets indicators.
Analyze historical sales performance and, together with above external indicators, provide insight on achievability of sales budgets.

Market Insights

Provide market insights, primary responsibilities are as follows:

Develop and maintain reporting dashboards and metrics to enable better analysis for Sales & Production Planning, on a monthly basis.
Monitor and maintain database information on market trends, business indicators, and industry and trade databases.
Analyze and understand the market, for the areas we operate in and the products we sell, and raise visibility to emerging needs of the business along with tracking of opportunities.

HmF7SaYWJc