Software Engineer II (SQL Developer) (Finance)

TransCore, (TRN) a subsidiary of ST Engineering, is seeking a full-time Software Engineer II (SQL Developer) to join our team in Harrisburg, Pennsylvania.

Job Summary: We are looking for a full-time Software Engineer II (SQL Developer) to join our software development team based in Harrisburg, PA. The team currently supports and develops enhancements to our Customer Service Center software and the Toll Host systems developed for the Pennsylvania Turnpike Commission. System components include a client-server application, website, mobile application for Android and iOS, Web API, OCR image processing module, and a SQL Server database. Our systems utilize a tiered architecture and object-oriented technology. Applications are developed in VB.Net and C# using Visual Studio and MS SQL Server development tools.

Essential Duties and Responsibilities include but not limited to:

• Analyze and optimize large, complex datasets and queries
• Perform statistical analysis to valid data and impact of software upgrades and enhancements
• Develop and maintain stored procedures and SSIS packages
• Support production backend processes
• Develop new backend processes
• Maintain code standards
• Work closely with the team to maintain component reusability and integrity of the system
• Troubleshoot and address problems wherever they exist

Required Skills and Experience:

• Bachelor's degree in Computer Science, Mathematics, or Data Science. Master's degree is a plus.
• Experience with large databases
• MS SQL Server
• Visual Studio, VB.Net development experience optional
• Ability to deliver projects on time and with a high quality of code
• Ability to deal with complex processes
• Minimum 5 years of experience in software development or similar role.
• Experience with data analysis.