Marketing Data Analyst, Member Communications

Company Overview SmithRx is a rapidly growing, venture‑backed Health‑Tech company. Our mission is to disrupt the expensive and inefficient Pharmacy Benefit Management (PBM) sector by building a next‑generation drug acquisition platform driven by cutting‑edge technology, innovative cost‑saving tools, and best‑in‑class customer service. With hundreds of thousands of members onboarded since 2016, SmithRx has a solution that is resonating with clients all across the country. We pride ourselves on a mission‑driven, collaborative culture that inspires employees to do their best work. We believe the U.S. healthcare system is in need of transformation and are dedicated to making that change a reality. Our core values are Integrity, Courage, and Together. Responsibilities Data Sourcing & List Building: Own the end‑to‑end process of extracting and compiling member lists from multiple internal data sources (eligibility systems, pharmacy data, client records, etc.) for use across email, SMS, and print communications. Work primarily in Snowflake, querying across the data models maintained by our Data Engineering and Analytics teams. Data Quality & Validation: Define and enforce data‑quality standards. Build and maintain automated checks that surface anomalies – duplicate records, missing fields, invalid formats, eligibility mismatches – before a message is triggered. PHI Stewardship & Compliance: Handle Protected Health Information with rigor. Own suppression list logic, ensuring members who have opted out, are ineligible, or fall under regulatory exclusions are accurately reflected across all lists. Treat opt‑out, preference, and PHI data as the highest‑priority data. Cross‑Functional Partnership: Work hand‑in‑hand with the Marketing Operations Manager to ensure lists are formatted, mapped, and structured exactly to the schema required by communication platforms. Maintain a working relationship with the centralized Data team, contributing to shared data models, quality standards, and infrastructure decisions. Key Responsibilities (Detailed) 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 consistency 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, elevate, 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. Qualifications 4+ years of hands‑on experience in data analytics, data operations, or a closely related discipline. Experience handling Protected Health Information (PHI) with a working knowledge of HIPAA requirements. Strong SQL proficiency in Snowflake, comfortable writing complex queries and transforming raw data into clean outputs. A quality‑obsessed approach to data, building validation logic, reconciling data across systems, and treating data integrity as non‑negotiable. Familiarity with member or customer data concepts such as suppression lists, opt‑out and preference management, eligibility logic, and regulated data handling. Experience working within shared data infrastructure (e.g., dbt models) is strongly preferred. Strong cross‑functional communication skills, translating data findings clearly to both technical and non‑technical stakeholders. Healthcare or PBM industry experience is strongly preferred. A security‑first mindset: treating every member record with the utmost care. Benefits Highly competitive wellness benefits: Medical, Pharmacy, Dental, Vision, Life Insurance, and AD&D Insurance. Flexible Spending Benefits. 401(k) Retirement Savings Program. Short‑term and long‑term disability insurance. Discretionary Paid Time Off and Paid Company Holidays. Wellness Benefits. Commuter Benefits. Paid Parental Leave benefits. Employee Assistance Program (EAP). Well‑stocked kitchen in office locations. Professional development and training opportunities. #J-18808-Ljbffr SmithRx