Req ID #: 229551
Montreal, QC, CA;
Wilmington, MA, US
1st
Full time
For 75 years, Charles River employees have worked together to assist in the discovery, development and safe manufacture of new drug therapies. When you join our family, you will have a significant impact on the health and well-being of people across the globe. Whether your background is in life sciences, finance, IT, sales or another area, your skills will play an important role in the work we perform. In return, we’ll help you build a career that you can feel passionate about.

JOB SUMMARY

As a Senior Data Engineer for our Enterprise Data Analytics team. Your role will be key in integrating, mastering, and ensuring the quality of our data across all business functions, ultimately transforming how Charles River operates through data science and advanced analytics. You will be joining a team that is deeply committed to our purpose: Together We Create Healthier Lives. This unwavering focus on patients makes our global technology team uniquely inspiring. As we look to the future, we reimagine how we do business through our Digital Journey.

In this role, primary responsibilities include:

• Design and build a modern data warehouse in the cloud and develops technical solutions to complex problems;
• Develop proof-of-concept (POC) solutions to help business units better visualize their business needs and to clarify requirements for development;
• Work with Business Technology Partners to understand business problems;
• Provide recommendations to business via analytics consulting services;
• Data ingestion and modeling for digital customer platform;
• Perform ad-hoc analysis and present results in a clear and user-friendly manner. Perform testing, resolve issues, and automate unit tests. Process, cleanse, and verify the integrity of data used for analysis.
• Conduct data profiling and cleansing as needed for each data source;
• Build code using skills in advanced SQL Programming: PL/SQL, T-SQL, U-SQL, that automates data validation;
• Review reports with results of data profiling on any new data source for business consumption.

KEY ELEMENTS

We are looking for the following minimum qualifications for this role:

• Bachelor’s degree in Computer Engineering, Computer Science, or any related discipline;
• 7+ years of experience in ETL design, development, and performance tuning using the Microsoft BI Stack in a multi-dimensional data warehousing environment;
• 7+ years of advanced SQL programming expertise (PL/SQL, T-SQL);
• 5+ years of experience in Enterprise Data & Analytics solution architecture;
• 3+ years of experience in Python Programming;
• 3+ years of hands-on experience with Azure, especially for data-heavy/analytics applications leveraging relational and NoSQL databases, Data Warehousing, and Big Data solutions;
• 3+ years of experience with key Azure services: Azure Data Factory, Data Lake Gen2, Analysis Services, Databricks, Blob Storage, SQL Database, Cosmos DB, App Service, Logic Apps, and Functions;
• 2+ years of experience designing data models aligning with business requirements and analytics needs.

Role Specific Information:

• Location: Remote (from one of our Canadian sites);
• Annual bonus based on performance;
• Schedule: Daytime between Monday and Friday;
• Permanent position as of the hiring, full-time 37.5hrs per week.

Why Charles River ?

• Competitive benefits as of the hiring. We pay up to 85% of premiums (health & dental coverage);
• Employee and family assistance program;
• Excellent welcome program for new employees as well as in-house advancement and career development opportunities;
• Access to a doctor and various health professionals (telemedicine);
• 4 weeks’ Vacation & 10 Personal day policy;
• Many social activities!

If you are interested in contributing to the well-being of our communities, not only across the country but around the world, please join us. This is Your Moment.
About Safety AssessmentCharles River is committed to helping our partners expedite their preclinical drug development with exceptional safety assessment services, state-of-the-art facilities and expert regulatory guidance. From individual specialty toxicology and IND enabling studies to tailored packages and total laboratory support, our deeply experienced team can design and execute programs that anticipate challenges and avoid roadblocks for a smooth, efficient journey to market. Each year approximately 300 investigational new drug (IND) programs are conducted in our Safety Assessment facilities.
About Charles RiverCharles River is an early-stage contract research organization (CRO). We have built upon our foundation of laboratory animal medicine and science to develop a diverse portfolio of discovery and safety assessment services, both Good Laboratory Practice (GLP) and non-GLP, to support clients from target identification through preclinical development. Charles River also provides a suite of products and services to support our clients’ clinical laboratory testing needs and manufacturing activities. Utilizing this broad portfolio of products and services enables our clients to create a more flexible drug development model, which reduces their costs, enhances their productivity and effectiveness to increase speed to market.
With over 20,000 employees within 110 facilities in over 20 countries around the globe, we are strategically positioned to coordinate worldwide resources and apply multidisciplinary perspectives in resolving our client’s unique challenges. Our client base includes global pharmaceutical companies, biotechnology companies, government agencies and hospitals and academic institutions around the world.
At Charles River, we are passionate about our role in improving the quality of people’s lives. Our mission, our excellent science and our strong sense of purpose guide us in all that we do, and we approach each day with the knowledge that our work helps to improve the health and well-being of many across the globe. We have proudly worked on 80% of the drugs approved by the U.S. Food and Drug Administration (FDA) in the past five years.
We’re committed to providing benefits that elevate your quality of life. Based on your position these may include: bonus/incentives based on performance, 401K, paid time off, stock purchase program, Health and wellness coverage, employee and family wellbeing support programs, and work life balance flexibility.

In this role, primary responsibilities include:

• Design and build a modern data warehouse in the cloud and develops technical solutions to complex problems;
• Develop proof-of-concept (POC) solutions to help business units better visualize their business needs and to clarify requirements for development;
• Work with Business Technology Partners to understand business problems;
• Provide recommendations to business via analytics consulting services;
• Data ingestion and modeling for digital customer platform;
• Perform ad-hoc analysis and present results in a clear and user-friendly manner. Perform testing, resolve issues, and automate unit tests. Process, cleanse, and verify the integrity of data used for analysis.
• Conduct data profiling and cleansing as needed for each data source;
• Build code using skills in advanced SQL Programming: PL/SQL, T-SQL, U-SQL, that automates data validation;
• Review reports with results of data profiling on any new data source for business consumption

We are looking for the following minimum qualifications for this role:

• Bachelor’s degree in Computer Engineering, Computer Science, or any related discipline;
• 7+ years of experience in ETL design, development, and performance tuning using the Microsoft BI Stack in a multi-dimensional data warehousing environment;
• 7+ years of advanced SQL programming expertise (PL/SQL, T-SQL);
• 5+ years of experience in Enterprise Data & Analytics solution architecture;
• 3+ years of experience in Python Programming;
• 3+ years of hands-on experience with Azure, especially for data-heavy/analytics applications leveraging relational and NoSQL databases, Data Warehousing, and Big Data solutions;
• 3+ years of experience with key Azure services: Azure Data Factory, Data Lake Gen2, Analysis Services, Databricks, Blob Storage, SQL Database, Cosmos DB, App Service, Logic Apps, and Functions;
• 2+ years of experience designing data models aligning with business requirements and analytics needs

Role Specific Information:

• Location: Remote (from one of our Canadian sites);
• Annual bonus based on performance;
• Schedule: Daytime between Monday and Friday;
• Permanent position as of the hiring, full-time 37.5hrs per week