AffirmedRx, a Public Benefit Corporation
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 ANSI X12 and HIPAA-compliant transaction sets to support claims, eligibility, pharmacy, billing, 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.
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
Work with ANSI X12 and HIPAA-compliant transaction sets (834, 837, 835, 270/271, 276/277) and NCPDP pharmacy standards
Collaborate with PBM partners to optimize prescription, formulary, and claims workflows
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
5+ years of experience in systems integrations and/or ETL (Extract, Transform, Load), including hands-on work with tools such as Informatica and Microsoft SSIS
3+ years of hands-on experience in EDI development, preferably in the healthcare or PBM industry
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 Web APIs, data streams, and cloud integrations (preferred)
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.
#J-18808-Ljbffr
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 ANSI X12 and HIPAA-compliant transaction sets to support claims, eligibility, pharmacy, billing, 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.
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
Work with ANSI X12 and HIPAA-compliant transaction sets (834, 837, 835, 270/271, 276/277) and NCPDP pharmacy standards
Collaborate with PBM partners to optimize prescription, formulary, and claims workflows
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
5+ years of experience in systems integrations and/or ETL (Extract, Transform, Load), including hands-on work with tools such as Informatica and Microsoft SSIS
3+ years of hands-on experience in EDI development, preferably in the healthcare or PBM industry
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 Web APIs, data streams, and cloud integrations (preferred)
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.
#J-18808-Ljbffr