# Marketing Data Analyst
**Company:** [SmithRx](https://hotfix.jobs/companies/smithrx)
**Location:** Remote
**Experience:** 4+ years
**Skills:** SQL, Snowflake, dbt, Data Analytics, Data Validation, Phi Handling, Hipaa Compliance, Data Quality, Suppression Lists, Cross-Functional Communication
**Posted:** 2026-06-26
> Own end-to-end member list extraction and validation in Snowflake for marketing campaigns. Ensure data quality, PHI compliance, and suppression logic while partnering with Marketing Ops and central Data teams.
## Job Description
## 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
**Apply:** https://hotfix.jobs/jobs/marketing-data-analyst-at-smithrx-a99f736d-4342-44ec-a564-6aab555126cf
**Canonical:** https://hotfix.jobs/jobs/marketing-data-analyst-at-smithrx-a99f736d-4342-44ec-a564-6aab555126cf