Senior Data Engineer
Senior Data Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 return well help you build a career that you can feel passionate about.
Job Summary
As aSenior 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 followingminimum qualifications for this role:
- Bachelors 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 Assessment
Charles 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 River
Charles 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 20000 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 clients 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 peoples 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.
Were 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.
Equal Employment Opportunity
Charles River is an equal opportunity employer and is committed to providing equal employment opportunities for all qualified applicants and employees without regard to race color sex religion national origin ancestry age mental or physical disability family status pregnancy military or veteran status or any other characteristic protected by federal state or local laws.
It is unlawful in some states (including Massachusetts) to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.
If you are interested in applying to Charles River Laboratories and need special assistance or an accommodation due to a disability to complete any forms or to otherwise participate in the resume submission process please contact a member of our Human Resources team by sending an e-mail message to This contact is for accommodation requests for individuals with disabilities only and cannot be used to inquire about the status of applications.
For more information please visit .
Required Experience:
Senior IC
Employment Type
Full Time
