AffirmedRx, PBC - Senior Data Operations Engineer
Upload My Resume
Drop here or click to browse · PDF, DOCX, DOC, RTF, TXT
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 • 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.
Responsibilities
• 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
Similar Jobs
No credit card. Takes 10 seconds.