Senior Software Engineer - File Integrations

The Senior Software Engineer - File Integrations owns the design, development, and reliability of PANTHERx's flat-file exchange capabilities: ingesting data from external flat files into internal systems and generating outbound files sent from PANTHERx to external partners. This role combines deep SSIS and T-SQL expertise with strong C# application development skills, and carries senior-level responsibility for SDLC discipline and test environment integrity across the File Integrations workstream - a tower currently supported by a single internal engineer., File Ingestion & Generation

• Design, build, and maintain SSIS packages that ingest data from external flat files into PANTHERx systems, handling varied file formats, schemas, and delivery schedules.
• Design, build, and maintain processes that generate outbound flat files from PANTHERx systems for delivery to external partners, ensuring format, timing, and content meet partner specifications.
• Develop and optimize complex T-SQL logic (stored procedures, ETL transformations, data validation) supporting both inbound and outbound file processing.
• Build and maintain C# applications and services that support file processing, validation, transformation, and orchestration outside of SSIS where appropriate.

Reliability & Data Quality

• Implement validation, error handling, and reconciliation logic to catch malformed, incomplete, or late files before they reach downstream systems or external partners.
• Monitor scheduled file jobs, troubleshoot failures, and drive root-cause resolution for recurring issues.
• Maintain clear audit trails and logging for all inbound and outbound file activity to support troubleshooting and partner inquiries.

SDLC Discipline & Test Environments

• Ensure all File Integrations work follows the full software development lifecycle: requirements/design review, code review, testing, deployment, and post-release validation - no shortcuts given the tower's single-engineer history.
• Own the existence and integrity of lower environments (dev/test/staging) for File Integrations work, ensuring changes can be tested predictably and repeatably before reaching production.
• Build and maintain repeatable test data sets and test harnesses for both inbound and outbound file scenarios, including edge cases (malformed files, partial deliveries, schema drift).
• Document environment configuration, promotion processes, and testing procedures so File Integrations work is no longer dependent on a single person's undocumented knowledge.

Collaboration & Mentorship

• Partner with the Enterprise Pharmacy Systems and Market Place teams on integration points where file-based exchange intersects with ESB, Camunda, or partner API workstreams.
• Communicate file-processing status, issues, and partner-impacting changes clearly to both technical and non-technical stakeholders.
• Mentor less experienced engineers on SSIS, T-SQL, and file-integration best practices as the tower grows.

• Bachelor's degree in Computer Science or related field, or equivalent combination of education and experience.
• Minimum of five (5) years of related software engineering experience.
• Strong, hands-on experience with SQL Server Integration Services (SSIS) for building and maintaining ETL/file-processing packages.
• Strong T-SQL skills, including complex query writing, stored procedures, and performance tuning.
• Strong experience developing C# applications and services.
• Demonstrated experience building and maintaining flat-file ingestion and/or generation processes in a production environment.
• Solid understanding of the full SDLC and experience ensuring lower (dev/test/staging) environments exist and are used to produce predictable, repeatable test results.
• Strong analytical and troubleshooting skills; ability to work independently and mentor others., * Experience in healthcare, specialty pharmacy, or another regulated industry with strict partner file-exchange requirements.
• Familiarity with SFTP-based file delivery, PGP encryption, or other secure file-transfer standards.
• Experience with Azure Data Factory or other modern orchestration tools as a complement to SSIS.
• Understanding of HIPAA and healthcare data standards.
• Experience with Agile methodologies and CI/CD tooling (Azure DevOps).

Pulled from the full job description

• Health insurance
• 401(k) matching
• Paid time off
• Vision insurance
• Dental insurance
• Flexible spending account
• Life insurance, Hybrid, remote and flexible on-site work schedules are available, based on the position. PANTHERx Rare Pharmacy also affords an excellent benefit package, including but not limited to medical, dental, vision, health savings and flexible spending accounts, 401K with employer matching, employer-paid life insurance and short/long term disability coverage, and an Employee Assistance Program! Generous paid time off is also available to all full-time employees, as well as limited paid time off for part-time employees. Of course we offer paid holidays too!

PANTHERx is the nation's largest rare disease pharmacy, and we put the patient experience at the top of everything that we do. If you are looking for a career in the healthcare field that embraces authentic dedication to patient care, you don't need to look beyond PANTHERx. In every line of service, in every position and area of expertise, PANTHERx associates are driven to provide the highest quality outcomes for our patients. We are seeking team members who: Are inspired and compassionate problem solvers; Produce high quality work; Thrive in the excitement of the ever-challenging environment of modern medicine; and Are committed to achieving superior health outcomes for people living with rare and devastating diseases. At PANTHERx, we know our employees are the driving force in what we do. We cultivate talent and encourage growth within PANTHERx so that our associates can continue to explore their interests and expand their careers. Guided by our mission to provide uncompromising quality every day, we continue our strategic growth to further reach those affected by rare diseases. Join the PANTHERx team, and define your own RxARE future in healthcare!