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