Lead SQL/ETL Developer

ESG Consulting; Connecticut; On-site; USD 110,000 - 150,000; Full time

Job summary

ESG Consulting is seeking an experienced Lead SQL/ETL Developer (SSIS, SSRS & Tableau) to support enterprise data integration, reporting, and modernization initiatives. The role emphasizes technical leadership across SQL Server, T-SQL, SSIS, SSRS, and Tableau, with exposure to SACWIS modernization projects and collaboration with stakeholders.

The ideal candidate will lead complex data integration efforts, own technical deliverables, and drive projects end-to-end, supporting existing .NET

Qualifications

• 10+ years of overall IT experience with hands-on SQL development, ETL and data integration.
• 5+ years of Tableau experience building complex reports and dashboards.
• 5+ years writing complex SQL queries with performance tuning.
• 5+ years experience with T-SQL, SSIS, SSRS or Talend in data integration.
• Strong troubleshooting, analytical and problem‑solving skills.
• Excellent communication and cross‑functional collaboration abilities.

Responsibilities

• Lead design, development, implementation and maintenance of SQL Server databases and ETL solutions.
• Develop and optimize complex SQL queries, stored procedures, triggers, and T-SQL scripts.
• Design, deploy and troubleshoot SSIS packages for ETL processes.
• Develop and maintain Tableau dashboards, reports and SSRS solutions.
• Lead data migration and conversion activities from legacy systems.
• Define data integration processes including mapping, cleansing, validation, reconciliation and error handling.
• Optimize ETL performance and SSIS package execution.
• Develop data models, relational schemas, data marts and data dictionaries.

Skills

IT experience

Tableau

SQL queries

T-SQL/SSIS/SSRS

Problem solving

Communication & collaboration

Tools

Git

SQL Server Agent

TFS

Talend

Salesforce

MuleSoft

Job description

Our client is seeking an experienced Lead SQL/ETL Developer (SSIS, SSRS & Tableau) to support enterprise application modernization, data integration, reporting, and legacy system migration initiatives.

The ideal candidate will have extensive experience with SQL Server, T-SQL, SSIS, SSRS, and Tableau, along with strong technical leadership skills and the ability to independently drive development activities from requirements through implementation.

This role involves supporting existing .NET applications and participating in the modernization of a Statewide Automated Child Welfare Information System (SACWIS), working closely with business stakeholders and system integrators.

Key Responsibilities

• Lead the design, development, implementation, and maintenance of SQL Server databases and ETL solutions.
• Develop, maintain, and optimize complex SQL queries, stored procedures, triggers, and T-SQL scripts.
• Design, develop, deploy, and troubleshoot SSIS packages for data extraction, transformation, integration, and loading.
• Develop and maintain Tableau dashboards, reports, and SSRS reporting solutions.
• Lead data migration and conversion activities from legacy systems to modern platforms.
• Design and implement data integration processes, including data mapping, cleansing, validation, reconciliation, and error handling.
• Optimize SQL queries, SSIS package execution, and overall ETL performance.
• Develop and support data models, relational database structures, data marts, and data dictionaries.
• Integrate data from multiple sources, including SQL Server, DB2, and external systems.
• Configure and deploy SSIS packages using version control, environment variables, and SQL Server Agent jobs.
• Work with business analysts, stakeholders, and system integrators to validate requirements, designs, and technical deliverables.
• Participate in the complete SDLC, including requirements analysis, development, testing, deployment, production support, and documentation.
• Provide technical ownership, troubleshoot complex issues, and support knowledge transfer for ongoing application maintenance.

Required Qualifications

• 10+ years of overall IT experience, with strong hands-on SQL development, ETL, and data integration experience.
• 5+ years of Tableau experience, including developing complex reports and dashboards.
• 5+ years of experience writing complex SQL queries, including performance tuning and optimization.
• 5+ years of experience with T-SQL, SSIS, SSRS, or Talend.
• Strong experience developing and maintaining stored procedures, triggers, and database objects.
• Experience deploying SSIS packages using Git, environment variables, and SQL Server Agent.
• Experience with data migration, data conversion, data mapping, and ETL/ELT processes.
• Experience with SQL Server and integrating data from multiple database platforms.
• Experience with version control tools such as Team Foundation Server (TFS).
• Strong troubleshooting, analytical, and problem-solving skills.
• Demonstrated ability to independently own technical deliverables and drive projects from requirements through implementation.
• Excellent communication and cross-functional collaboration skills.

Preferred Qualifications

• Experience with Salesforce and MuleSoft.
• Experience with SACWIS, child welfare systems, or government modernization projects.
• Experience working with system integrators and supporting knowledge transfer.
• Experience with service-oriented architecture (SOA) and enterprise data integration.

Ideal Candidate

We are looking for a hands-on technical lead, not just a developer with a senior title. The successful candidate must demonstrate strong SQL/ETL development expertise, independent technical ownership, experience leading complex data integration initiatives, and the ability to deliver solutions with minimal supervision.