> Markdown version of [/jobs/ext/2881367-software-engineer-file-integrations](https://www.wearedevelopers.com/jobs/ext/2881367-software-engineer-file-integrations). 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). --- # Software Engineer - File Integrations - **Company:** Whopper Technologies - **Location:** Pittsburgh, PA, United States - **Experience:** Expert - **Contract:** Temporary to permanent - **Skills:** Agile Methodology, Audit Trail, Microsoft Azure, C Sharp (Programming Language), Code Review, Continuous Integration, Data Validation, Data Integration, Extract Transform Load (ETL), Data Transformation, Database Queries, File Systems, File Transfer, Performance Tuning, Systems Development Life Cycle, Simple Data Format, Software Deployment, Software Engineering, SQL Stored Procedures, SQL Server Integration Services, Systems Integration, Test Data, Transact-SQL, Data Logging, File Transfer Protocol (FTP), Azure Data Factory, Backend, Kubernetes, Information Technology, Enterprise Integration, Api Design - **Published:** September 13, 2026 - **Apply:** https://www.careerjet.com/jobad/usadd53bca84e74b2d564fa73984d7f807 ## About the Role Minimum of 7 years of related software engineering experience. Strong hands-on backend development experience with C#. Strong hands-on experience designing, developing, and maintaining SSIS packages. Advanced T-SQL experience, including complex queries, stored procedures, data transformations, validation logic, and performance tuning. Demonstrated production experience building and supporting flat-file ingestion and/or outbound file-generation solutions. Experience troubleshooting scheduled file-processing jobs and resolving production integration failures. Strong understanding of data validation, error handling, reconciliation, logging, and auditability. Strong understanding of the complete software development lifecycle. Experience working with development, test, staging, and production environments. Experience developing repeatable testing processes rather than relying solely on production validation. Strong analytical, troubleshooting, and problem-solving skills. Ability to independently own technical work while collaborating effectively with other engineering teams. Bachelor's degree in Computer Science or a related field, or an equivalent combination of education and professional experience. Preferred Qualifications Experience modernizing legacy or established integration environments. Experience with Azure Data Factory or other Azure-based data integration and orchestration technologies. Familiarity with SFTP-based file transfers, PGP encryption, and secure partner file-exchange practices. Experience with Azure DevOps or similar CI/CD tooling. Experience working within Agile development environments. Experience in healthcare, specialty pharmacy, or another regulated environment involving sensitive data and strict external integration requirements. Understanding of HIPAA and healthcare-related data requirements. ## Description We are seeking a Senior Software Engineer with strong backend development and data integration experience to own and enhance critical flat file exchange capabilities. This role is centered on designing, developing, maintaining, and supporting inbound and outbound flat-file integrations using C#, T-SQL, and SQL Server Integration Services (SSIS). The engineer will ensure data is reliably received from external partners, processed correctly within internal systems, and delivered accurately back to external partners. This is not simply an SSIS maintenance position. We are looking for an experienced backend engineer who has built and supported file-processing solutions in production, understands the full software development lifecycle, and can bring greater structure, testing discipline, documentation, and reliability to the environment. The right person will also be able to evaluate the existing integration approach and recommend practical modernization opportunities, including the potential use of Azure services and newer integration technologies where they provide meaningful improvements. Responsibilities: File Integration Development Design, build, enhance, and maintain SSIS packages used to ingest external flat files into internal systems. Develop outbound file-generation processes that extract and transform internal data into files required by external partners. Work with varying file formats, schemas, layouts, delivery schedules, and partner requirements. Develop and optimize complex T-SQL, including stored procedures, queries, ETL transformations, data validation, and performance tuning. Build and maintain C# applications and services supporting file processing, validation, transformation, orchestration, and related backend functionality. Determine when functionality belongs within SSIS versus a C# application or service based on maintainability and technical requirements. Reliability, Troubleshooting & Data Quality Build validation and reconciliation processes that identify malformed, incomplete, inaccurate, or late files before they create downstream problems. Monitor scheduled file-processing jobs and troubleshoot production failures. Investigate recurring issues and drive root-cause resolution rather than relying on temporary fixes. Implement effective logging and audit trails for inbound and outbound file activity. Help ensure integrations are reliable, supportable, and easier to troubleshoot. SDLC, Testing & Environment Ownership A major expectation of this position is bringing strong software engineering discipline to the File Integrations function. Follow the complete software development lifecycle, including requirements review, technical design, development, code review, testing, deployment, and post-production validation. Ensure development, test, and staging environments are available and appropriately used before production deployment. Build repeatable testing processes for inbound and outbound file integrations. Develop representative test data and test scenarios covering normal processing as well as edge cases such as malformed files, partial deliveries, invalid data, and schema changes. Document environment configurations, deployment processes, integration behavior, troubleshooting procedures, and testing practices. Reduce dependency on undocumented knowledge by creating maintainable processes and technical documentation. Promote predictable and repeatable software releases rather than making changes directly in production without appropriate testing. Modernization & Continuous Improvement The existing environment relies heavily on SSIS, T-SQL, and C#, and strong expertise in those technologies is essential. At the same time, we want someone who can help determine how the integration environment should evolve. Evaluate existing file-processing solutions and identify opportunities to improve maintainability, reliability, automation, and scalability. Recommend practical modernization approaches rather than replacing technology simply for the sake of modernization. Explore opportunities to complement or evolve existing SSIS processes using Azure services or other modern integration and orchestration capabilities where appropriate. Help establish development patterns and standards that will make the environment easier to support and expand over time. Collaboration & Technical Leadership Work closely with software engineering and other technical teams where file integrations intersect with application, messaging, workflow, or API-based integrations. Communicate integration issues, processing status, risks, and partner-impacting changes clearly to both technical and non-technical stakeholders. Work independently and take ownership of problems through resolution. Mentor less experienced engineers in SSIS, T-SQL, backend development, file integration, testing, and troubleshooting practices. Contribute to technical decisions and help establish standards as the integration function grows., KeyLogic is seeking a Senior Software Engineer to join our supporting the Department of Energy. The Engineer will be joining our team of developers to help with the maintenance of … + 1 day ago, KeyLogic is seeking a Senior Software Engineer to join our supporting the Department of Energy. The Engineer will be joining our team of developers to help with the maintenance of … + 2 days ago + ## Related Videos - [API Design - Getting Started](https://www.wearedevelopers.com/videos/33-api-design-getting-started) - [Developing the Backend with Stefan Lingler, CTO at Shpock](https://www.wearedevelopers.com/videos/100360-developing-the-backend-with-stefan-lingler-cto-at-shpock) - [Dirty Tests And How To Clean Them](https://www.wearedevelopers.com/videos/515-dirty-tests-and-how-to-clean-them) - [Migrating half a million users to a new payment service provider](https://www.wearedevelopers.com/videos/730-migrating-half-a-million-users-to-a-new-payment-service-provider) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Rest API Antipatterns](https://www.wearedevelopers.com/videos/100208-rest-api-antipatterns) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Where To Find Software Engineering Jobs](https://www.wearedevelopers.com/magazine/396-where-to-find-software-engineering-jobs) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [The 12 Best Jobs for Software Engineers](https://www.wearedevelopers.com/magazine/401-the-12-best-jobs-for-software-engineers) - [Where to Find Entry-Level Software Engineering Jobs](https://www.wearedevelopers.com/magazine/397-where-to-find-entry-level-software-engineering-jobs) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated)