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
