Data Analyst, Pharmaceutical Industry

Data Analyst, Pharmaceutical Industry

Company: Underscore Marketing | Reports to: VP, Strategic Solutions

Employment Type: Full-time, W2 Employee | Location: 90% Remote (US-based, East Coast preferred) | Travel: Up to 10% domestic travel annually for company events

Role Overview

We're seeking a detail-oriented Data Analyst to support pharmaceutical brand, commercial, and analytics teams by connecting healthcare data to media insights that drive clear, actionable business decisions. You'll play a critical technical role translating complex data into compelling narratives for both technical and non-technical stakeholders. This position requires strong analytical expertise, statistical thinking, and the ability to work collaboratively with imperfect, complex data structures to enable advanced analysis, including AI and machine learning applications.

Key Responsibilities

• Perform extensive SQL-based data transformations, integrating data from multiple internal and external sources (claims, media, CRM, EHR-derived datasets)
• Define, validate, and govern metrics aligned to pharmaceutical business questions including brand performance, HCP engagement, and patient journeys
• Apply statistical reasoning to analyze trends, identify performance drivers, and ensure analytical rigor in insights and recommendations
• Conduct thorough exploratory data analysis (EDA) to uncover patterns, anomalies, and opportunities within complex healthcare datasets
• Maintain and iterate on analytical datasets and workflows as new data is ingested and requirements evolve
• Interpret and translate analytical findings into clear business insights, tailored for diverse stakeholders across marketing, analytics, strategy, and leadership
• Manually scrub, structure, and normalize data to ensure quality and analytical readiness for deep-dive analyses
• Prepare datasets to support advanced analytics, including exploratory and explanatory machine learning techniques, ensuring accuracy, consistency, and scalability
• Develop data visualizations and dashboards that clearly communicate insights and support data-driven decision-making
• Collaborate cross-functionally with data science, technology, media, strategy, and client-facing teams to align analyses with business objectives
• Document methodologies, assumptions, and data limitations to support transparency and reproducibility

Required Qualifications

• Bachelor's degree in Analytics, Statistics, Mathematics, Data Science, Economics, or related field
• 2-4 years of professional experience defining and validating metrics in pharmaceutical, healthcare, or life sciences environments
• Strong proficiency in SQL, including complex joins, transformations, and performance optimization
• Demonstrated experience with cloud data warehouses (e.g., BigQuery)
• Solid foundation in statistics and analytical reasoning (trend analysis, hypothesis testing, confidence intervals)
• Experience with data visualization tools and creating actionable dashboards
• Excellent written and verbal communication skills; ability to explain technical concepts to non-technical audiences
• Strong attention to detail and commitment to data quality and accuracy
• Collaborative mindset with ability to work effectively across cross-functional teams

Preferred Qualifications

• Familiarity with Python or R for statistical analysis
• Experience with healthcare or pharmaceutical marketing analytics
• Knowledge of healthcare datasets (claims, EHR, patient registries)
• Exposure to machine learning concepts and applications

💰 Compensation not publicly listed. Market estimate for similar roles: from $85K, varying by experience and location.