data
Posted 1 weeks agoMarketing Data Analyst
at Why Hiring
Remote
Responsibilities
- Own the end-to-end process of extracting and compiling member lists from multiple internal data sources — eligibility systems, pharmacy data, client records, and more — for use across email, SMS, and print communications.
- Define and enforce data quality standards across all member lists before they enter the delivery pipeline.
- Build and maintain automated checks that surface anomalies — duplicate records, missing fields, invalid formats, eligibility mismatches — before a single message is triggered.
- Handle Protected Health Information with the rigor and discipline it demands.
- Own suppression list logic, ensuring members who have opted out, are ineligible, or fall under regulatory exclusions are accurately reflected across all lists at all times.
- Maintain an active working relationship with the centralized Data team — contributing to shared data models and quality standards, staying aligned on upstream changes, and advocating for member communications data needs at the infrastructure level. What you will do:
- 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
- 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
- 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
- Your primary workspace is Snowflake, querying across the data models maintained by our Data Engineering and Analytics teams.