Data Analyst II

Thermo Fisher Scientific; Alberta; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company in pharmaceutical manufacturing seeks a Data Analyst II to support ETL and SQL development. The role involves managing database integrity, developing algorithms for data analysis, and ensuring compliance with US privacy regulations. Ideal candidates will have expertise in SQL and experience with EMR systems. Join a team dedicated to enhancing healthcare data analytics.

Qualifications

• Experience with EMR systems or similar data.
• Experience managing SQL servers and migrating to AWS.

Responsibilities

• Ensure weekly EHR data updates are completed and correctly loaded into databases.
• Develop automated quality assurance functions for incoming data.
• Maintain data documentation and database security.

Skills

SQL

Analytical

Problem-solving

Education

Bachelor’s degree in computer science

Tools

SAS

R

Python

Job description

Join to apply for the Data Analyst II role at Thermo Fisher Scientific.

Work Schedule

Standard (Mon-Fri)

Environmental Conditions

Office

About Vestrum

Vestrum is part of the Specialty EMR data division of CorEvitas, collecting Electronic Health Record data from medical practices across the US for detailed analysis of drug use and outcomes. This real-world evidence is developed by Vestrum analysts and used by researchers and pharmaceutical companies.

Vestrum currently receives data from various physician practices, expanding in size and complexity. Data sources vary in layout, content, and labeling, including both standard and text fields. We continually enhance our dataset by expanding existing data points and curating new ones from multiple sources.

Requirements

Vestrum seeks a Data Analyst to support ETL and SQL development within our database team, aiding in the development of real-world evidence for medical and pharmaceutical use. Responsibilities include sourcing new data, building ETL processes, and developing algorithms for effective data analysis. The role also involves maintaining database integrity, security, and performance, and managing operational staff.

Your responsibilities will include :

1. Ensure weekly EHR data updates are completed and correctly loaded into databases
2. Standardize unstructured data, including PDF files, into structured formats
3. Develop automated quality assurance functions for incoming data
4. Merge longitudinal patient data and manage tokenization projects
5. Maintain mapping tables for analysts
6. Link and transform patient activity data into standardized outputs
7. Maintain data documentation and database security
8. Ensure compliance with US privacy regulations
9. Manage database space and monitor performance
10. Distribute weekly and monthly reports
11. Maintain relations with data suppliers

Your key strengths include :

1. Expertise in SQL
2. Experience with EMR systems or similar data
3. Proficiency in SAS, R, or Python
4. Strong analytical and system knowledge
5. Problem-solving abilities

Additional Experience and Qualifications

1. Experience managing SQL servers and migrating to AWS (AWS experience not required)
2. Experience integrating new data sources
3. Problem-solving and troubleshooting skills
4. Knowledge of healthcare data and pharma industry is a plus
5. Bachelor’s degree in computer science or similar
6. Seniority level : Not Applicable
7. Employment type : Full-time
8. Job function : Production, Supply Chain, and Manufacturing
9. Industries : Pharmaceutical Manufacturing and Biotechnology Research

Referrals increase your chances of interviewing at Thermo Fisher Scientific by 2x.

Get notified about new Data Analyst jobs in Alberta, Canada.