Position summary:

This database development position supports transaction processing and analytics for The Clearing House’s high-volume payment products (Wire, ACH, etc.). Primary responsibilities include the design, development, and modernization of TCH’s core database applications. The position requires significant experience developing high-performing applications on relational and non-relational databases, particularly Microsoft SQL Server. Other key requirements include expertise building scalable and reliable ETL pipelines to integrate batch and real-time data feeds with other systems. The ideal candidate will have extensive experience in Microsoft database development as well as a keen interest in re-engineering existing applications to leverage new technologies, including cloud-based services such as AWS data services.

Qualifications required:

• Bachelor’s degree in Computer Science or equivalent degree or experience
• Strong experience in Microsoft SQL database development experience with at least 4 years of operational experience in an enterprise database environment and 4 years of programming experience
• Experience with MS SQL Server 2016 or newer, including familiarity with T-SQL, SSIS and SSRS
• Experience in programming languages, such as .NET, Java, or Python, and scripting such as Powershell
• Expertise in scalable database performance, including optimizing SQL queries and transactions
• Familiarity with team development, source code management, and CI/CD automation
• Detail-oriented with excellent organizational, follow-up, and analytical skills
• Excellent verbal and written communication skills

Essential functions and responsibilities:

• Design, develop, and maintain large scale database applications supporting critical transaction and analytic workloads for the company and our customers
• Design, develop, and maintain Business Intelligence applications to support key data-driven functions
• Collaborate with developers and database administrators (DBA’s) to design data-driven services
• Create and automate ETL processes and pipelines to deliver data reliably to downstream systems
• Work with other internal groups and external customers to design optimal solutions
• Use automated development tools to manage source code, versioning, and deployments

Success factors/job competencies:

• Ability to design and implement high-quality solutions
• Effectively interact with other teams; resourceful when working independently
• Timely and accurate completion of tasks to meet product delivery deadlines

Performance standards:

• Complete development projects on time and with high quality
• Ability to quickly troubleshoot issues and provide fixes
• Maintain a high level of quality in coding standards and development practices
• Contribute to development standards and assist with evaluation of others’ work
• Continue to improve development skillsets and familiarity with new technologies