Sales & Operations Planning Analyst

COMPANY OVERVIEW:

Prollenium Medical Technologies Inc. is a fast-growing Canadian developer, manufacturer, and international distributor of premium hyaluronic acid (HA) dermal fillers and cosmetic products. We are proud to address all of our client's needs through streamlined innovation. Prollenium is able to ensure a continual flow of creation, unique ideas, and a steady pipeline of new and exciting products that provide safe and effective results. With regulatory approvals from the US FDA and Health Canada, Prollenium has sold over 5 million syringes from its Revanesse® product line across more than 80+ countries worldwide. Prollenium was the first manufacturer of hyaluronic acid dermal fillers in North America. Join our dedication to innovation. Prollenium provides competitive compensation, benefits, and development opportunities.

JOB SUMMARY:

As a member of the Operations team, the S&OP Analyst will gather and analyze numerous data sets and provide analytical support and insight to improve the operational effectiveness. You will liaise with various other departments across the organization to support the coordination of analytical efforts including Manufacturing, Logistics and Inventory Control. You will develop key performance analytics for the management team, develop new reporting methods and continuously improve existing tools and models which provide additional visibility on operational and sales performance. In addition, you will support existing partner and program tasks, document creation and ad-hoc reporting amongst other tasks.

MAJOR RESPONSIBILITIES:

Data Acquisition / Planning, Business Analysis, Operational Oversight, Business Controls

• Coordinates and leads cross functional efforts that identify key improvement opportunities, then designs a plan of action, executes the plan, reports the results, and ensures sustainability.
• Builds and manages tools and processes that support key objectives such as demand, capacity, and supply planning, inventory modeling, service and revenue forecasting, plan optimization, and gap analysis. Develops advanced analytical tools and reporting to support the entire S&OP process
• Creates, monitors, and maintains S&OP metrics and key performance indicators, identifying potential risks and opportunities
• Consolidates and analyzes demand and supply information for the operational, tactical, and strategic plans, and uses data to drive on-time delivery, establish lead times, inventory turns, and maximizing revenues.
• Work with operations to optimize production efficiencies with a focus on cycle times, batch sizes, working capital, and shift strategies.
• Once the plan is in place helps facilitate cross-functional communication between all levels of the organization to support new product launches. This might include line extensions, promotions, discontinuations, or other actions all based upon decision-making modeling of process flow, inventory levels, costs of manufacturing, and distribution and transportation.
• Determine target inventory and planning method policies for major products with input from business and segment leaders.
• Support decision-making and the improvement of critical processes including Production Scheduling, Materials Planning, Manufacturing, Inventory Planning, Capacity Planning, Transportation Planning, and Distribution Resource Planning.
• Drive resolution to operational issues, while keeping cross-functional partners aware of supply and service issues by providing facts.
• Responsible for system integrity relative to planning parameters (safety stock parameters, planning time fence, lot size.
• Builds and manages tools and processes that support key objectives such as demand, capacity, and supply planning, inventory modeling, service and revenue forecasting, plan optimization, and gap analysis. Develops advanced analytical tools and reporting to support the entire S&OP process
• Other duties as required, including ad hoc reporting and special projects

MINIMUM QUALIFICATIONS:

• Experience extracting information from Salesforce and ERP Systems
• Strong analytical combined with innovative problem-solving skillset
• Good knowledge transferring skills with an ability to present findings in a logical & relevant format (verbal & written)
• Good understanding of object-oriented databases and logical relationships
• Strong mathematical and statistical skills (data sets, variance, hypothesis testing)
• Expert attention to details and accuracy, able to conduct root-cause investigations
• Strong business modelling and information management skills
• Hands on and detail oriented and able to work well with multiple priorities
• Strong time management and ability to meet deadlines
• Results oriented with a sense of urgency
• Customer oriented – strives to exceed internal customer expectations
• Clear consistent and reliable communicator
• Comfortable in a fast-paced dynamic environment
• Analytical focus and statistical background would be considered an asset
• Microsoft suite products is a must have
• Ability to use data to help form decisions from a management and other internal stakeholders’ perspective

Technical Knowledge/Experience

• University degree in any discipline, or college diploma in a relevant discipline
• 3+ years experience with data analysis and reporting (including sales data, sales performance, commission calculations, pricing etc.)
• Experience or knowledge in using Salesforce
• Good understanding of compensation plans and programs
• Pricing analysis experience is a plus
• Advanced level of knowledge in MS Excel special functions (i.e. VLOOKUP & Pivot Table), VBA and experience of MS Office Suit, Excel, and Access, PowerPoint
• An in-depth understanding of data reporting tools and methods
• Basic familiarity with SQL and/or Databricks/Snowflake, including ability to read write and modify reporting and adhoc queries (nice to have)

Base salary range for the role: CAD $75,000 - $80,000/annum

Location: Richmond Hill (4 days in office, 1 day Work from Home)

Note: We use AI-enabled tools to support certain aspects of our recruitment process.