Note: The job is a remote job and is open to candidates in USA. Underscore Marketing is a woman-owned, independent agency specializing in life sciences. The Data Analyst role supports pharmaceutical brand, commercial, and analytics teams by connecting healthcare data to media to drive actionable insights, requiring strong technical analytics skills and the ability to communicate findings effectively.
Responsibilities
- Perform extensive SQL-based data transformations, integrating data from multiple internal and external sources (e.g., claims, media, CRM, EHR-derived datasets)
- Define, validate, and govern metrics aligned to pharmaceutical business questions (e.g., brand performance, HCP engagement, patient journeys)
- Apply statistical reasoning to analyze trends, identify drivers of performance, and ensure analytical rigor in insights and recommendations
- Maintain and iterate on analytical datasets and workflows as new data is ingested
- Conduct thorough exploratory data analysis (EDA) to uncover patterns, anomalies, and opportunities within complex healthcare datasets
- Interpret and translate analytical findings into clear business insights, tailored for stakeholders across marketing, analytics, strategy, and leadership teams
- Manually scrub, structure, and normalize data as needed to ensure data quality and analytical readiness, particularly 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 decision-making
- Collaborate cross-functionally with data science, technology, media, strategy, and client-facing teams to align analyses with business needs
- Document methodologies, assumptions, and data limitations to support transparency and reproducibility
Skills
- Bachelor's degree in Analytics, Statistics, Mathematics, Data Science, Economics, or a related field
- Experience working with cloud data warehouses (e.g., Big Query)
- Strong proficiency in SQL, including complex joins, transformations, and performance optimization
- Solid foundation in statistics and analytical reasoning (e.g., trend analysis, hypothesis testing, segmentation)
- Demonstrated experience with exploratory data analysis and working with large, complex datasets
- Ability to simplify complex data and insights for diverse audiences
- Experience with data visualization tools (e.g., Tableau, Power BI, Looker, or similar)
- Proven ability to work collaboratively in cross-functional teams
- Experience working with pharmaceutical commercial or media data (e.g., claims, prescription, media, CRM, hub data)
- Familiarity with AI/ML concepts and data preparation requirements for modeling
- Experience using Python or R for analytics and data manipulation
- Understanding of pharma compliance, privacy, and data governance considerations
- Experience working in a remote setting, collaborating cross-functionally with individuals across teams and in different time zones
Company Overview