Marketing Data Analyst

Who We Are: 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 for our mission-driven and collaborative culture that inspires our employees to do their best work. We believe that the U.S healthcare system is in need of transformation, and we come to work each day dedicated to making that change a reality. At our core, we are guided by our company values: Integrity: Our purpose guides our actions and gives us confidence in the path ahead. With unwavering honesty and dependability, we embrace the pressure of challenging the old and exemplify ethical leadership to create the new. Courage: We face continuous challenges with grit and resilience. We embrace the discomfort of the unknown by balancing autonomy with empathy, and ownership with vulnerability. We boldly challenge the status quo to keep moving forward—always. Together: The success of SmithRx reflects the strength of our partnerships and the commitment of our team. Our shared values bind us together and make us one. When one falls, we all fall; when one rises, we all rise. Job Summary: You are the source of truth for member data on the MCSS (Member Communications Shared Services) team. While the Marketing Operations Manager owns the pipes that deliver communications, you own what flows through them — the accuracy, completeness, and integrity of every member list. You are responsible for sourcing, validating, and preparing member data drawn from many internal systems, ensuring that every letter, email, and text we send reaches the right member with the right information. At SmithRx, data integrity is a legal requirement — not a best practice. Our member communications are heavily regulated and compliance-driven, and this role works directly with Protected Health Information (PHI). A single bad record isn't a minor error; it's a risk to our members and our business. You will report directly to the Member Comms Team Lead and maintain a dotted-line relationship with our centralized Data team — contributing to shared Snowflake data models, aligning with enterprise data standards, and coordinating on upstream changes that affect member communications. Over time, high performers in this role will have the opportunity to expand their scope beyond member communications into broader marketing analytics. 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, and more — for use across email, SMS, and print communications. Your primary workspace is Snowflake, querying across the data models maintained by our Data Engineering and Analytics teams. Data Quality & Validation 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. PHI Stewardship & Compliance 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. Treat opt-out, preference, and PHI data as the highest-priority data in the pipeline. 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 an activ