Senior Data Engineer

Req ID #:  67994

Wilmington, MA, US, 01887 US

For 70 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

We are seeking an experienced Senior Data Engineer for our IT Analytics Delivery Team. The position has remote work flexibility and is based out of Wilmington, MA.


There’s never been a more exciting time to be on the Analytics team at Charles River Labs! We are on an exciting journey to modernize the data landscape. If you are an engineer who enjoys cloud technologies, data warehousing, data analytics, and designing innovative analytical solutions, this job may be for you!


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!


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.


The following are responsibilities related to the Senior Data Engineer

  • Interacts with senior level customers to consult on scalable enterprise analytics solutions that provide the business with a competitive advantage.
  • Develops technical solutions to complex problems which require the regular use of ingenuity and creativity.
  • Design and build a modern data warehouse in the cloud
  • Design and build a customer 360
  • Implement a flexible and audible data pipeline
  • Enhance data collection procedures to build analytic systems.
  • Process, cleanse, and verify the integrity of data used for analysis.
  • Perform ad-hoc analysis and present results in a clear and user-friendly manner
  • Perform testing, resolve issues and automate unit tests.
  • Develop proof-of-concept (POC) solutions to help business units better visualize their business needs and to clarify requirements for development.

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

  • Bachelor’s degree in Computer Engineering, Computer Science or related discipline, Master’s Degree preferred
  • 7+ 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
  • 7+ years of advanced SQL Programming: PL/SQL, T-SQL
  • 5+ years of Enterprise Data & Analytics solution architecture
  • 2+ years of Power BI experience or Tableau Dashboards/Data Visualizations
    • (Mobile Dashboard experience nice to have)
  • 2+ years of experience with Azure Data Lake Gen2, Azure SQL Data Warehouse, Data Catalog, Azure Analysis Services, Databricks, Blob Storage, Azure SQL Database, Azure DNS, Virtual Network, Cosmos DB, Azure App Service, Azure Logic Apps, Power BI Premium, and Data Factory.
  • 2+ years of experience implementing Azure Data Solutions for high-availability, disaster recovery and global distribution.
  • 2+ years of experience in defining and enabling data security standards for encryption, auditing, and monitoring.
  • 2+ years of experience with Big Data Management (BDM) for relational and non-relational data (formats like json, xml, avro, parquet, copybook, etc.)
  • 2+ years of experience with setting up and operating data pipelines using Python or SQL


Strongly Desired:

  • 3+ years of SSAS design, development, maintenance and performance tuning on Microsoft SQL Server 2012 and above (2016 preferable), with expert MDX and DAX skills
  • 2+ years of experience with Big Data Technologies such as: Hadoop, Sqoop, Hive, Kafka, Spark, Pyspark, Python, Scala or Pig
  • Knowledge of Dev-Ops processes (CI/CD) and infrastructure as code.
  • Knowledge of Master Data Management (MDM) and Data Quality tools.
  • Strong analytical abilities and a strong intellectual curiosity

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 14,000 employees within 80 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 2018, revenue increased by 22% to $2.27 billion from $1.86 billion in 2017.


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 2018.


Equal Employment Opportunity 


Charles River Laboratories is an Equal Opportunity Employer - M/F/Disabled/Vet