Senior Specialist, Business Intelligence – Procurement
MSD
full-time
Posted on:
Location Type: Hybrid
Location: North Wales • New Jersey, Pennsylvania • 🇺🇸 United States
Visit company websiteSalary
💰 $94,300 - $148,500 per year
Job Level
Senior
Tech Stack
AzureETLPySparkPythonSQL
About the role
- 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.
Requirements
- 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.
- 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).
Benefits
- medical, dental, vision healthcare and other insurance benefits (for employee and family)
- retirement benefits, including 401(k)
- paid holidays
- vacation
- compassionate and sick days
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLPythonETLELTdata modelingdata qualitydata governancevisual analyticsstorytellingpredictive insights
Soft skills
collaborationcommunicationagilityproblem-solvingstakeholder managementanalytical thinkingadaptabilityattention to detailtime managementcreativity