Data Architect, Enterprise Data Platform

Date: Jun 5, 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: www.apotex.com.

Job Summary

The Data Architect is responsible for ensuring the integrity and accessibility of data relevant to the organization by understanding enterprise data and entity relationships at a conceptual level, and providing direction on how data will be stored, consumed, integrated and managed by different data entities and information systems. You will collect, aggregate, store and reconcile data from multiple sources, helping to design and build data pipelines, streams, reporting tools, data generators and a whole range of tools to provide information and insight.

Job Responsibilities

  • Collaborate with business area and Global Information Services (GIS) leads to plan a data management strategy and enterprise data roadmap.
  • Develop the principles and data architecture strategies for data management; master data management, data content management, data quality, data discovery, meta-data management, data warehousing, and data life-cycle management.
  • Design and deliver the Data Architecture Model while mapping the data journey from operational system sources through any transformations in transit to its delivery into enterprise repositories (Data Lake, Data Hub, Data Warehouse, Master Data, etc.).
  • Design the Data architecture for Analytics (Reporting and Data Visualization), Advanced Analytics (Machine Learning, Data Science and Artificial Intelligence) and Data Delivery Services (Microservices and APIs).
  • Collaborate with business partners to convert business requirements into technical design specifications/documents as well as develop conceptual logical, and physical/functional models of the data
  • Assist the data governance lead with defining the policies and standards for naming, describing, governing, managing, modelling, cleansing, transforming, moving, storing, searching and delivering all data within the enterprise.
  • Build positive relationships with internal and external partners to determine information technology needs across organizations while keeping them current with new trends.

Job Requirements

Minimum of 10 years combined experience in Pharmaceutical/Process Industry, Consumer Packaged Goods, Information Systems, or Management Consulting Environment.
Post-Secondary education and/or University degree in sciences, technology or related area.

  • Strong communication skills, with the ability to work with technical and business teams at various levels within the organization.
  • Strong experience in Data Modelling, Data architecture, Data Integration, and Database Design.
  • Experience in building the Data Integration strategy using Batch (ETL/ELT), Streaming (Real-time/near-real streaming), by adopting CDC (changed Data Capture) Framework.
  • Experience in working with Cloud based Data systems (Azure Data lake, Databricks, Azure SQL and PostgreSQL Systems).
  • Possess a sound understanding of systems development; software project management approaches, interpreting and translating requirements, solution design and testing techniques.
  • Show excellent organizational and time management skills, with the ability to manage multiple priorities to accomplish objectives and goals anticipating and adjusting for problems and interruptions/roadblocks.
  • Strong ability to gather, author and analyze business and technical requirements and build applications and integrations according to specifications.
  • Full project management and development life cycle experience with the ability to lead projects and team members under limited supervision.
  • The following skills would be considered an asset:
    • Knowledge of Informatica Data Governance tools (Multi-domain Master Data Management, Data Quality, Enterprise Data Catalog, AXON Data Governance).
    • Knowledge in Analytics (Data Visualization, & Reporting) Advanced Analytics (Machine learning, Arfticial Intelligence, & Data Science) and Data Delivery Services (Microservices, & APIs Management).
    • Knowledge of SAP Source Systems, Oracle, SQL Server and PostgreSQL.

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.