Summer Internship, Data Engineering

AffirmedRx is on a mission to improve health care outcomes by bringing clarity, integrity, and trust to pharmacy benefit management. We are committed to making pharmacy benefits easy to understand, straightforward to access and always in the best interest of employers and the lives they impact. We accomplish this by bringing total clarity to business practices, leading with clinical approaches, and utilizing state-of-the-art technology.

Join us in improving health care outcomes for all! We promise to do what’s right, always.

Position Summary:

The Data Engineering Intern will play a critical role in building and maintaining the data infrastructure that powers analytics and reporting across the organization. This role will support the development of scalable data pipelines, automate data ingestion processes, and ensure data quality for downstream consumers. This role will report to the Senior Data Engineer.

What you will do:

Build and Maintain Data Pipelines:

• Develop and maintain ETL/ELT pipelines to ingest, transform, and load data from various sources including pharmacy claims, eligibility files, and client data feeds
• Support automation of file processing workflows, including format standardization and validation
• Create and maintain documentation for data models, pipeline architecture, and transformation logic

Data Quality and Infrastructure:

• Implement data validation and quality checks to ensure accuracy and completeness of source data
• Troubleshoot and resolve data pipeline failures and anomalies
• Support the design and maintenance of dimensional models in our cloud data warehouse

Collaboration and Standards:

• Partner with analytics and reporting teams to understand data requirements and deliver reliable, well-structured datasets
•  Ensure adherence to compliance and data security standards when handling sensitive information (PHI and PII), including completion of HIPAA training
•  Participate in code reviews and follow version control best practices

What you need:

• Currently pursuing a degree in Computer Science, Information Systems, Data Engineering, or related technical field
•  Familiarity with SQL and at least one programming language (Python preferred)
• Basic understanding of data warehousing concepts and relational databases
• Exposure to cloud platforms (Snowflake, Azure, or AWS a plus)
• Strong problem-solving skills and attention to detail
• Ability to communicate technical concepts to non-technical stakeholders

What you get:

• Hands-on experience with modern data stack tools (Snowflake, dbt, Azure)
• Exposure to real-world healthcare data engineering challenges at scale
• To impact industry change in the pharmacy benefits management space
•  To work in a culture where people thrive because when OUR team thrives, OUR business thrives

Other Position Details:

• $17 - $18 per hour, depending on experience
• 30-35 hours per week (flexible, Monday through Friday, based on scheduling)
• 2 full months - June 1 – August 7, 2026
• End of internship presentation to leadership (last week)

Note:

AffirmedRx is committed to providing equal employment opportunities to all employees and applicants for employment. Remote employees are expected to maintain a professional work environment free of distractions to ensure optimal performance and collaboration.