Job DescriptionReporting to the Executive Director, Innovation, Digital Enablement, and Analytical Solutions (IDEAS), the Senior Specialist role will support ECO by helping to build and enhance data-driven solutions with a focus on critical-to-compliance risk areas. This position is a hybrid role that sits at the intersection of technology and business and will be focused on supporting ECO-wide initiatives. The Senior Specialist partners with IDEAS team members and ECO stakeholders to understand business needs, translate them into technical requirements, and deliver well-tested solutions. Individuals in this role bring a strong technical foundation (data modeling, SQL, visualization software, various programming languages) and a desire to deepen their understanding of the business and compliance environment. The IDEAS team works in a collaborative model, with individuals contributing to projects from concept to deployment while learning new and emerging technologies to help mitigate company risk.
Technical Skills- Data cleaning, preparation and structuring to enable the analysis of information.
- Demonstratable proficiency in R and Python coding languages.
- Demonstratable experience working with large language models (LLMs).
- Able to write/understand a programming language (.Net, C#, Java, HTML)
- Intermediate to advanced ability to write SQL (Inner & Outer Joins, Linked Servers, Functions, Stored Procs, Case Statements) and Microsoft Fabric.
- Ability to independently learn and incorporate new and emerging technology & techniques (AI, ML, BOTs, NLP)
- Understand underlying theory and application of key reporting/visualization software.
- Evaluate data using analytical and logical reasoning for the discovery of insights.
Business Acumen- Demonstrate how technology can be leveraged to solve problems.
- Demonstrate an understanding of the company's business.
- Understand current industry trends impacting the business.
Storytelling- Understand the KPIs used to measure the business framework.
- Ability to articulate insights and explain their impact and opportunities on the business.
- Desire to grow technical and business knowledge through feedback, training, and hands-on work.
- Comfort working on tasks or projects that aren't always initially well defined, with guidance from senior team members.
- Ability to collaborate effectively across functions and incorporate stakeholder input into deliverables.
- Clear written and verbal communication skills, including the ability to explain technical concepts to non-technical audiences.
- Strong time management and organizational skills.
Project Management- Ability to organize work, manage tasks, and communicate status within a project team.
- Demonstrable ability to contribute to projects from concept to deployment, including requirements gathering, development, testing, and documentation.
- Ability to manage multiple tasks or workstreams with appropriate prioritization.
- Ability to work effectively in a fast-paced environment and meet deadlines.
Qualifications:- Required: BS/BA required
- Preferred: BS/BA or higher in one of the following areas: Computer Science, Math, Data Analytics, Management of Information Science
- 3-7 years of relevant experience (including internships, co-ops, or academic projects) in analytics, data engineering, software development, or a related technical field.
- SQL Server Management Studio (SSMS), Oracle, AWS, Azure
- SQL Integration Services (SSIS)
- Microsoft Power Platform (Power BI, Power Automate, Power Apps, Windows Forms)
- Visualization Tools (Power BI, Tableau, Qlik)
- Process automation (Power Automate, Blue Prism, UI Path)
- DataIKU, NLP Models
- Microsoft Fabric
- Ability to work independently and partner with stakeholders to understand needs and translate them into technical requirements and solutions
- Strong communication skills and ability to tailor messages for technical and non-technical audiences.
- Strong analytical & quantitative skills with the ability to develop and interpret data insights, document work clearly, and present results to stakeholders.
Preferred Experience and Skills:- Exposure to regulated industries (e.g., pharmaceutical/healthcare) or compliance-related work or enterprise data environments preferred.
- Exposure to working in a global environment or supporting multiple divisions, markets, and regions.
- Strong desire to learn the business, compliance processes, and how data-driven solutions can mitigate risk.
- Experience working with enterprise-wide systems and vendors (i.e., financial reporting, master data management, customer relationship management, expense management).
Required Skills: Audits Compliance, Audits Compliance, Compliance Program Development, Computer Science, Crisis Management, Customer Relationship Management (CRM), Data Modeling, Detail-Oriented, Emerging Technologies, Ethical Compliance, Financial Reports, Investigative Skills, Java (Programming Language), Legal Regulatory Compliance, Metrics Analysis, Microsoft Power Business Intelligence (BI), Microsoft SQL Server Management Studio (SSMS), Mitigated Risks, Oral Communications, Process Improvements, Programming Languages, Project Risk Assessments, Regulatory Affairs Management, Regulatory Reporting, Regulatory Training {+ 2 more}
Preferred Skills: Current Employees apply HERE
Current Contingent Workers apply HERE
San Francisco Residents Only: We will consider qualified applicants with arrest and conviction records for employment in compliance with the San Francisco Fair Chance Ordinance
Los Angeles Residents Only: We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance
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:VISA Sponsorship:Travel Requirements:Flexible Work Arrangements:Hybrid
Shift:Valid Driving License:Hazardous Material(s):Job Posting End Date:07/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. 
