Marketing Data Analyst

Responsibilities

• Extract, transform, and validate member data from multiple internal systems using Snowflake, producing clean, audit-ready lists for every communication send
• Build and maintain automated data validation workflows that catch quality issues — gaps, duplicates, mismatched fields, ineligible members — before lists are handed to Marketing Operations
• Own suppression and exclusion logic, including regulatory opt-outs, eligibility exclusions, and client-specific rules, and ensure they are consistently applied across all channels and send types
• Partner closely with the Marketing Operations Manager on list specifications, field mapping requirements, and pre-send data checks
• Maintain clear documentation of data sources, transformation logic, field definitions, and business rules to support auditability and regulatory compliance
• Collaborate with the centralized Data team to stay aligned on Snowflake data model changes, contribute to shared data quality standards, and represent member communications requirements in data infrastructure decisions
• Proactively identify, escalate, and root-cause data quality issues, partnering with the Member Comms Team Lead and internal data owners to drive resolution
• Support ad-hoc data pulls for compliance reporting, campaign sizing, program performance analysis, and regulatory inquiries

Requirements

• 4 years of hands-on experience in data analytics, data operations, or a closely related discipline
• Experience working with Protected Health Information (PHI) and a working knowledge of HIPAA requirements as they apply to data handling
• Strong SQL proficiency in Snowflake — comfortable writing complex queries, joining across multiple sources, and transforming raw data into clean, validated output
• A quality-obsessed approach to data — experience building validation logic, reconciling data across systems, and treating data integrity as non-negotiable
• Familiarity with member or customer data concepts including suppression lists, opt-out and preference management, eligibility logic, and regulated data handling
• Strong cross-functional communication skills — translate data findings and quality issues clearly to both technical and non-technical stakeholders
• A security-first mindset

Nice-to-Haves

• Experience working within a shared data infrastructure (e.g., contributing to or consuming dbt models, working alongside Data Engineering or Analytics teams)
• Healthcare or PBM industry experience