Business Intelligence Developer

Job Description

The Specialist within Operational Enablement & Effectiveness (OEE) / MAP has experience in clinical operations and is responsible for the development of data analysis and visualizations in support of user needs across Global Clinical Trial Operations (GCTO) across our portfolio, studies & processes.

Primary responsibilities include but are not limited to:

• Creating analytical tools to answer critical business questions for GCTO

• Managing project timelines to enable accurate reporting and functionality during SDLC

• Managing diverse projects and processes within GCTO/OEE Teams.

• Champion data quality, integrity, and reliability by designing and promoting best practices.

• Lead business requirement sessions with BAs and stakeholders.

• Coordinate with IT/vendor on business requirements for new or enhancement reporting needs to support GCTO reporting.

• Test and deploy new capabilities using BI applications.

• Create new visualizations to enable informed business decisions on strategy and execution.

• Vendor relationship management ensuring business requirements are clearly articulated and executed.

• Provide BI training to BA/stakeholders to foster increased understanding and utilization of the information provided.

• Present complex data to non-technical end-users in a clear and concise manner.

• Design and develop rigorous data analyses and comprehensive data tools for internal stakeholders.

• Develop a deep understanding of the current state of available data sources and data tools; be able to determine enhancements needed based on OEE’s roadmap.

• Support business use cases based on existing Data & Analytics (D&A) products and link usage to business outcomes.

 

Education Requirements:

• BS (or higher) in Data Science, Computer Science, Management Information Systems

Required Experience & Skills:

• 2+ years of experience in Business Intelligence (BI) and Analytics using BI tools (Power BI)

• Experience in data management (Data analysis, Data architecture, Data Modeling)

• Experience with writing SQL and building complex queries

• Basic knowledge of AWS cloud services (S3, EC2, RDS, Redshift), Databricks, JIRA, Github

• Good organizational, time management and project management skills

• Experience in leveraging and managing third party vendors and contractors.

• Self-motivated, proactive, with ability to work independently with minimum direction.

• Good communication (written and oral) skills

• General knowledge of MS Office

Preferred Experience & Skills:

• Knowledge of Python and GenAI tools

• Ability to work both independently and collaboratively within a geographically dispersed team

• Ability to learn and use new technologies

• Ability to manage through complexity and ambiguity along with competing priorities.

• Basic knowledge of Clinical Development / Operations.

Required Skills:

Amazon Web Services (AWS), Business Decisions, Business Intelligence (BI), Clinical Development, Computer Science, Data Analysis, Data Visualization, Management Information Systems (MIS), Microsoft Power Business Intelligence (BI), Multi-Management, Requirements Management, Supplier Relationship Management, User Experience (UX) Design, Vendor Management, Vendor Management Systems (VMS)

Preferred Skills:

Current Employees apply HERE

Current Contingent Workers apply HERE

Search Firm Representatives Please Read Carefully 
Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company.  No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails. 

Employee Status:

Regular

Relocation:

No relocation

VISA Sponsorship:

No

Travel Requirements:

No Travel Required

Flexible Work Arrangements:

Hybrid

Shift:

Not Indicated

Valid Driving License:

No

Hazardous Material(s):

no

Job Posting End Date:

08/15/2026

*A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.