Sr. Analytics Engineer- Power BI Developer (DTJ)

Req ID #:  214053


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 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 18,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.


Essential Responsibilities
•Designs, documents, administers and maintains SSAS cubes (both DAX and MDX) from dimensional models
•Implementation of data governance through the use of SSAS meta-data layers in cubes (both DAX and MDX)
•Implementation of pixel-perfect reports in SSRS
•Mobile Analytic solutions in Power BI
•Implement, decide and document UX data visualization standards
•Extract complex data from multiple sources into usable and meaningful reports and analyses
•Mentor and support other Developers and business partners
•Create and maintain detailed documentation for development team 
•Support user community on data analytics 
•Perform training and knowledge transfer of technology 
•Provides ongoing performance monitoring and tuning, and automation of production activities related the BI environment
•Works in conjunction with business analysts and other users acting as a liaison between technical and business departments in developing dashboards and other BI related solutions. 
•Analyze existing complex systems to understand and document data elements, relationships, data flow, dependencies and their related interfaces
•Perform Unit testing and resolve defects

Job Qualifications

•Bachelor’s Degree in Computer Science (or related field), Master’s degree preferred
•7 years of experience in data analytics    
•At least 5 years of SSAS design, development, maintenance and performance tuning on Microsoft SQL Server 2012 and above (2016 preferable), with expert DAX skills
•3+ years of Power BI experience including mobile solutions
•5+ years of advanced SQL Programming: PL/SQL, T-SQL, U-SQL
•2+ years of ETL design and development on Microsoft SSIS in SQL Server 2012 and above (2016 preferable) in a multi-dimensional Data Warehousing environment 
•5+ years of Enterprise Data & Analytics solution architecture 
•2+ years of experience in Azure, preferably data heavy / analytics applications leveraging relational and NoSQL databases, Data Warehouse and Big Data
•Experience building analytics solutions for self-service
•Experience with UX Design  / Data Visualization strongly preferred
•Experience with dimensional data modeling 
•Excellent verbal and written communication skills
•Experience with Hadoop tools including sqoop, Spark, and Hive
•Ability to manage multiple efforts concurrently
•Strong problem-solving skills
•Strong knowledge of emerging technologies and tools
•Strong organizational and time management skills
•Effective collaboration of tasks across the business and technical teams
•Able to work quickly and under tight delivery deadlines with focus on details 
•Interface with key customers from all functional areas - Analytic skills are needed
•Proven and recent experience of implementing solutions from requirements gathering and process design to functional production deployment
•Demonstrated ability to produce high quality deliverables
•Possesses strong business acumen, with ability to assist in development of business requirements definitions
•Ability to establish and maintain positive and effective work relationships with management, coworkers, and business users
•An equivalent combination of education and experience may be accepted as a satisfactory substitute for the specific education and experience listed above.

Compensation Data

The pay range for this position is $121,673-$155,000. 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.  

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 20,000 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 client’s 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 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 86% of the drugs approved by the FDA in 2021.

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

Job Segment: Pharmaceutical, Solution Architect, SQL, Database, Laboratory, Science, Technology