Analytics Engineer

This role plays a critical role in executing the operational and analytical foundation of LillyDirect, with a specific focus on pharmacy dispensing and fulfillment operations. This position partners closely with the existing Performance Operations analysts to expand capacity on operational metric development, automation, and quality validation across dispensing data sources. The role is positioned within the covered entity to enable patient-level operational analysis under appropriate governance. The ideal candidate thrives in a fast-paced, ambiguous environment and demonstrates strong analytical, communication, and execution skills while maintaining rigorous compliance with data-handling/sharing requirements.

Requirements:

Basic Requirements

Bachelor's degree in business, marketing, healthcare administration, data science, or a related discipline

Proficiency in SQL, Excel, and at least one statistical programming language (Python/R)

Familiarity with healthcare, pharmacy, or claims/dispensing operational data

1-3 years of work experience in a HIPAA covered entity delivering analytics/insights for CE Operations

Ability to complete and maintain all required data privacy, HIPAA, and covered-entity compliance training, and to handle protected health information (PHI) per established policies

Preferred Qualifications

Strong analytical skills with attention to detail and business acumen

Experience working in Databricks

Excellent communication skills with the ability to simplify complex concepts

Ability to work cross-functionally and influence without direct authority

High learning agility and adaptability in ambiguous environments

Working understanding of HIPAA/PHI handling and data-governance constraints, including manufacturer vs. covered-entity data separation

Equal Opportunity Employer / Disabled / Protected Veterans

The Know Your Rights poster is available here:

_EEOC_KnowYourRights6.12.pdf

The pay transparency policy is available here:

_%20English_formattedESQA508c.pdf

For temporary assignments lasting 13 weeks or longer, AllSTEM Connections is pleased to offer major medical, dental, vision, 401k and any statutory sick pay where required.

We are committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please contact your staffing representative who will reach out to our HR team.

AllSTEM Connections participates in the E-Verify program in certain locations as required by law. Learn more about the E-Verify program.

_Participation_Poster_ES.pdf

We also consider for employment qualified applicants regardless of criminal histories, consistent with legal requirements, including, if applicable, the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance. Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment-qualified applicants with arrest and conviction records, including, if applicable, the San Francisco Fair Chance Ordinance. For Los Angeles, CA applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

Additional Skills

1. Execute and Maintain Dispensing & Operational Data

Support recreation, validation, and maintenance of operational metrics from platform usage and pharmacy fulfillment data to improve automation, accuracy, and quality

Ensure data availability, quality, and compliance across dispensing data workstreams

1. Monitor and Report Performance Metrics

Create and Deploy operational dashboards for consumption within the Covered Entity

Track and report performance metrics to inform stakeholders; ensure timely, accurate updates to reporting tools

Contribute to consolidated, cross-source dispensing/reporting views supporting filtering, grouping, and finance reporting needs

1. Deliver Actionable Insights and Operational Support

Conduct analyses using SQL and Excel to measure operational performance and surface trends or opportunities

Translate data into clear, actionable insights for internal stakeholders

Support issue resolution through data-driven problem-solving and cross-functional collaboration, including urgent operational challenges

Contribute to KPI and data-strategy documentation

AllSTEM Representative Contact Info

Account Executive:

Priyanka

Branch Phone:

Location:

Ontario, CA