Data Platform Systems Analyst

Date: May 16, 2022

Location: North York, ON, CA, M9L 1N7

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


Responsible for the build and support of Data Platform systems, on premises and Public Cloud. Including data platform support, tools administration, and users support.

Job Responsibilities


  • Review and understand target state data strategy and end-to-end data management systems architecture (including meta-data management, data quality / profiling, data integration, master data management, data provisioning and Data Lake solution components)
  • Work with Azure Public Cloud subject matter experts to build DEV, QA and PROD, including Disaster Recovery, Data Lake environments to ensure proper configuration aligned with Architecture and business requirements.
  • Provide 2nd level support to Enterprise Data Platforms, Management team and end-users to identify root causes and remediate environment availability and performance incidents.
  • Implement dynamic environment provisioning services within Azure Public Cloud platforms for Digital and Business Sandboxes.
  • Test and validate automation scripts. Coordinate with Production Support to ensure that dynamic provisioning services are ready to be transitioned under production control
  • Review and understand target state data strategy and end-to-end data management systems architecture (including meta-data management, data quality / profiling, data integration, master data management, data provisioning and Data Lake solution components)
  • Work with Data ingestion and integration tool vendor and subject matter experts to install, configure, and test tool functions checks and transformation logic within pipeline
  • Implement integration hooks between Data Ingestion tool and other components, such as Azure Data Lake and EDP(Enterprise Data Platform) Tools
  • Build and execute functional, integration and load / performance test
  • Coordinate with Data Integration tool vendor to address defects, install patches and validate hot-fixes and patches
  • Coordinate with Release Management to promote Data ingestion software releases from DEV to UAT and PROD
  • Provide in-depth analysis of the hybrid cloud solutions to ensure high quality systems and performance.
  • Design, build, maintain and support server landscape, including Operating Systems and Hypervisors on all platforms
  • Provide 2nd and 3rd level support to end-users as related to all deployed platforms and Cloud services
  • May be asked to be a technical lead on some teams/Projects
  • To manage personal performance incorporating a commitment to ongoing professional development and continuous learning
  • Act as an escalation point of contact for GIS Service delivery, issues, requests and concerns following the ITSM processes
  • Provide accurate and complete documentation of processes and procedures to ensure that systems can be supported
  • May be responsible to assign personnel to various tasks, direct their activities & evaluate their work
  • Will be required to be on-call, where travel may be required to any of the Apotex and/or affiliate sites.
  • Provides input in the development/amendment of standard operating procedures
  • Write programmatic scripts for process and task automation with knowledge of at least one scripting language (such as VB Script or PowerShell)
  • Monitor and administer the Apotex Enterprise Data Platform tools stack (Azure, Informatica and Zettalabs)
  • 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

Good understanding and hands on experience with:

  • Microsoft Azure data services and data storage, data tools like DataBricks, Data Factory.
  • Data ingestion, pipelines. data tools like Hadoop.
  • Good knowledge with Azure Network, Security, storage, compute, Analytics, Databases, DevOps process and framework
  • Knowledge and experience with one or more of  Informatica EDC, IDQ, MDM, AXON will be an asset.

COVID-19 VACCINATION POLICY: In accordance with Apotex Inc. (“Apotex”) policy, as of November 15, 2021, all individuals entering a Canadian site (including but not limited to employees, visitors, contractors and agency workers) must be fully vaccinated against COVID-19 in accordance with the current government requirements.  Further, all employees must maintain all future booster vaccines as approved and recommended by Health Canada.  Accommodation from these requirements for reasons pursuant to the Ontario Human Rights Code, or any other applicable law (most commonly for medical and/or religious reasons) will be reviewed and considered by Apotex.


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.