Business Analyst

Griffith Foods; Golden Horseshoe; On-site; CAD 65,000 - 85,000; Full time

Job summary

A leading company in the food industry is seeking a Business Analyst to enhance profitability through strategic pricing and business analytics. This role involves collaborating with senior leadership and cross-functional teams to develop pricing strategies, manage financial forecasting, and support sales activities. Candidates should possess a Bachelor's degree and relevant experience in pricing and analytics, along with advanced Excel skills.

Qualifications

• 2+ years of related experience in pricing, costing model building, and forecasting.
• Experience with sales and profitability tracking/reporting.
• Advanced skills in MS Excel including VLOOKUP and pivot tables.

Responsibilities

• Lead analytical support for pricing strategies and proposals.
• Prepare financial scenario models for pricing options.
• Manage pricing process and sales analysis in Griffith Pricing Applications.

Skills

Advanced MS Excel

Business analytics

Sales reporting

Education

Bachelor's degree in finance, business administration, or a related field

Tools

Microsoft D365

Power BI

Job description

Reporting to the Profitability and Pricing Manager, the Business Analyst is responsible for managing and improving the profitability of specific business segments within Griffith Foods in alignment with our company strategy. The role delivers business analytics and develops recommendations to senior leadership and Sales to guide key business decisions with a direct impact on our company performance and strategic initiatives.

Responsibilities:

1. Lead analytical support for senior leadership, Sales, and other internal stakeholders to develop and execute value-added pricing strategies and business proposals.
2. Support sales with pricing activities focused on margin improvement, business analytics, and sales reporting. Synthesize current business intelligence or trend data to support recommendations for pricing action. Recommends and develops improvements to the existing pricing process, guidelines, and strategies.
3. Develop and execute profitable pricing strategies and business proposals in alignment with our company purpose and strategy through collaboration with senior leadership, sales, purchasing, product development, supply chain, and other cross-functional teams.
4. Prepare financial scenario models and propose pricing options based on value-add, market, and competitive information to drive financial performance.
5. Complete and execute account profitability analysis and price review processes as per schedule to maintain or improve profitability of key accounts. Provide supporting documents and complete customer templates as required to support price changes.
6. Assist in financial forecasting and fiscal year budgeting through effective collaboration and communication with Sales, along with detailed analysis.
7. Ensure new business activities achieve contribution margin and gross margin targets, challenging sales to provide rationale on quotes below company guidelines.
8. Manage the pricing process within Griffith Pricing Applications and Microsoft D365 systems, with full responsibility for all sales analysis and data entry.
9. Provide ad hoc sales information to internal and external customers.
10. Assist in the completion of monthly reports as required.
11. Support Client RFI (Request for Information) and RFPs (Request for Price).
12. Assist in preparing and executing mass price changes within urgent time frames as needed.

Qualifications:

• Bachelor's degree (BA or BS) in finance, business administration, or a related field from a four-year college or university.
• 2+ years of related experience in pricing, costing model building, sales and profitability tracking/reporting, forecasting/budgeting, and variance analysis.
• Advanced MS Excel skills, including VLOOKUP, pivot tables, complex formulas, and Power BI.
• Experience with Microsoft D365 is preferred.