Senior Software Engineer

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

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

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

This job operates in a professional office or home office environment.

This role routinely uses standard office equipment such as computers, phones, and copiers.

While performing the duties of this job, the employee is regularly required to see, talk or hear.

The employee frequently is required to sit; stand; walk; use hands and fingers to handle or feel; and reach with hands and arms.

Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the job.

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.

Of course we offer paid holidays too!

PANTHERx Rare Pharmacy is an equal opportunity employer, and does not discriminate in recruiting, hiring, promotions or any term or condition of employment based on race, age, religion, gender, ethnicity, sexual orientation, gender identity, disability, protected veteran's status, or any other characteristic protected by federal, state or local laws.