Strategic Capabilities Analyst

Johnson & Johnson Johnson & Johnson · Pharma · Irvine, CA +1

The Strategic Capabilities Analyst role at Johnson & Johnson focuses on developing and implementing technical solutions and data-driven performance management capabilities within the Electrophysiology Supply Chain. Responsibilities include creating Python scripts for data analysis, designing PowerBI dashboards, managing SQL databases, developing automated reporting, building data pipelines, and performing root cause analysis. The role requires proficiency in Python, SQL, PowerBI, and an understanding of cloud computing, with basic machine learning and statistical analysis capabilities.

What you'd actually do

  1. Develop and implement Python-based data analysis scripts to support strategic process capabilities
  2. Design and maintain PowerBI dashboards to visualize key performance metrics for EP Supply Chain leadership
  3. Manage SQL databases and develop complex queries to extract, transform, and analyze performance data
  4. Act as a technical product manager to drive digital capability development within the supply chain strategy organization
  5. Develop automated reporting solutions using Python and SQL to streamline monthly executive leadership reporting

Skills

Required

  • Python
  • SQL
  • PowerBI
  • Data analysis
  • Database management
  • Cloud computing (Azure/AWS preferred)
  • Performance management tool configuration
  • Machine learning
  • Statistical analysis

Nice to have

  • Technical certifications in data analysis, cloud computing, or database management

What the JD emphasized

  • Require advanced technical skills to span multiple functional groups, processes, and analytical approaches
  • Proficiency in Python programming with demonstrated ability to develop data analysis scripts
  • Advanced SQL database management and query optimization skills
  • Expert-level PowerBI dashboard creation and data visualization