Business Analyst

**Job description**

We are looking for a Business Analyst with strong Microsoft Excel skills that ideally also has programming/coding/data analytics experience.

The role is responsible for all aspects of order entry, order management, proactively managing inventory and movement of contract sourced products and generating long term planning schedules. The role is also responsible for the planning and oversight of finished goods production and raw material planning. Coordination with sales forecasting, production planning, and logistics on supply related issues are essential to ensure proper execution of freight moves.

**Responsibilities**:

- Create and maintain long term planning schedules:

- Plan production schedule and order product in order to to meet sales demand including innovation launches
- Plan and manage raw materials ordering
- Manage order delivery to warehouse and inventory
- Manage external orders and arrange logistics

o
- Maintain and ensure accuracy of data related to production planning and order placement and ensure that it is updated in a timely manner.
- Monitor costs to ensure the production process stays within budget
- Review of out of stock items, determine root cause and work with team to mitigate risk
- Develop, implement, monitor and maintain supply chain management strategies that increase efficiency and speed of operations.
- Communicate issues and concerns to management team in timely manner.
- Identifying changing customer needs through a constant review of the highest selling products.
- Collaborate with other departments to identify areas for improvement and implement solutions.
- Streamline processes to improve efficiency and reduce errors.
- Automate production planning, sales, raw materials and inventory forecasting.
- Write/script code (in Python, R, or VBA) to automate various tasks and processes.
- Other related duties as assigned.

**Qualifications**:

- A University Degree in a related discipline is a requirement.
- Strong Microsoft Excel skills is a requirement.
- Supply chain planning education and/or experience is an asset.
- 3-years of work experience in a business environment is an asset.
- Possess strong analytical and problem-solving skills with a keen eye for detail and accuracy.
- Possess intellectual curiosity and passion for continuous learning.
- Ability to work independently and take ownership/accountability of projects.
- Excellent communication skills and ability to work collaboratively with others as a team.
- Ability to handle multiple priorities and managed based on urgency in an environment of constantly evolving priorities.
- Proficiency in Python, R or VBA coding/programming is an asset.
- Ability to leverage Artificial Intelligence (AI) to help automate tasks and improve processes is an asset.
- Experience with using Power BI and other data analysis and visualization tools is an asset.

**About us**:
Cape Breton Beverages Limited is a fourth-generation, family-owned Pepsi bottling franchise. The company has been operating in Cape Breton for over 70-years, and together with its sister company Trans-Atlantic Preforms Limited employs over 100-people in the Cape Breton Regional Municipality. We locally produce Pepsi, 7-Up, Schweppes, and Crush soft-drink products and distribute other beverages including Aquafina, Montellier, Bubly and Evian waters, along with Gatorade, Dole, Lipton, Starbucks, Guru, and Rockstar beverages to Cape Breton Island, as well as produce specific packages of Pepsi and other-branded soft-drinks for the rest of Atlantic Canada, Quebec, and Ontario. As part of the Pepsi family, we are focused on delivering high-quality products and exciting brand campaigns to our customers.

Cape Breton Beverages is committed to fostering a diverse and inclusive culture. Our core values are integrity, respect, accountability, continuous improvement, and taking pride in one’s work. We strive to be a company that people are proud to work for - it’s more than a job when you work at Cape Breton Beverages - you’re part of a team that helps makes this Island a better place to live through the company’s continued active support and sponsorship of fundraisers, community-oriented organizations, and special events within the Cape Breton community.

In addition to paid salary, the following additional benefits/compensation will be available following completion of a 6-month probationary period:

- Mandatory benefit plan participation (cost shared 50/50) that includes:

- LTD (optional), Medical (mandatory), Dental (mandatory) and Life Insurance (mandatory), and
- Defined Contribution Pension Plan (mandatory); 5% annual gross salary contribution matched by the company
- Paid vacation

**Salary**: From $48,794.77 per year

**Benefits**:

- Company events
- Company pension
- Dental care
- Employee assistance program
- Extended health care
- Life insurance
- On-site parking
- Paid time off
- Vision care

Flexible Language Requirement:

- French