Senior Specialist, Business Intelligence - Procurement

Job Description

You make data matter—by enabling Procurement teams to act faster, negotiate smarter, and realize savings with confidence. The Sr. Specialist, Business Intelligence Analyst- Procurement will understand the business impacts behind procurement decisions and know how to leverage business intelligence—combining data, technology, and domain expertise—to drive cost reduction initiatives. You’ll reduce manual reporting through automation, improve decision speed and quality, and help the team adopt data-driven ways of working, translating insights into realized savings.

 What you’ll do:

• Lead feasibility analysis for automation and analytics opportunities—frame the business problem, quantify potential savings, and validate realized impact.
• Design and build scalable datasets and pipelines (ETL/ELT) in the datalake/lakehouse to power self-service analytics and repeatable insight products.
• Own use cases end to end: gather requirements, create rapid prototypes, deliver production-ready solutions, and document standards for each automation journey.
• Generate actionable insights that drive category strategies, improve supplier performance, and strengthen stakeholder/supplier interactions.
• Define and standardize procurement KPIs (savings, spend, compliance, PPV), ensuring consistent measurement and transparent lineage from source to dashboard.
• Balance long-term programs with ad hoc requests, delivering quick, high-quality analyses without sacrificing data quality, governance, or accuracy.
• Collaborate across IT, Procurement, Finance, and Operations—translate technical concepts for non-technical audiences and ensure solutions align to business goals.
• Stay hands-on and agile—continuously learn, iterate, and do what’s needed to deliver outcomes.

What you’ll bring:

• Practical fluency in SQL and Python; experience building robust data pipelines in datalake/lakehouse architectures (e.g., PySpark/ETL).
• Strong data modeling skills (star/snowflake), data quality and governance practices, and clear lineage from source systems to dashboards.
• Strength in visual analytics (Power BI/Tableau) with storytelling that makes complex findings immediately actionable for business stakeholders.
• Comfort working in Agile environments (Jira/Confluence), iterating requirements, and shipping value early and often.
• Procurement domain familiarity: category management, supplier performance, e-auctions, preferred suppliers, and savings measurement.
• Nice to have: exposure to SAP S/4HANA, Ariba, Databricks/Azure, CI/CD, or basic ML for predictive insights (e.g., demand/spend forecasting, anomaly detection).

Education and experience:

• Bachelor’s degree in Computer Science, Management Information Systems, Business Analytics/Informatics, Engineering, or a related field
• 5–7+ years of experience in BI/analytics within procurement, supply chain, or finance.
• Analytics expertise: spend analysis, supplier performance analysis, cost/price variance analysis, savings tracking; comfortable with basic statistics and trend analysis.
• Business acumen: understanding of procurement and finance processes (RFQ/RFP, sourcing, category management, contract lifecycle) and  spend and savings reporting.
• Communication: clear written and verbal skills; able to translate technical findings into actionable recommendations for Procurement, Finance, and Operations.
• Stakeholder liaison: proven ability to collaborate with IT/data teams and procurement stakeholders; skilled in gathering requirements and documenting user stories.
• Data quality: experience with data cleansing, validation, and building standardized metrics/definitions (e.g., savings, spend, compliance).
• Governance and security: awareness of data governance, role-based access, and handling sensitive supplier/price data.
• Problem solving: demonstrated ability to prioritize, troubleshoot data issues, and deliver under deadlines.

Required Skills:

Analytical Thinking, Business Intelligence (BI), Data Analytics, Data Modeling, Data Pipelines, Datasets, Data Visualization, Financial Acumen, Strategic Procurement Planning, Supplier Performance Evaluation

Preferred Skills:

Predictive Analysis, SAP Ariba, SAP S/4HANA

Current Employees apply HERE

Current Contingent Workers apply HERE

US and Puerto Rico Residents Only:

Our company is committed to inclusion, ensuring that candidates can engage in a hiring process that exhibits their true capabilities. Please click here if you need an accommodation during the application or hiring process.

As an Equal Employment Opportunity Employer, we provide equal opportunities to all employees and applicants for employment and prohibit discrimination on the basis of race, color, age, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability status, or other applicable legally protected characteristics.  As a federal contractor, we comply with all affirmative action requirements for protected veterans and individuals with disabilities.  For more information about personal rights under the U.S. Equal Opportunity Employment laws, visit:

EEOC Know Your Rights

EEOC GINA Supplement​

We are proud to be a company that embraces the value of bringing together, talented, and committed people with diverse experiences, perspectives, skills and backgrounds. The fastest way to breakthrough innovation is when people with diverse ideas, broad experiences, backgrounds, and skills come together in an inclusive environment. We encourage our colleagues to respectfully challenge one another’s thinking and approach problems collectively.

Learn more about your rights, including under California, Colorado and other US State Acts

U.S. Hybrid Work Model

Effective September 5, 2023, employees in office-based positions in the U.S. will be working a Hybrid work consisting of three total days on-site per week, Monday - Thursday, although the specific days may vary by site or organization, with Friday designated as a remote-working day, unless business critical tasks require an on-site presence.This Hybrid work model does not apply to, and daily in-person attendance is required for, field-based positions; facility-based, manufacturing-based, or research-based positions where the work to be performed is located at a Company site; positions covered by a collective-bargaining agreement (unless the agreement provides for hybrid work); or any other position for which the Company has determined the job requirements cannot be reasonably met working remotely. Please note, this Hybrid work model guidance also does not apply to roles that have been designated as “remote”.

The salary range for this role is

$94,300.00 - $148,500.00

This is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting. An employee’s position within the salary range will be based on several factors including, but not limited to relevant education, qualifications, certifications, experience, skills, geographic location, government requirements, and business or organizational needs.

The successful candidate will be eligible for annual bonus and long-term incentive, if applicable.

We offer a comprehensive package of benefits.  Available benefits include medical, dental, vision healthcare and other insurance benefits (for employee and family), retirement benefits, including 401(k), paid holidays, vacation, and compassionate and sick days. More information about benefits is available at https://jobs.merck.com/us/en/compensation-and-benefits.

You can apply for this role through https://jobs.merck.com/us/en (or via the Workday Jobs Hub if you are a current employee). The application deadline for this position is stated on this posting.

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:

No relocation

VISA Sponsorship:

No

Travel Requirements:

25%

Flexible Work Arrangements:

Hybrid

Shift:

1st - Day

Valid Driving License:

Yes

Hazardous Material(s):

N/A

Job Posting End Date:

01/5/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.