SQL Server / SSIS Developer

Aquent is thrilled to partner with a recognized leader in the financial services industry, an institution dedicated to empowering individuals and institutions through innovative solutions and exceptional service. This organization is committed to leveraging cutting-edge technology to provide secure, efficient, and reliable financial operations. Joining this team means contributing to systems that underpin vital financial services, making a tangible difference in a dynamic and regulated environment. Make an Immediate Impact as a Senior Developer: Are you ready to be at the forefront of enhancing and supporting foundational data infrastructure? As a hands-on Senior Developer, you will deliver immediate value and drive essential business functions forward. Dive into complex batch processing environments, leveraging your expertise to optimize performance, build robust ETL solutions, and ensure seamless data movement. Your strong troubleshooting skills will be vital in maintaining operational reliability, performing root cause analysis for critical data and job failures, and collaborating with cross-functional teams to deliver high-quality, documented solutions. This is an unparalleled opportunity to contribute directly to the stability and efficiency of core financial systems with immediate and significant impact.

Responsibilities

Develop, enhance, and support batch jobs, ensuring high performance and reliability; Build and maintain robust ETL and data movement pipelines to support critical business operations; Optimize SQL queries and stored procedures for peak performance and system reliability; Provide essential support for batch execution, monitoring, and proactive issue resolution in production environments; Perform thorough root cause analysis for data discrepancies or job failures, implementing effective solutions; Create clear and comprehensive documentation for packages, batch logic, and data flows; Collaborate effectively with QA teams, production support, and full-time engineering staff to deliver integrated solutions

Requirements

5+ years of proven software development experience; Strong hands-on experience with package development and ongoing support; Extensive database expertise, including complex query writing, stored procedure development, and performance tuning; Demonstrated experience in building and supporting database-based batch jobs; Working knowledge of .NET / C# for backend or batch workflow development; Experience supporting scheduled and automated jobs within production environments; Strong troubleshooting skills to diagnose and resolve batch failures and data-related issues

Nice to have

Experience with enterprise job schedulers (e.g., SQL Agent, ControlM, Autosys); Experience working with and modernizing legacy batch jobs; Familiarity with Git for version control and CI/CD pipelines; Previous experience in financial services or other highly regulated environments

Benefits

Subsidized health, vision, and dental plans; Paid sick leave; Retirement plans with a match; Free online training through Aquent Gymnasium