business analyst Edwardsville
Job description
Please ensure you submit a cover letter with your resume that explains your background and why you think you would make the best choice for this role.
Business Analyst with Computer Programming/Automation Skills
We are looking for a Business Analyst with Computer Programming/Automation skills to join our team. The successful candidate will be able to write code (Python, R or VBA) and automate tasks, create dashboards for key performance indicators, streamline processes, automate production planning, automate sales forecasting, build a CRM database, optimize our fleet and routes, automate raw materials ordering, automate social media posting, and other related tasks. This role will work closely with our production team and other departments including the executive management team to improve efficiency, reduce errors, and increase productivity. The ideal candidate has a passion to learn, grow, and is motivated by continuous improvement.
Responsibilities:
- Monthly, quarterly and annual business reporting.
- Analyze and interpret sales data.
- Develop accurate sales forecasts for production planning.
- Automate production planning and sales forecasting.
- Monitor and track sales team performance against sales targets.
- Analyze customer data to provide insights on strategic actions.
- Build a CRM database and maintain customer data.
- Identifying changing customer needs through a constant review of the highest selling products.
- Write code (Python, R, or VBA) to automate various tasks and processes.
- Create dashboards to monitor key performance indicators and provide insights to the management team.
- Streamline processes to improve efficiency and reduce errors.
- Optimize fleet and routes to reduce transportation costs and delivery time.
- Automate raw materials ordering to ensure adequate inventory levels.
- Automate social media posting to increase our online presence.
- Collaborate with other departments to identify areas for improvement and implement solutions.
- Other related duties as assigned.
Qualifications:
- A University Degree in a related discipline.
- 3-years work experience in a business environment.
- Natural curiosity to effectively problem solve.
- Proficient in coding with Python and other relevant programming languages (R, Python and VBA).
- Advanced skills and experience working with Excel spreadsheets.
- Preferably has an exposure to or has used Power BI.
- Experience with data analysis and visualization tools.
- Strong problem-solving skills and attention to detail.
- Excellent communication skills and ability to work collaboratively with others.
- Ability to work independently and take ownership of projects.
- Ability to convey complex information in a clear and concise manner.
- Confidence with manipulating large datasets to turn raw data into practical insights.
- Highly collaborative work ethic with a desire to proactively work with others within the organization to accomplish organizational goals.
- Ability to handle multiple projects and pivot to the most urgent ones in an environment of constantly evolving priorities.
- Knowledge of sales methodologies, forecasting techniques and sales performance metrics.
We offer a great work experience opportunity in a supportive work environment. If you are a motivated individual with a passion for automation and process improvement, we encourage you to apply to this exciting opportunity.
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
Job Types: Full-time, Permanent
Salary: From $50,000.00 per year
Benefits:
- Company events
- Company pension
- Dental care
- Extended health care
- On-site parking
- Paid time off
- Vision care
Flexible Language Requirement:
- French not required
Schedule:
- Monday to Friday
Ability to commute/relocate:
- Edwardsville, NS B2A 4T7: reliably commute or plan to relocate before starting work (required)
Application question(s):
- Do you know Python programming language?
Education:
- Bachelor's Degree (preferred)
Language:
- English (required)
Work Location: In person
