Underscore Marketing Logo

Underscore Marketing

Data Analyst

Posted Yesterday
Be an Early Applicant
Remote
Hiring Remotely in United States
Mid level
Remote
Hiring Remotely in United States
Mid level
Support pharmaceutical brand and commercial teams by transforming and integrating healthcare and media data using SQL and cloud warehouses, performing EDA and statistical analysis, preparing datasets for advanced analytics and ML, and building visualizations and dashboards. Communicate insights to cross-functional stakeholders, document methodologies, and maintain analytical workflows and data governance for marketing and analytics use cases.
The summary above was generated by AI

Job Description: Data Analyst, Pharmaceutical Industry 

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 Purpose: 

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. 

Core 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. 

Cross-functional Interfaces: 

  • Strategic Solutions 
  • Pinnacle Task Force 
  • Data 

Success Indicators (What good looks like): 

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

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 

 

Interested?
Apply by submitting your resume and a brief note outlining your healthcare or media experience.

Underscore Marketing is a woman-owned, independent agency specializing in life sciences. Since 2002,we'vehelped 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. 



Similar Jobs

3 Days Ago
In-Office or Remote
71K-127K Annually
Senior level
71K-127K Annually
Senior level
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Perform descriptive and regression-based analyses, build BI solutions and dashboards, normalize and assure data quality, develop data models and specifications, produce insights and present recommendations to stakeholders, and support strategic and operational business activities.
Top Skills: AlteryxExcelMicrosoft PowerpointMicrosoft WordOraclePower BISQLSsisTableau
4 Days Ago
In-Office or Remote
73K-130K Annually
Mid level
73K-130K Annually
Mid level
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Support Medicare Advantage data warehouse: validate vendor data feeds, build ETL processes (SSIS), transform data for dashboards, perform ad-hoc analysis, document processes, and collaborate with business stakeholders and vendors.
Top Skills: AzureMs Data ToolsSnowflakeSQLSQL ServerSsisSsrs
7 Days Ago
Remote or Hybrid
US
95K-115K Annually
Junior
95K-115K Annually
Junior
Big Data • Fintech • Information Technology • Insurance • Software
Build and maintain dbt models, write SQL to investigate and validate data, implement data quality checks, document lineage and metrics, resolve production issues (including on-call), and partner with analysts and business teams to deliver production-ready data products using modern warehouse tooling and AI-assisted frameworks.
Top Skills: Ai-Assisted FrameworksBi ToolsClaude CodeCloud Data WarehouseCopilotCursorDbtOrchestrationSQL

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account