Senior Software Engineer - File Integrations

**7,000 Diseases - 500 Treatments - 1 Rare Pharmacy** *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!** **Location:** Pittsburgh, PA-Hybrid **Classification:** Exempt **Status:** Full-Time **Reports To:** Manager, Software Development **Purpose** 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. **Responsibilities** ***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*** - Pa…