SC Works IT Jobs

Job Information

Charles River Laboratories Sr. Data Engineer (DTJ) in Charleston, South Carolina

Sr. Data Engineer (DTJ)

Req ID #: 80577


Wilmington, MA, US, 01887Raleigh, NC, US, 27610USSaffron Walden, GB, CB10 1XLMattawan, MI, US, 49071Spencerville, OH, US, 45887Ashland, OH, US, 44805Horsham, PA, US, 19044Tranent, GB, EH33 2NECharleston, SC, US, 29407

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.

Job Summary

There’s never been a more exciting time to be on the Analytics team at Charles River Labs! Charles River Labs is on an exciting journey to modernize the data landscape, building a Customer 360, implementing new data standards, bringing to life the ‘art of the possible’ to our business partners, integrating with several new data sources, and ultimately building a brand-new Modern Data Warehouse in Azure. If you are an engineer who enjoys cloud technologies, data warehousing, data analytics, and designing innovative analytical solutions, this job may be for you! This role will work collaboratively, in a consultative way, across the business units and IT, supporting and mentoring engineering teams, as well as advising on best approaches to leveraging Azure in the most effective and efficient manner. The team is seeking top notch talent in the Microsoft Azure full data stack and modern data toolset. If you are interested in using your leadership, expertise and innovative skills to build something brand new, enjoy making architectural decisions, are a thought leader in the data space, have a passion for data and analytics, and like to mentor others, then we want to talk to you! A truly exciting and unique opportunity awaits you!

Job Qualifications

• 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 • 4+ 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• 4+ 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• Experience with Azure Data Lake, Azure SQL Data Warehouse, Data Catalog, Azure Analysis Services, Data Bricks, Storage Account Gen2, Azure SQL Database, Azure DNS, Virtual Network, DocumentDB, Azure App Service, Data Factory• Experience with Big Data Technologies such as: Hadoop, Sqoop, Hive, Kafka, Spark, Pyspark, Python, Scala or Pig• Experience designing and building cloud native applications as well as Azure Cloud migration experience• Experience with Azure IaaS and PaaS services• Experience with Big Data Management (BDM) for relational and non-relational data (formats like json, xml, avro, parquet, copybook, etc.)• PowerShell, Azure RunBook, and Azure DevOps experience• Experience with setting up and operating data pipelines using Python or SQL • Strong analytical abilities and a strong intellectual curiosity• Self-starter with the ability to work independently or as part of a project team • Capability to quickly conduct performance analysis, troubleshooting and remediation particularly in complex ETL mappings for SSAS• Strong knowledge of emerging technologies and tools• Strong organizational and time management skills• Effective collaboration of tasks across the business and technical teams• Proven and recent experience of implementing solutions from requirements gathering and process design to functional production deployment• Demonstrated ability to produce high quality deliverables

Preferred Skills

• Hands on experience with data virtualization technologies: CIS (Tibco), Denodo, or SQL 2019 Virtualization• Experience working with other public cloud technologies AWS, GCP • Excellent ability to communicate complex quantitative analysis in a clear, precise, and actionable manner with both technical and business stakeholders• Experience building test automation to ensure data quality and accuracy• Experience with any of the following scripting languages, R, SAS, JavaScript, Regex, PowerShell, shell scripting

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 - M/F/Disabled/Vet.

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