Data Analyst, Pharmaceutical Industry

Job Description: Data Analyst, Pharmaceutical Industry
Reports to: VP, Strategic Solutions
Job Details: 90% remote position for US FT Perm W2 employee
Travel Requirements: up to 10% domestic travel each year for company events and socials
Time Zone Preference: US East Coast

Role Overview:

The Data Analyst supports pharmaceutical brand, commercial (marketing), and analytics teams by playing a critical technical role connecting healthcare data to media to drive clear, actionable insights. This role requires strong technical analytics skills, rigorous statistical thinking, and the ability to communicate findings in a simple, compelling way to both technical and non-technical stakeholders within the company. The ideal candidate is articulate, collaborative, detail-oriented, and comfortable working with imperfect data and 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 (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.

Required Qualifications:
•Bachelor’s degree in Analytics, Statistics, Mathematics, Data Science, Economics, or a related field.
•Experience working with cloud data warehouses (e.g., Big Query).
•2-4 years of experience defining and validating metrics in a pharmaceutical, healthcare, or life sciences environment.
•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.

Preferred Qualifications
•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.

Key Competencies
•Analytical rigor and attention to detail
•Business-oriented problem solving
Clear and concise communication
Comfort working with ambiguous or imperfect data
•Curiosity and continuous learning mindset
•Collaboration and teamwork

 Why Join Us?
At Underscore Marketing, we value our team and invest in their success. We offer competitive compensation and benefits, including health coverage, retirement plans, paid time off, and professional growth opportunities. Our goal is to ensure you feel supported both personally and professionally while contributing to meaningful work in a dynamic, collaborative environment.

Underscore Marketing is a woman-owned, independent agency specializing in life sciences. Since 2002, we've helped clients gain a competitive edge through bold, data-driven promotional strategies that deliver measurable results. 

Our team comprises media, strategy, and omnichannel analytics experts who thrive on collaboration, innovation, and results. When you join Underscore, you become part of a dynamic environment where your ideas matter, your growth is supported, and your work helps elevate brands in a competitive healthcare landscape. 

If you're passionate about making a difference and want to be part of a team that values integrity, creativity, and results, if that sounds like you, we invite you to share. 

Equal Employment Opportunity Statement
Underscore is committed to creating a diverse and inclusive workplace. We provide equal employment opportunities to all employees and applicants without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, veteran status, or any other protected characteristic under applicable law. We believe that diversity drives innovation and success, and we welcome candidates from all backgrounds to apply.