Forecast Model Developer
Understand business logic and client needs and utilize strong Excel skills to create forecast models based on best practice methodologies.


Forecast Model Developer

Reports To:

Manager, Forecasting




Commercial Forecasting


Markham, Ontario


Full time, Permanent

Key Role

The Forecast Model Developer builds models in Microsoft Excel within Scarsin’s enterprise platform, i2e -Integrated Insight Environment

Duties and Responsibilities

  • Uses business logic, recognizes client needs and possesses very strong Excel skills to create forecast models based on best practice methodologies;
  • Works closely with team members, Project Managers, Forecast Development Manager, as well as acting as the client interface;
  • Performs quality assurance on the mathematics and queries to ensure correctness of reported values;
  • Works collaboratively, learns and shares knowledge, assisting other team members, with the ability to multi-task without compromising quality;
  • Pays keen attention to details and is meticulous in delivering client requirements to the highest standards of quality and accuracy;
  • Performs various other duties as delegated or assigned.

Required Knowledge, Skills, and Experience

The successful incumbent will have:

  • A university degree or college diploma in computer science, math, or a related major;
  • At least 2-3 years working analytical experience within the pharmaceutical industry;
  • Expert Excel skills a must, which include expertise in lookup and reference formula types, logical, financial, statistical, and Data Connections analytics, etc.;
  • Demonstrated strong knowledge and experience using macros and VBA Proven strong working understanding of relational databases such as SQL;
  • Proven ability to easily learn new software applications, industries, and technologies;
  • Proven ability to easily absorb and demonstrate new concepts and technologies as well as industry-specific knowledge and expertise;
  • Demonstrated exceptional attention to detail and high quality workmanship towards the delivery of world class solutions that are both robust and flexible;
  • Proven, motivated self-starter;
  • Proven skills in time management, problem solving and decision making;
  • Proven effective presentation, analytical, communications and customer relationship skills;
  • Ability to work well under pressure, prioritize, multi-task and maintain flexibility in a fast-paced environment;
  • Ability to work autonomously on multiple projects and associated deliverables;
  • Strong communication skills and the ability to work in a collaborative team environment;
  • Strong verbal and written English and the ability to interact comfortably with customers;
  • Preference for fast paced, rapid start-up culture demonstrating the values of results, teamwork, energy, agility, respect, and can-do environment.