# Marketing Data Analyst

**Company:** [SmithRx](https://hotfix.jobs/companies/smithrx)
**Location:** Remote
**Role:** Data Analytics
**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

## Similar roles

- [Growth Data Analyst](https://hotfix.jobs/jobs/c1f18ba3-2c96-48b4-8670-303037e5962a) - Polymarket - New York, NY
- [Pharmacy Systems Analyst](https://hotfix.jobs/jobs/8039ae85-a206-4e11-9ac5-257c55d78c23) - SmithRx - Remote - $75k – $106k/yr
- [PBM Client Delivery Analyst](https://hotfix.jobs/jobs/d224f433-cd95-41c4-92f6-522bab2f6ffe) - SmithRx - Remote - $75k – $106k/yr
- [Credit Risk Strategy and Analytics](https://hotfix.jobs/jobs/2f79e0a3-73e9-4f3f-a5b8-800c64512f92) - Stripe - Remote
- [Operation Data Analyst](https://hotfix.jobs/jobs/149dab45-9818-4eba-88fd-085867599f9d) - Forterra - Clarksburg, MD

**Apply:** https://hotfix.jobs/jobs/a99f736d-4342-44ec-a564-6aab555126cf
**Canonical:** https://hotfix.jobs/jobs/a99f736d-4342-44ec-a564-6aab555126cf