ETL Developer

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 ETL Developer is responsible for designing, developing, and maintaining healthcare data exchange solutions with providers, payers, PBMs, and other trading partners. This role works extensively with standard and non-standard HIPAA-compliant transaction sets to support claims, eligibility, pharmacy, accumulators and enrollment processes. The developer partners closely with business teams and technical stakeholders to ensure data quality, regulatory compliance, and reliable system performance while troubleshooting issues and optimizing workflows. In addition, this position contributes to Master Data Management (MDM) initiatives, documents data exchange processes, and provides mentorship and guidance to junior team members.

We are seeking a skilled ETL Developer to design, develop, and maintain data pipelines and integration solutions. The ideal candidate will have hands-on experience with Snowflake, Python, and SQL, and a strong understanding of data warehousing and ETL best practices.

What you will do:

Data Collaboration and Governance:

• Partner with source systems, data stewards, and technical teams to ensure effective data governance and resolve data quality or technical issues
•  Work closely with business teams (claims, eligibility, pharmacy, billing, enrollment, etc.) to gather requirements and implement data exchange solutions that meet operational needs
• Provide mentorship and technical guidance to junior analysts and engineers

Data Exchange Management:

• Design, develop, and maintain data exchange transactions, including maps and workflows, with healthcare providers, payers, PBMs, and other trading partners
• Collaborate with PBM partners to optimize prescription, formulary, and claims workflows
• Design and implement scalable ETL processes to ingest, transform, and load data into Snowflake.
• Develop Python scripts for data manipulation, automation, and integration tasks.
• Write complex SQL queries for data extraction, transformation, and reporting.
• Collaborate with data analysts, engineers, and business stakeholders to understand data requirements.
• Optimize data workflows for performance and reliability.
• Monitor and troubleshoot ETL jobs and data quality issues.
• Maintain documentation for data pipelines and system architecture

Systems Compliance and Performance:

• Ensure compliance with HIPAA, CMS, and other healthcare regulations
• Monitor and improve data exchange performance, reliability, and error-handling processes
• Troubleshoot and resolve issues related to data exchange transactions, connectivity, and partner communications

Master Data and Process Management:

• Support the development of Master Data Management (MDM) plans, including defining processes, policies, requirements, monitoring, and tool selection
• Monitor MDM services to ensure performance, correct errors, and identify areas for improvement
• Collaborate with data remediators, database administrators, network administrators, and software engineers to resolve issues and document data integration processes and system configurations

What you need:

• Bachelor’s degree in information technology or equivalent experience
• 3+ years of experience in ETL development or data engineering using Azure Data Factory (ADF), Azure Synapse, Databricks, other Azure services and Data Build Tools.
• Strong Python programming skills for scripting and automation.
•  Advanced SQL skills for data transformation and analysis.
• Experience with cloud platforms (e.g., AWS, Azure, GCP) is a plus.
• Familiarity with version control (e.g., Git) and CI/CD pipelines.
• Experience with flat file integrations, FTP/SFTP, data cleansing, and transformation
• 5+ years of relational database experience (SQL Server preferred) and 3+ years writing SQL, with emphasis on Master Data Management and data integration methodologies
• Proficiency in mapping tools, scripting languages (e.g., XML, XSLT, SQL), and integration frameworks
• 1–2 years of experience with data warehouse concepts
• Proficiency in ETL standard tools and familiarity with advanced integration topics such as cloud integrations
• Experience with Power BI
• Strong analytical and problem-solving skills to troubleshoot technical issues, data anomalies, and system integrations
• Ability to work independently or collaboratively within a team environment
• Knowledge of data encryption and security best practices
•  Data modeling experience (preferred)
• Excellent written and verbal communication skills
• Healthcare experience, particularly with PBMs, is preferred

What you get: 

• To impact industry change in the pharmacy benefits management space, while delivering the highest quality patient outcomes 
• To work in a culture where people thrive because when OUR team thrives, OUR business thrives
• Competitive compensation, including health, dental, vision and other benefits 

 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.