Drug Intelligence is a leading Canadian health care data market research company with a 30+ year history. We specialize in providing relevant information, data and insights about serious and complex diseases from various therapeutic areas to our clients in the pharmaceutical industry.

As a Data Analyst at Drug Intelligence, you will be joining a agile team in a working environment that embraces high quality standards, initiative, creativity, and collaboration.

Important: to be considered for this position, in addition to the LinkedIn application we require candidates to fill out a 2, step, 20-min survey. You will automatically receive a link (by email) to complete the cognitive assessment (step 2) within 5 min of submitting the Predictive Index Assessment (step 1).

Link to survey: https://assessment.predictiveindex.com/bo/5PWK/Drug-Intelligence-Data-Analyst

Salary: $70,000-75,000 annually

Key Position Responsibilities:

- Lead or manage data pipeline for various projects, including data cleaning, preparation, extract-transform-load (ETL), and data querying.
- Maintain and continuously upgrade existing relational database systems.
- Support the migration of on-premise database systems to cloud-based infrastructure.
- Design, develop, deploy, and maintain Microsoft Azure SQL Database and custom Python-based ETL processes as required.
- Write, maintain, improve, and upgrade existing and new data analysis scripts using SQL & Python.
- Translate business & project requirements into data requirements with autonomy.
- Extract,



structure and analyse important information from specific data sets.
- Collaborate with team members on multiple simultaneous projects.
- Contribute to new ideas and solutions.

Desired Experience:

- 1-2 years experience working as a Database Administrator, Data Analyst, Data Engineer or similar role.
- Bachelor’s or master’s degree in computer science/computer engineering or equivalent preferred.
- Strong understanding of data warehousing methodologies and ETL concepts.
- Strong knowledge of Python and SQL.
- Advanced data manipulation skills.
- Strong understanding of some, or all, of the following: Azure Data Factory, Databricks, Azure SQL Database.
- Strong project management and time management skills.
- Effective multidisciplinary problem-solving skills.
- Ability to work independently and as part of a team.
- Excellent communication skills, both written and verbal

What will you get out of this role?

- Exposure to and experience with a wide variety of tools (Azure cloud platform, Python, Tableau, Qualtrics, and more)
- Direct ownership over specific projects curated to your skillset (growing responsibility over time)
- Ability to work directly with cross-functional team members (including leadership)
- Strong analytical and problem-solving skills: You will learn to troubleshoot and solve complex data processing-related issues that arise in the day-to-day operations of the organization. This will help you build strong analytical and problem-solving skills.

📌 Data Analyst (Toronto)
🏢 Drug Intelligence
📍 Toronto