Starting at 100k+
Hybrid Schedule (2-3 days onsite)
Perm Position
Needs to be local to WINSTON SALEM, NC
CORE REQUIREMENTS:
8+years of Professional experience
4+ years of SQL Programming (T-SQL - Stored Procedures, Functions, Triggers, Packages)
3-4+ years of SSRS/SSIS experience
3+ years of Scripting experience (Python, Powershell, JavaScript, etc)
2+ years of ETL experience (extract, transform, load)
Bachelors degree in Computer Science or Information Technology
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.
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
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
Job Type: Full-time
Pay: From $100,000.00 per year
Benefits:
- 401(k)
- Dental insurance
- Health insurance
Experience level:
Schedule:
Work Location: In person