Apply on Employer Site

Merck · 1 day ago

Senior Specialist, Business Intelligence - Procurement

North Wales, PA

Full-time

Hybrid

Mid, Senior Level

$94K/yr - $148K/yr

5+ years exp

Merck is a leading company focused on innovative healthcare solutions. The Senior Specialist, Business Intelligence - Procurement will leverage business intelligence to support procurement teams in making informed decisions, driving cost reduction initiatives, and automating reporting processes.

BiotechnologyHealth CareMedicalPharmaceutical

Comp. & Benefits

No H1B

Responsibilities

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

Qualification

SQLPythonData PipelinesData ModelingData VisualizationBusiness Intelligence (BI)Data AnalyticsFinancial AcumenPredictive AnalysisAnalytical ThinkingStrategic Procurement PlanningSupplier Performance EvaluationAgile MethodologiesStakeholder LiaisonData QualityGovernanceSecuritySAP AribaSAP S/4HANACommunicationProblem Solving

Required

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

clear lineage from source systems to dashboards

Strength in visual analytics (Power BI/QlikView)

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

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

clear written and verbal skills

able to translate technical findings into actionable recommendations for Procurement, Finance, and Operations

proven ability to collaborate with IT/data teams and procurement stakeholders

skilled in gathering requirements and documenting user stories

experience with data cleansing, validation, and building standardized metrics/definitions (e.g., savings, spend, compliance)

awareness of data governance, role-based access, and handling sensitive supplier/price data

demonstrated ability to prioritize, troubleshoot data issues, and deliver under deadlines

Analytical Thinking

Business Intelligence (BI)

Data Analytics

Data Modeling

Data Pipelines