Clinical Data Analyst in Markham, Ontario

Astellas Canada

At Astellas, we strive to become a cutting-edge, value-driven life science innovator. This means working at the forefront of healthcare change to turn innovative science into VALUE for patients.

What sets us apart is our focus on patients, our pioneering innovation, our collaborative culture, and the passion of our talented people.

Making a positive impact on patients’ lives is the purpose behind everything we do. At Astellas, we are relentless in our pursuit of scientific progress and in tackling unmet medical needs, demonstrated by our legacy in oncology, overactive bladder and transplant and our impressive pipeline in women’s health, blindness and regeneration, genetic regulation, immuno-oncology, mitochondria and targeted protein degradation.

About Us

We are a global pharmaceutical company headquartered in Japan, with a team of more than 14,000 managing operations in approximately 70 countries around the world. We are in the Top 30 global biopharma company based on global revenues and are predicted to be one of the Top 10 Cancer Drug Makers of 2024 by Fierce Pharma.

In Canada, we are growing to meet the exciting opportunities realized by our legacy brands and rich pipeline of innovative treatments.

We are looking for candidates who will thrive in our entrepreneurial and empowering environment where talent and leadership flourish. Do your values align with our Astellas Way – patient focus, ownership, results, openness, and integrity? Then we would love to hear from you.

From the first day in role, everyone at Astellas has a responsibility for creating a brighter future for patients around the world. We nurture exceptional relationships with our employees to allow them to thrive, foster innovation, and deliver exceptional business results. We work to create a culture where our people feel empowered to pursue brave ideas and ambitious outcomes, to have the confidence to be accountable for a higher standard of performance and embody a competitive and solutions-oriented mindset.

Our expertise, science and technology make us a pharma company. Our open and diverse culture is what makes us uniquely Astellas.

Astellas Pharma Canada (APCA) is currently searching for a Clinical Data Analyst.

Description:

This role will be responsible for the internal real-world data (RWD) conversion to the OMOP Common Data Model, which includes developing specifications, implementing the conversion process, and ensuring quality control. The individual will actively engage in data handling and troubleshooting, demonstrating strong communication skills and a sense of accountability for assigned tasks.

Essential Job Duties:

• To participate in the design and implementation of the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) ETL conversions.

• To establish source data QC process standards before OMOP conversion and to ensure the conversion is compliance with OMOP transformation and quality standards.

• Create, maintain, and implement quality documentations, such as ETL specifications.

• To communicate with end users in a timely manner regarding data refresh schedule and status.

• Work closely with the data engineering team to ensure conversions and ETL processes are completed according to schedule.

• Collaborate with the team to identify automation opportunities for improved efficiency in OMOP data conversion and applications using OMOPed data.

• Assist with the planning of OMOP activities and provide inputs for project plans.

• Ensure proper documentation of user stories in the correct priority order.

• Actively participate in Scrum Agile meetings, including backlog grooming and daily stand-ups.

• Engage actively in the OHDSI community.

Required Qualifications:

• Minimum of 5 years experience in SQL, ETL, and data handling experience

• Mastery over the OMOP CDM data structure.

• Advanced expertise with SQL statements.

• Ability to document vocabulary mappings and transformations for OMOP ETL development.

• Experience with OHDSI datasets and vocabularies. Familiarity with tools such as Atlas, Prometheus, Rabbit in a Hat, and White Rabbit is a plus.

• Knowledge of ETL processes and databases.

• Familiarity with scheduled jobs, batch procedures, and data pipelines.

• Familiarity with Redshift databases and the AWS environment.

• Ability to interpret high-level business requirements, collaborate with the product team and stakeholders, conduct research, and produce design documents and solution architecture.

• Knowledge of medical and pharmaceutical patient-level data and good amount of experience of working with it.

• Familiar with standard clinical lexicons, coding systems and ontologies

Preferred Qualifications:

• Minimum of 3 years’ experience OMOP AND SQL, ETL, data handling

• Hands-on experience with data warehousing programming languages, such as Python and Scala.

• Data engineering and data architecture experience in optimizing big data pipelines and ETL solutions.

• Knowledge of data standardization and data quality control.

• Familiarity with Agile development methodology and tools.

• Experience with relational database management systems (RDBMS) such as SQL Server.

• Familiar with Real-World Evidence (RWE) and outcome research workflow.

• Ability to collaborate and work effectively with cross-functional teams in a fast-paced agile environment.

• Enjoy problem-solving and possess resourcefulness to find answers and solutions for technical

Working Environment

At Astellas we recognize the importance of work/life balance, and we are proud to offer a hybrid working solution allowing time to connect with colleagues at the office with the flexibility to also work from home. We believe this will optimize the most productive work environment for all employees to succeed and deliver. Hybrid work from certain locations may be permitted in accordance with Astellas’ Responsible Flexibility Guidelines.

Additional Information

Astellas Pharma Canada welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the hiring process.

Astellas Pharma Canada requires full Vaccination against COVID-19 as a condition of employment. Reasonable accommodation to this policy may be granted for a valid accommodation request under human rights legislation.

No telephone inquiries, in-person applications, or agencies please. While we appreciate all applications, only candidates under consideration will be contacted.

Category BoldX

Astellas is committed to equality of opportunity in all aspects of employment.

EOE including Disability/Protected Veterans