AffirmedRx, a Public Benefit Corporation

Senior Data Operations Engineer

AffirmedRx, a Public Benefit Corporation

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

ETLPython

About the role

  • 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

Requirements

  • 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
Benefits
  • Competitive compensation, including health, dental, vision and other benefits
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
PythonPowerShelldbtMSSQLSFTPETLELTdata mappingdata transformationroot-cause analysis
Soft Skills
professional communicationtechnical guidancecross-functional collaborationproblem-solvingdata integrity