ST-Analyst, Sales Planning (8-12 months, Summer 2023, co-op)

Date: Jan 23, 2023

Location: North York, ON, CA, M9L 2Z7

Company: Apotex


About Apotex Inc.

Apotex Inc. is a proudly Canadian, global pharmaceutical company that produces high-quality, affordable medicines for patients around the world. Apotex employs almost 8,000 people worldwide in manufacturing, R&D, and commercial operations.  Apotex Inc. exports to more than 100 countries and territories and operates in more than 45 countries, with a significant presence in Canada, the US, Mexico, and India. Through vertical integration, Apotex is comprised of multiple divisions and affiliates including Apotex Inc., focused on generics; Apobiologix, a division of Apotex Inc. focused on biosimilar development; Aveva, an affiliate of Apotex Inc. fully integrated global developer and manufacturer of complete transdermal solutions; Apotex Consumer Products, a division of Apotex Inc. focused on brand name products; and Global Active Pharmaceutical Ingredients (GAPI), a division of Apotex Inc. focused on the manufacturing of active pharmaceutical ingredients (API) for Apotex and third parties. For more information visit:

Job Summary

Assist in the creation of highly specialized analytics and performance reporting to enable and support business decision making activities. Participate initiatives in automation and to create tools and reporting that improve the efficiency of the Commercial Finance department.

The successful candidate should have principles of SQL language and be able to read, understand and write simple to intermediate SQL scripts. Knowledge of database fundamentals is an asset for this position. Also, programming in Python or similar language with an interest and aptitude for learning new programming languages.  The position will be hands on with data 80% of the time. There is a documentation component which will be expected and guided throughtout the work term length.

Job Responsibilities

  • Support system and analytical tools implementation.
  • Automation of existing processes.
  • Documentation of code and processes.
  • Works in a safe manner collaborating as a team member to achieve all outcomes.
  • Demonstrate Behaviours that exhibit our organizational Values: Collaboration, Courage, Perseverance, and Passion.
  • Ensure personal adherence with all compliance programs including the Global Business Ethics and Compliance Program, Global Quality policies and procedures, Safety and Environment policies, and HR policies.
  • All other relevant duties as assigned.


Job Requirements

  • Education
    • Must be enrolled in a recognized post-secondary Co-op education program (Database Application Developer)
  • Knowledge, Skills and Abilities
    • Must be able to work on 2-4 month term projects and read SQL code as well as Python or similar programming language.
    • Strong knowledge of SQL and the Relational Database model
    • Autodidactism is a must. Candiate will need to learn on his/her own Transact-SQL scripting and any other computer language as required within a reasonable timeframe.

At Apotex, we are committed to fostering an inclusive, accessible work environment, where all employees feel valued, respected and supported.

Apotex offers accommodation for applicants with disabilities as part of its recruitment process.  If you are contacted to arrange for an interview or testing, please advise us if you require an accommodation.