Sr. Data Engineer (DTJ)

Key Skills

Apache Hadoop, Apache Hive, Apache Kafka, Apache Pig, Azure Blob, Data Analytics, Data Lake, Databricks, ETL/ELT technologies, PLSQL, PySpark, Python Programming, Scala Programming, SPARK Programming, Spring Boot, SQL, Sqoop, Synapse, T-SQL

Job Description

There’s never been a more exciting time to be on the Enterprise Data Analytics team at Charles River Labs! We are on a mission to make the Enterprise Data Analytics team be the backbone of today’s business, as data-driven decision-making enables business leaders to make informed choices quickly to boost revenue, improve productivity, and stay a step ahead of the market. We have already launched our own Enterprise Data Hub, the digital backbone of this company, and we need more leaders in the data analytics discipline who are forward thinking, self-guided and innovative to continue to build out the hub across our lines of business, integrating all of our data, mastering data and focusing on data quality to fundamentally shift the way Charles River operates through data science and advanced analytics.

You will be joining a team with an unyielding dedication to the company purpose; Together We Create Healthier Lives. This laser focus on the patient makes the boarder Global Technology Team so exciting. As we look to our company’s future, we are embarking on a reimagination of how we do business through a Digital Journey. Our Digital Journey is about sustaining and advancing our position to unlock our next horizon of growth and become a leading ‘digitally-powered’ CRO enabling our clients to deliver innovative, safe, and effective treatments to patients as quickly and effectively as possible. In the process, we want to continue to be at the forefront of the drug development and discovery process, ultimately reducing the early-stage drug development timeline by a full year. Our collective focus over the coming, multi-year journey is to enable this extraordinary group of people - our 20,000 colleagues - to execute and achieve our ambitious business goals. We are taking Charles River to a place where Enterprise Data Analytics team will be applying the techniques of data management, data engineering, and strategy development, as well as the use of analytics techniques that range from forecasting and simulation to linear programming and optimization and we want you to join us.

Job Qualifications

Essential Qualifications / Requirements:

• 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
• 3+ 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
• 3+ years of experience with Azure Data Factory, Azure Data Lake Gen2, Azure Synapse Analytics, Azure Analysis Services, Azure Databricks, Blob Storage, Azure SQL Database, Cosmos DB, Azure App Service, Azure Logic Apps, and Azure functions.
• 2+ years of experience in defining and enabling data security standards for encryption, auditing, and monitoring.
• Strong analytical abilities and a strong intellectual curiosity

Preferred Skills:

• 2+ years of experience with Big Data Technologies such as: Hadoop, Sqoop, Hive, Kafka, Spark, Pyspark, Python, Scala, or Pig
• 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
• Knowledge of Dev-Ops processes (CI/CD) and infrastructure as code.
• Knowledge of Master Data Management (MDM) and Data Quality tools.
• Experience developing REST APIs using Java Spring Boot
• Experience with stream-processing systems: Event Hubs, Storm, Spark-Streaming, etc.

Compensation Data

The pay range for this position is $155,000 - $170,000 USD. Please note that salaries vary within the range based on factors including, but not limited to, experience, skills, education, certifications, and location.

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.