> Markdown version of [/jobs/ext/1457564-senior-software-engineer-903173](https://www.wearedevelopers.com/jobs/ext/1457564-senior-software-engineer-903173). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Software Engineer (903173) - **Company:** Pantherx Specialty LLC - **Location:** Pittsburgh, PA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Agile Methodology, Audit Trail, Microsoft Azure, C Sharp (Programming Language), Code Review, Data Validation, Extract Transform Load (ETL), Database Queries, File Systems, Performance Tuning, Systems Development Life Cycle, Software Engineering, SQL Stored Procedures, SQL Server Integration Services, Systems Integration, Test Data, Transact-SQL, Data Logging, Data Processing, File Transfer Protocol (FTP), Azure Data Factory, Information Technology, Health Level Seven International - **Published:** July 27, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=feb007ffa5b11276 ## About the Role * 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). ## Description 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. ## Related Videos - [Security Pitfalls for Software Engineers](https://www.wearedevelopers.com/videos/726-security-pitfalls-for-software-engineers) - [Resilient by Design: Building Robust Architectures in High-Stakes Financial Systems](https://www.wearedevelopers.com/videos/2106-resilient-by-design-building-robust-architectures-in-high-stakes-financial-systems) - [Are Code Reviews Worth It? Insights from 16 Years of Review Data](https://www.wearedevelopers.com/videos/1135-are-code-reviews-worth-it-insights-from-16-years-of-review-data) - [Dirty Tests And How To Clean Them](https://www.wearedevelopers.com/videos/515-dirty-tests-and-how-to-clean-them) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Navigating the Corporate Jungle: Life as a Developer in a large Company](https://www.wearedevelopers.com/videos/621-navigating-the-corporate-jungle-life-as-a-developer-in-a-large-company) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Where To Find Software Engineering Jobs](https://www.wearedevelopers.com/magazine/396-where-to-find-software-engineering-jobs) - [The 12 Best Jobs for Software Engineers](https://www.wearedevelopers.com/magazine/401-the-12-best-jobs-for-software-engineers) - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers)