SQL & ETL Developer (Mid level, 5-7 years)

Central Point Partners

Columbus, OH

JOB DETAILS
SKILLS
Amazon Web Services (AWS), Analysis Skills, Cloud Computing, Communication Skills, Computer Programming, Computer Science, Data Modeling, Database Design, Database Extract Transform and Load (ETL), Database Optimization, Database Technology, Finance Software, GitHub, Groovy Programming Language, IT Service Management (ITSM), Identify Issues, Incident Management, Information Technology & Information Systems, Knowledge Base, Microsoft C# (C Sharp), Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Visual Basic.NET, Microsoft Windows Azure, Performance Tuning/Optimization, Problem Solving Skills, Production Control, Production Support, Python Programming/Scripting Language, Query Optimization, Requirements Management, Root Cause Analysis, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Scripting (Scripting Languages), ServiceNow, Software Development, Source Code/Configuration Management (SCM), Stored Procedures, Systems Maintenance, Technical Writing, Time Management
LOCATION
Columbus, OH
POSTED
3 days ago
SQL & ETL Developer - (Mid level, 5-7 years)

Job Summary
We are seeking a seasoned Programmer/Analyst with strong SQL and ETL development expertise to join our team. The ideal candidate will have at least 5 years of experience in application development and support, with a focus on MS SQL Server and SSIS-based ETL processes. This role also requires hands-on experience in production support, ensuring the reliability and performance of critical financial applications.

Key Responsibilities
  • Design, develop, and maintain complex SQL queries, stored procedures, and database objects
  • Build and optimize ETL workflows using SSIS to support data integration and transformation
  • Monitor and support production jobs, troubleshoot issues, and ensure timely resolution
  • Collaborate with business and technical teams to gather requirements and deliver solutions
  • Perform root cause analysis and implement preventive measures for recurring issues
  • Participate in performance tuning and optimization of database systems
  • Document technical processes and maintain system knowledge base

Required Qualifications
  • 7+ years of experience in application development and support
  • Proficiency in MS SQL Server, including T-SQL, performance tuning, and query optimization
  • 5+ years of hands-on experience with ETL development using SSIS
  • 1+ year of Python
  • Batch and Groovy Scripting
  • Knowledge of AWS
  • Strong understanding of relational database design and data modeling
  • Experience in production support, including incident management and job monitoring
  • Excellent problem-solving and communication skills
  • Bachelor's degree in Computer Science, Information Systems, or related field or equivalent professional experience.

Preferred Skills
  • Experience with scheduling tools (e.g., Zena, Control-M, or similar)
  • 2+ years experience with C#
  • 1+ year experience in VB.net
  • Familiarity with version control systems like GitHub
  • Exposure to cloud platforms (e.g., AWS or Azure)
  • Knowledge of ServiceNow or similar ITSM tools

About the Company

C

Central Point Partners