Job Board
LogoLogo

Get Jobs Tailored to Your Resume

Filtr uses AI to scan 1000+ jobs and finds postings that perfectly matches your resume

AffirmedRx, a Public Benefit Corporation Logo

ETL Developer

AffirmedRx, a Public Benefit Corporation

Salary not specified
Oct 30, 2025
Remote, US
Apply Now

AffirmedRx is looking to improve health care outcomes by bringing clarity, integrity, and trust to pharmacy benefit management

Requirements

  • 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

Responsibilities

  • Design, develop, and maintain healthcare data exchange solutions with providers, payers, PBMs, and other trading partners
  • Partner with source systems, data stewards, and technical teams to ensure effective data governance and resolve data quality or technical issues
  • 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
  • Ensure compliance with HIPAA, CMS, and other healthcare regulations
  • Monitor and improve data exchange performance, reliability, and error-handling processes

Other

  • Bachelor’s degree in Information Technology or equivalent experience
  • Ability to work independently or collaboratively within a team environment
  • Excellent written and verbal communication skills
  • Healthcare experience, particularly with PBMs, is preferred
  • Remote employees are expected to maintain a professional work environment free of distractions to ensure optimal performance and collaboration