Data Engineer

Req ID #:  209751
Location: 

US Montreal (Senneville), Quebec, CA, H9X 3R3 Chicago, IL, US, 60654 Detroit, MI, US, 48201 Cleveland, OH, US, 44128 Newark, DE, US, 19711 Wilmington, MA, US, 01887

At Charles River, we are passionate about improving the quality of people’s lives. When you join our global family, you will help create healthier lives for millions of patients and their families. 

 

Charles River employees are innovative thinkers, who are dedicated to continuous learning and improvement. We will empower you with the resources you need to grow and develop in your career. 

 

As a Charles River employee, you will be part of an industry-leading, customer-focused company at the forefront of drug development. Your skills will play a key role in bringing life-saving therapies to market faster through simpler, quicker, and more digitalized processes. Whether you are in lab operations, finance, IT, sales, or another area, when you work at Charles River, you will be the difference every day for patients across the globe.

 

IMPORTANT:   In order to be considered for this position, a resume/CV must be uploaded and submitted during the application process.  Please make sure work history and education are added correctly.   


 

Job Summary

 

This role will work collaboratively, in a consultative way, across the business units and IT, building modern analytics solutions, supporting and mentoring engineering teams, as well as advising on best approaches to leveraging Azure in the most effective and efficient manner.  Interacts with senior level customers to consult on scalable enterprise analytics solutions that provide the business with a competitive advantage.

Note : Its a remote role - work from home

 

  • Design and build a modern data warehouse in the cloud.  Develops technical solutions to complex problems which require the regular use of ingenuity and creativity. 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 
    • Ingest data from all enterprise systems into a design that is fit for use
    • Utilize cloud computing experience, knowledge and skills
    • Utilize expertise in Microsoft Azure
    • Utilize deep knowledge and skill in extract, transform, load (ETL) design, development, and performance tuning on Microsoft SSIS in SQL Server 2012 and above in a multi-dimensional Data Warehousing environment

 

  • Data ingestion and modeling for digital customer platform
    • Ingest data across safety assessment business related to customer platform
    • Utilize methodologies in aggregating customer data from different applications, cleaning it, and analyzing it to get a reasonable picture of customer information and preferences
    • Utilize experience with ADF, ADLS, Data Bricks and SQL
    • Provide insights on data sets to business

 

  • 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
       

Job Qualifications

 

The following are minimum requirements related to the Data Engineer position.

  • Bachelor’s degree in Computer Engineering, Computer Science or related discipline, Master’s Degree preferred
  • 5+ years of ETL design, development, and performance tuning on Microsoft SSIS in SQL Server 2012 and above (2016 preferable) in a multi-dimensional Data Warehousing environment 
  • 5+ years of SSAS design, development, maintenance and performance tuning on Microsoft SQL Server 2012 and above (2016 preferable), with expert MDX and DAX skills
  • 5+ years of advanced SQL Programming: PL/SQL, T-SQL, U-SQL
  • 5+ years of Enterprise Data & Analytics solution architecture 
  • 2+ years of Power BI experience including mobile solutions
  • 2+ years of strong and extensive hands on experience in Azure, preferably data heavy / analytics applications leveraging relational and NoSQL databases, Data Warehouse and Big Data
  • An equivalent combination of education and experience may be accepted as a satisfactory substitute for the specific education and experience listed above
     

IMPORTANT: A resume is required to be considered for this position. If you have not uploaded your resume in your candidate profile, please return to upload field and attach your resume/CV. 
 

About Corporate Functions
The Corporate Functions provide operational support across Charles River in areas such as Human Resources, Finance, IT, Legal, Sales, Quality Assurance, Marketing, and Corporate Development. They partner with their colleagues across the company to develop and drive strategies and to set global standards. The functions are essential to providing a bridge between strategic vision and operational readiness, to ensure ongoing functional innovation and capability improvement.  

 

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 17,000 employees within 90 facilities in 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. And in 2019, revenue increased to $2.62 billion.
 

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 supported the development of ~85% of the drugs approved by the FDA in 2019.
 

Equal Employment Opportunity
Charles River Laboratories is an Equal Opportunity Employer - all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

 

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 crrecruitment_US@crl.com. 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 www.criver.com.


Job Segment: Biology, Biotech, Database, Data Warehouse, Cloud, Science, Technology