RemoteLeaf Logo
Log in Sign up

Marketing Data Analyst, Member Communications

3 hours, 54 minutes ago
United States
Full-time
Mid Level
Data Analyst
Data Science and Analytics
dbt HIPAA Snowflake SQL
Apply Now
SmithRx

SmithRx

SmithRx revolutionizes pharmacy benefits with transparent technology, connecting stakeholders for efficient drug delivery and cost savings.

Pharmaceuticals
1K-5K
Founded 2016
$38M raised
View All Jobs 48

Description

  • Own the end-to-end process of extracting and compiling member lists from multiple internal systems for communication sends.
  • Extract, transform, and validate member data in Snowflake to produce clean, audit-ready lists.
  • Define, enforce, and improve data quality standards for member lists before they enter the delivery pipeline.
  • Build and maintain automated validation workflows that catch duplicates, missing fields, invalid formats, and eligibility mismatches.
  • Own suppression and exclusion logic for opt-outs, eligibility exclusions, regulatory exclusions, and client-specific rules.
  • Partner with Marketing Operations on list specifications, field mapping, schema requirements, and pre-send checks.
  • Maintain documentation of data sources, transformation logic, field definitions, and business rules for auditability and compliance.
  • Collaborate with the centralized Data team on shared Snowflake data models, data standards, and upstream changes.
  • Identify, escalate, and help root-cause data quality issues with internal data owners and team leads.
  • 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.
  • Strong SQL proficiency in Snowflake, including complex querying, joining multiple sources, and transforming raw data.
  • Experience building validation logic, reconciling data across systems, and maintaining high data integrity standards.
  • Familiarity with suppression lists, opt-out and preference management, eligibility logic, and regulated data handling.
  • Experience working within a shared data infrastructure, such as contributing to or consuming dbt models, is strongly preferred.
  • Strong cross-functional communication skills with the ability to explain data findings to technical and non-technical stakeholders.
  • Healthcare or PBM industry experience is strongly preferred.
  • A security-first mindset when handling member records.

Benefits

  • Highly competitive wellness benefits including Medical, Pharmacy, Dental, Vision, Life Insurance, and AD&D Insurance.
  • Flexible Spending Benefits.
  • 401(k) Retirement Savings Program.
  • Short-term and long-term disability coverage.
  • Discretionary Paid Time Off and paid company holidays.
  • Wellness benefits.
  • Commuter benefits.
  • Paid parental leave benefits.
  • Employee Assistance Program (EAP).
  • Professional development and training opportunities.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Affinity

Data Analyst

Affinity 251-1K IT Services

Affinity is seeking a Data Analyst to support customer onboarding by importing, transforming, and configuring data so customers can get value from the platform quickly.

Spain Full-time Junior Data Analyst
Looker Tableau
1 hour, 48 minutes ago
CloudWalk

AML-FT Analyst (Focus on Data)

CloudWalk 51-250 Diversified Financial Services

CloudWalk is hiring an AML-FT Analyst focused on data to support its Risk & Compliance team in monitoring financial crime risks and helping launch compliant products in a fast-moving fintech environment.

Brazil Full-time Senior Data Analyst
Looker Machine Learning Metabase Power BI Python SQL Tableau
2 hours, 41 minutes ago
PayJoy

D2C Analytics and Insights Manager

PayJoy 1K-5K Banks

PayJoy is hiring a Digital D2C Analytics and Insights Manager to lead performance analytics, strategic initiatives, and data-driven decision support for its digital direct-to-consumer channel across multiple markets.

Mexico Brazil Colombia Full-time Mid Level Data Analyst
Power BI SQL Tableau
3 hours, 39 minutes ago
Lingaro

Media Data Analyst

Lingaro 5K-10K IT Services

Lingaro is hiring a Media Data Analyst in India to turn fragmented offline and digital media data into harmonized, analytics-ready datasets that support marketing analytics and measurement.

India Contract Mid Level Data Analyst
Python
3 hours, 54 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers