Specialist, Data Analysis

Merck Merck · Pharma · NJ

This role focuses on developing and delivering advanced analytic solutions for strategic decision-making within a large enterprise, specifically supporting various finance divisions. Responsibilities include documenting business requirements, supporting end-to-end analytics solution delivery (data modeling, predictive analytics, dashboards), building forecasting and scenario analysis models, ensuring analytical rigor, and working within agile methodologies. The role requires expertise in data analysis, financial modeling, and BI tools, with a strong emphasis on collaboration and decision quality.

What you'd actually do

  1. Document business requirements for data ingestion and curation, business process assumptions/changes, KPI definitions and, finally, user interface requirements.
  2. Support the delivery of end‑to‑end analytics solutions, including data modeling, semantic layer development, predictive analytics, dashboards, and self‑service capabilities.
  3. Build forecasting models, scenario analyses, profitability analytics, and performance management frameworks.
  4. Ensure analytical rigor, validation, and ongoing performance monitoring of models used across forecasting, commercial insights, and operational planning.
  5. Work within agile methodologies to drive transparency, responsiveness, and continuous improvement.

Skills

Required

  • Business Intelligence (BI)
  • Data Management
  • Data Modeling
  • Data Visualization
  • Measurement Analysis
  • Stakeholder Relationship Management
  • Waterfall Model
  • advanced data analysis
  • financial modeling
  • modern BI/analytics tools (Power BI, SQL, cloud analytics platforms, etc.)

Nice to have

  • business intelligence software
  • data transformation and orchestration techniques

What the JD emphasized

  • working effectively with business and technical team members will be critical
  • analytical rigor
  • validation
  • ongoing performance monitoring
  • compliance
  • privacy
  • SOX
  • governing financial controls