Senior Data Operations Engineer

AffirmedRx is on a mission to improve health care outcomes by bringing clarity, integrity, and trust to pharmacy benefit management. The Senior Data Operations Engineer is responsible for the integrity and flow of the AffirmedRx data ecosystem, managing technical onboarding for client data and automating ingestion pipelines.

Responsibilities:

• 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
• 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)
• 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
• 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
• 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

Requirements:

• Bachelor's degree in computer science, Information Systems, or equivalent experience
• 7+ 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
• 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
• Knowledge of Pharmacy/Healthcare, including Claims, Eligibility, and Accumulators
• Experience with SharePoint administration and Power Platform automation