Overview
Lead the data engineering foundation for LillyDirect, Lilly's direct-to-patient pharmacy platform, delivering patient analytics data products and HIPAA/SPI consent-governed data infrastructure.
What you'll do
- Lead the design, development, and delivery of patient analytics data products supporting LillyDirect pharmacy: patient journey tracking, prescription initiation, dispensing fulfillment, and program engagement analytics.
- Integrate LillyDirect data flows into the consumer first-party data ecosystem, ensuring patient analytics align with and extend the broader consumer engagement platform and 1PD data standards.
- Architect HIPAA-compliant data infrastructure for the LillyDirect platform, including HIPAA authorization capture, SPI consent management, enterprise vs. LillyDirect consent scoping, and revocation propagation across all integrated systems and journeys.
- Design and implement tokenization and identity resolution pipelines linking prescription, dispensing, and intake pharmacy partner data to enable end-to-end, privacy-governed patient journey analytics.
- Build scalable, reliable data ingestion pipelines for pharmacy partner data (C5/LDP, intake pharmacy feeds); define data quality standards and validation processes for enterprise-scale patient datasets.
- Deliver semantic layers and analytics-ready data products, including curated datasets, data dictionaries, and governed access patterns enabling downstream BI reporting, self-service analytics, and agentic AI use cases.
- Govern data access and privacy controls in coordination with legal, cyber, and privacy teams; own data recertification milestones, Reltio/Cassie integrations, and consent scoping decisions.
- Collaborate with the LillyDirect product team, intake pharmacy partners, consumer 1PD analytical platform team, and BIA platform enablement to translate business requirements into technical specifications and deliver governed, high-quality data products.
What you'll need
- Bachelor's and/or Master's Degree in Computer Science, Engineering, Statistics, Information Technology, Information Management, or related degree.
- 5+ years of experience in data engineering, with a focus on developing data products and solutions in healthcare, pharma, or similarly regulated environments.
- 5+ years of expertise in SQL and Python.
- 5+ years of hands-on experience with cloud-native data engineering tools (ex. Databricks, Delta Lake, Apache Spark) and enterprise data warehouse platforms (ex. Snowflake, Redshift, or equivalent), with exposure to large-scale patient or clinical datasets.
- Experience with cloud platforms such as AWS or Azure.
Nice to have
- Experience designing and executing data ingestion pipelines for complex, multi-source data environments.
- Solid understanding of data modeling and database design.
- Knowledge of HIPAA regulations and healthcare data privacy requirements; experience with consent management or SPI governance frameworks.
- Familiarity with patient data models such as OMOP/Common Data Model or equivalent.
- Experience with patient analytics or healthcare data ecosystems: prescription, dispensing, intake pharmacy, or medical claims data.
- Deep understanding of HIPAA authorization frameworks, SPI consent management, and consent revocation propagation across integrated systems and CRM/marketing platforms.
- Tokenization and identity resolution experience for linking first-party and third-party patient data at enterprise scale.
- Semantic modeling and data dictionary development experience (Power BI, Microsoft Fabric, or equivalent BI platforms).
- Familiarity with Databricks Unity Catalog, Delta Lake, and lakehouse architecture patterns.
- Consistent record of leading complex, multi-stakeholder data engineering projects in regulated or compliance-driven environments.
- Knowledge of DevOps practices and CI/CD tools; GitHub-based version control and analytics scripting workflows.
- Experience with Agile/Scrum methodologies and project management tools such as JIRA.
- Ability to bridge technical and non-technical stakeholders, translating patient analytics requirements into scalable, privacy-first technical implementations.
Details
- Location: USA, Remote.
- Travel: 0-25% depending on business need.
- Works with the Sr. Director, Consumer Data Engineering.
Read the full description and apply on the company’s own careers page.