Data Analyst

Drug Intelligence; Toronto; On-site; CAD 70,000 - 75,000; Full time

Job summary

Drug Intelligence is hiring a Data Analyst in Toronto, Canada. You will join a team that emphasizes quality, initiative, creativity, and collaboration. The role involves data processing, extraction and analysis of datasets, and maintaining Azure-based data workflows.

The ideal candidate has 1–2 years of relevant experience, a CS/CE degree, and strong Python/SQL skills with knowledge of ETL and data warehousing. Experience with JotForm and Qualtrics is a plus.

Qualifications

• 1–2 years in data analysis or data engineering
• Bachelor's or master's in CS/CE or equivalent preferred
• Strong Python and SQL skills for data manipulation and analysis
• Understanding of data warehousing and ETL concepts
• Experience with Azure SQL or similar cloud databases
• Strong project and time management skills
• Excellent written and verbal communication
• Experience with data collection forms (JotForm, Qualtrics) is a plus

Responsibilities

• Validate and transform data for analysis
• Extract, structure, and analyze data sets for clients
• Maintain data processes using Python and T-SQL (Azure) and create new scripts
• Build and maintain data collection forms across platforms
• Translate business requirements into data requirements
• Work with data engineers on process improvements and automation
• Collaborate across teams on multiple projects

Skills

Python

SQL

Pandas

Azure

ETL

Data warehousing

JotForm

Qualtrics

Education

Bachelor's or master's in CS/CE

Tools

Azure SQL Database

Job description

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 dynamic team in a working environment that embraces high quality standards, initiative, creativity, and collaboration.

Salary: $70,000-75,000 annually

Key Position Responsibilities:

• Execute routine data processing tasks, including validation and transformation of data collected in a variety of formats into an analysis-ready format for other teams.
• Extract, structure, and analyze relevant information from specific data sets, both recurring and on an ad-hoc basis, to meet client needs.
• Own maintenance of existing data processes using Python and T-SQL (Azure): updating code to support new data elements and new analyses as requirements evolve and creating new data processing scripts as new projects arise.
• Build and maintain data collection forms across multiple platforms (e.g., JotForm, Qualtrics).
• Translate business and project requirements into data requirements with autonomy.
• Become a subject matter expert on existing processes and work closely with data engineers to identify and help design solutions for process improvement and automation.
• Collaborate with team members and cross-functionally on multiple simultaneous projects.

Desired Experience:

• 1-2 years of experience working as a Data Analyst, Data Engineer, or in a similar role, with strong foundational skills in Python and SQL.
• Bachelor's or master's degree in computer science, computer engineering, or equivalent preferred.
• Strong knowledge of Python (including Pandas) and SQL, especially for data manipulation and analysis.
• Strong understanding of data warehousing methodologies and ETL concepts.
• Experience with Azure SQL Database or a similar cloud database platform.
• Strong project management and time management skills.
• Effective multidisciplinary problem-solving skills.
• Ability to work independently and as part of a team.
• Excellent written and verbal communication skills.
• Experience with data collection forms (e.g., JotForm, Qualtrics) would be a plus.

What Will You Get Out of This Role?

• Exposure to and experience with a variety of tools across the Azure cloud platform, Python, and data collection platforms such as JotForm and Qualtrics, with future exposure to data visualization tools as your knowledge and responsibility grows.
• Direct ownership over projects based on your skill set, with growing responsibility and room to grow into a broader technical or subject-matter-expert role over time.
• The ability to work directly with cross-functional team members, including leadership.
• The chance to build strong analytical and problem-solving skills by troubleshooting real data processing issues that arise in day-to-day operations.