IT Specialist, Analytics Architecture

Medexus and Research Capital Corporation; Canada; On-site; CAD 80,000 - 140,000; Full time

Job summary

An established industry player is seeking an IT Specialist to enhance its analytics infrastructure. In this pivotal role, you will build and maintain data pipelines, manage cloud-based systems, and support business intelligence tools like Tableau. Collaborating with various teams, you'll ensure data accuracy and availability for informed decision-making. If you have a passion for data and a strong background in analytics, this opportunity offers a chance to make a significant impact in a dynamic environment. Join a forward-thinking company committed to innovation and excellence in healthcare.

Qualifications

• 5+ years of experience in data pipelines and analytics infrastructure.
• Strong skills in SQL and cloud-based data systems.

Responsibilities

• Build and manage ELT/ETL data pipelines for business data.
• Support and improve performance of Tableau and BI tools.

Skills

Data pipeline management

AWS services (RDS, Athena, Lambda)

SQL

Tableau

Java (Groovy)

Python

JavaScript

Apache NiFi

Data modeling techniques

Communication skills

Education

Bachelor’s degree in Computer Science

Degree in Information Systems

Degree in Data Analytics

Tools

Tableau

Power BI

Salesforce.com

Veeva

NetSuite

Apache NiFi

Rundeck

Job description

Company Bio:

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.

Role Overview

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.

Key Responsibilities

·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

Education, Experience & Skill Requirements

·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:

• AWS services: RDS (PostgreSQL), Athena, Lambda, and related tools
• Apache NiFi and Rundeck for job scheduling and automation
• Programming languages: Java (Groovy), Python, JavaScript
• CRM and financial data systems
• Familiarity with Salesforce.com, Veeva, or NetSuite is a plus
• Comfortable working with modern business intelligence tools like Tableau or Power BI
• Strong organizational, communication, and teamwork skills

·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

Additional Information:

·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.

Medexus Pharma is an equal employment opportunity employer. We adhere to a policy of making employment decisions without regard to race, color, religion, sex, sexual orientation, national origin, citizenship, age, disability or any other characteristic protected by law. We assure you that your opportunity for employment with Medexus Pharma depends solely on your qualifications.