Medexus Pharmaceuticals Inc. is a leading specialty pharmaceutical company with a focus on the therapeutic areas of rheumatology, auto-immune disease, specialty oncology, allergy, and pediatric diseases. We provide market-leading prescription and over-the-counter brands to patients and healthcare professionals, which we believe greatly enhances quality of life and promotes a healthy lifestyle. We have a strong North American commercial platform, and we currently operate through two unique segments: Medexus Pharma Canada and Medexus Pharma USA. Innovation is a driving force for our company. As a result, we are continuously licensing and/or acquiring new products and solutions aimed at addressing the essential needs of consumers, patients, and healthcare partners.

Reporting directly to the Director, Information Technology. The IT Specialist, Analytics Infrastructure plays a key role in supporting how Medexus uses data. This position focuses on building and maintaining data pipelines, managing cloud-based data systems, and supporting reporting tools like Tableau. The specialist works with business stakeholders to ensure that data flows smoothly, is accurate, and is available for decision-making.

·        Use APIs to collect data from external platforms, ensuring secure authentication, efficient data retrieval, proper error handling, and integration with existing data systems

·        Build and manage ELT/ETL data pipelines using structured and semi-structured data formats, including pharmaceutical EDI files like 852/867

·        Create and maintain scalable data warehouse solutions to store and organize business data

·        Act as a technical lead for integrating and transforming data to meet business needs

·        Support Tableau and similar business intelligence tools, improving performance, usability, and providing technical assistance to the business analytics teams

·        Configure data systems and ensure accuracy through mapping and validation steps

·        Automate and document repeatable processes and reusable data components to streamline and support ongoing analytics work

·        Collaborate with teams in operations, finance, supply chain, and sales to support shared goals

·        Monitor pipeline health, fix data flow issues, and optimize performance

·        Follow company standards for data security, quality, and compliance

·        Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a similar field

·        At least 5 years of experience working on data pipelines, integration, or analytics infrastructure

·        Experience with the following systems or similar technologies:

·        Experience with pharmaceutical data formats such as EDI 852/867 is a plus

·        Skilled in using SQL queries and/or procedural languages to transform, load and query raw data sets

·        Skilled in working with data modeling techniques

·        Compensation range: $80,000- $140,000

We recognize that experience comes in many forms. Even if your background or compensation expectations don’t exactly align with all the qualifications or compensation range listed, we encourage you to apply. Your unique skills and experience may be a great fit for this role or other opportunities at Medexus.