Lead Data & BI Developer - Tableau, SQL & ETL

JSM Consulting Inc.; Hartford (CT); On-site; USD 110,000 - 150,000; Full time

Job summary

JSM Consulting Inc. is seeking a senior Lead Full Stack Developer with deep experience in data modeling, Tableau reporting, SQL scripting, and SSIS/ETL.

The role focuses on CT state systems, including the SACWIS ecosystem, and requires onsite presence with occasional weekly visits to the NY area for interviews. The candidate will oversee SDLC activities, collaborate with system integrators, and drive the creation and maintenance of data pipelines, reports, and data quality processes across

Qualifications

• 10+ years of IT experience with data and BI stacks.
• Strong Tableau and SQL proficiency with complex queries.
• Experience with SSIS/SSRS and ETL/ELT design.
• Ability to collaborate with business analysts and SI teams.

Responsibilities

• Lead development of Tableau reports and SSRS reports.
• Design and maintain ETL/ELT pipelines and data models.
• Coordinate with BI team to validate requirements and deliverables.
• Migrate data from legacy systems and integrate with new platforms.
• Optimize SQL and SSIS performance for large data loads.

Skills

Tableau Reports

SQL Queries

ETL/ELT

SSIS Packages

Data Modeling

SSRS Reports

T-SQL

Data Integration

Tools

SQL Server

DB2

SSIS

SSRS

Job description

JSM Consulting Inc. is seeking a senior Lead Full Stack Developer with deep experience in data modeling, Tableau reporting, SQL scripting, and SSIS/ETL.

The role focuses on CT state systems, including the SACWIS ecosystem, and requires onsite presence with occasional weekly visits to the NY area for interviews. The candidate will oversee SDLC activities, collaborate with system integrators, and drive the creation and maintenance of data pipelines, reports, and data quality processes across