Marketing Data Analyst

2 days, 5 hours ago
Full-time
Mid Level
Data Science and Analytics
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

Description

  • Own the end-to-end process of extracting and compiling member lists from multiple internal data sources for communication sends.
  • Extract, transform, and validate member data in Snowflake to produce clean, audit-ready lists.
  • Define, enforce, and automate data quality checks to catch duplicates, missing fields, invalid formats, and eligibility mismatches.
  • Own suppression and exclusion logic to ensure opt-outs, ineligible members, and regulatory exclusions are consistently applied across all channels.
  • Partner with Marketing Operations on list specifications, field mapping, and pre-send data checks.
  • Maintain documentation of data sources, transformation logic, field definitions, and business rules for auditability and compliance.
  • Collaborate with the centralized Data team on Snowflake data model changes and shared data quality standards.
  • Proactively identify, escalate, and root-cause data quality issues with internal stakeholders.
  • 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 for data handling.
  • Strong SQL proficiency in Snowflake, including complex queries, multi-source joins, and data transformation.
  • 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, strongly preferred.
  • Strong cross-functional communication skills with the ability to translate data issues for technical and non-technical stakeholders.
  • Healthcare or PBM industry experience strongly preferred.
  • A security-first mindset when handling member records.

Benefits

  • Highly competitive medical, pharmacy, dental, vision, life, 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 and an Employee Assistance Program (EAP).
  • Commuter benefits and paid parental leave.
  • Professional development and training opportunities.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Product Analyst

Kodiak Solutions Diversified Financial Services

Kodiak Solutions is hiring a Product Analyst to support healthcare technology delivery by converting business needs into requirements and coordinating Agile execution across cross-functional teams.

Agile Azure Confluence JIRA Kanban Scrum
5 hours, 14 minutes ago

Sr. Product Analyst, Omni

Engine.com 1-10 Machinery

Engine is hiring a Senior Product Data Analyst to support the Omni hotel booking infrastructure product by turning complex booking, pricing, and partner data into product decisions that shape the roadmap.

dbt Snowflake SQL
2 days, 5 hours ago

Technical Business Analyst (Payments) - 12 month FTC

Arbor 51-250 IT Services

Arbor Education is hiring a remote Technical Business Analyst to join its Payments product team, helping shape and deliver a cashless school payments roadmap that supports schools across the UK.

Agile
3 days, 6 hours ago

PRODUCTS ANALYST III - CASH PJ

Inter 51-250 Banks

Analista de Produtos Sr para o time de Produtos Cash PJ do Inter, responsável por evoluir produtos transacionais para clientes PJ com foco em impacto em receita, eficiência e experiência.

JIRA Kanban Scrum SQL Tableau
5 days, 5 hours 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