Sr. Data Operations Engineer

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 Senior Data Operations Engineer is responsible for the integrity and flow of the AffirmedRx data ecosystem. This role manages end-to-end technical onboarding for client data, automates ingestion pipelines, and resolves complex data discrepancies. You will act as the primary technical bridge between raw client data and our internal analytics environment, ensuring all data is mapped, validated, and accessible.

What you will do:

Manage File Transfer and Security:

• Design and maintain secure client data gateways using SFTP
• Administer SharePoint file security and permissions to ensure HIPAA compliance
• Ensure complete data isolation for sensitive client information

Infrastructure Automation and Data Workflows:

• Build and operationalize scripts using Python and PowerShell to automate file movements
• Implement proactive pipeline monitoring and automated data cleanup processes
• Develop automated notifications and workflows using Microsoft Power Platform (Power Apps, Power Automate)

Modern Data Stack (ETL/ELT) and Data Transformation:

• Map incoming data formats CSV, Flat Files, DB files, EDI 834 Enrollment or EDI 835/837 claims files into the Data Warehouse
• Develop and optimize dbt models to transform raw claims and eligibility data
• Prepare analytics-ready tables to support business intelligence and reporting needs

Data Troubleshooting:

• Perform root-cause analysis on complex data sets
• Identify and resolve logic errors within Accumulators, Pharmacy Claims, and Eligibility files
• Ensure data integrity across multiple pipelines and formats

Professional Communication:

• Provide clear, concise technical guidance to internal teams
• Translate technical database errors into actionable solutions for non-technical stakeholders
• Maintain consistent communication to support cross-functional collaboration

 What you need:

• Bachelor’s degree in computer science, Information Systems, or equivalent experience
• 5+ years of progressive experience in data operations, data architecture, or related roles
• 3 years of experience in Healthcare or PBM settings, specifically developing enterprise solutions for claims, eligibility, and accumulator data
• Knowledge of Pharmacy/Healthcare, including Claims, Eligibility, and Accumulators (preferred)
• Experience with SharePoint administration and Power Platform automation (preferred)
• Extensive experience with Snowflake, Fabric, and dbt
• Proficiency in Python, MSSQL, and PowerShell for operational task automation and analysis
• Practical knowledge of SFTP/FTPS/HTTPS, and secure managed file transfer (MFT) protocols
• Expertise in handling CSV, 340B, Fixed-width (Flat-files), EDI, and Database files
• Proven experience independently managing client-facing technical integrations (SFTP) and end-to-end data mapping

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.