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

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