Merck
Senior Specialist, Business Intelligence - Procurement
Merck, North Wales, Pennsylvania, United States
Senior Specialist, Business Intelligence - Procurement
Join to apply for the Senior Specialist, Business Intelligence - Procurement role at Merck.
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/QlikView) 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.
Requirements (EEO) 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.
Location & Work Arrangement This role is based in the United States. Employees will work a hybrid model, working in office three days a week (Monday–Thursday, specific days may vary) and Friday remote, unless business critical tasks require on‑site presence. This model does not apply to field‑based, facility‑based, manufacturing‑based, or research‑based positions with required in‑person attendance, nor to roles designated as remote.
Compensation Salary range: $94,300.00 – $148,500.00. Annual bonus and long‑term incentive may apply. Benefits include medical, dental, vision, retirement (401(k)), paid holidays, vacation, and compassionate and sick days.
Additional Information Job posting end date: 01/5/2026. Apply through https://jobs.merck.com/us/en. U.S. candidates only for this position. Visa sponsorship not provided. Travel required: 25%.
#J-18808-Ljbffr
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/QlikView) 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.
Requirements (EEO) 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.
Location & Work Arrangement This role is based in the United States. Employees will work a hybrid model, working in office three days a week (Monday–Thursday, specific days may vary) and Friday remote, unless business critical tasks require on‑site presence. This model does not apply to field‑based, facility‑based, manufacturing‑based, or research‑based positions with required in‑person attendance, nor to roles designated as remote.
Compensation Salary range: $94,300.00 – $148,500.00. Annual bonus and long‑term incentive may apply. Benefits include medical, dental, vision, retirement (401(k)), paid holidays, vacation, and compassionate and sick days.
Additional Information Job posting end date: 01/5/2026. Apply through https://jobs.merck.com/us/en. U.S. candidates only for this position. Visa sponsorship not provided. Travel required: 25%.
#J-18808-Ljbffr