Lead Full Stack Developer - Hybrid Hartford, CT

Novalink Solutions LLC • Hartford, CT

1d • Hybrid

About The Position

The Department of Children and Families (DCF) seeks a senior-level Lead Full Stack Developer to support Connecticut’s child welfare information systems, including the existing LINK and IV-E applications and development of the next-generation Comprehensive Child Welfare Information System (CCWIS). The role participates in software development lifecycle (SDLC) activities—including requirements verification, design, development, testing, maintenance, and support—under agency management direction. The developer will work with the system integrator (SI) to support the new SACWIS system, verify deliverables, and support knowledge transfer and ongoing maintenance for an assigned module. The work also includes creating and maintaining reports and ETL packages and supporting service-oriented architecture (SOA) integration initiatives.

The Lead Developer will develop Tableau reports; contribute to database architecture and data models; build and maintain SQL scripts, stored procedures, triggers, and ETL/ELT solutions; and support data migration, integration, validation, and performance optimization. The position works with business analysts and users to validate requirements and is involved across the data lifecycle, from requirements gathering and mapping through extraction, loading, testing, troubleshooting, documentation, optimization, and maintenance. The role requires an organized, proactive, self-directed approach, strong problem-solving and abstract-thinking skills, and effective written and verbal communication.

Requirements

• At least 10 years of prior experience demonstrating the required knowledge and skills; the posting also refers to the State IT Professional Services Agreement classification requirements for Solution Architect.
• More than 5 years of experience with Tableau.
• More than 5 years of experience writing complex SQL queries.
• More than 5 years of expertise with T-SQL, SSRS, and SSIS or Talend.
• Experience debugging and improving query performance.
• Experience deploying SSIS packages using Git check-in, setting up environmental variables, and creating corresponding SQL Agent jobs.
• Strong problem-solving, cross-functional analysis, and forward-thinking abilities.
• Flexibility to adapt to changing situations, handle multiple tasks, and meet tight deadlines.
• Strong verbal and written communication skills.
• Organized, proactive, self-directed, and able to drive work from requirements through implementation.

Nice To Haves

• Experience with Salesforce.
• Experience with MuleSoft.
• Experience with Transact-SQL and stored procedures.
• Experience creating, deploying, and maintaining Talend reports.
• Experience with Team Foundation version control.

Responsibilities

• Develop Tableau reports and deploy them to a report server or integrated SharePoint report server.
• Assist with database architecture design and development, including relational data structures, data marts, data dictionaries, and logical and physical data models.
• Develop strategies for data acquisition, data quality, and addressing data discrepancies.
• Assist with migration and integration of data and processes from legacy systems to new applications and technologies.
• Develop and maintain documented custom Microsoft T-SQL scripts, stored procedures, and triggers in accordance with business rules and requirements.
• Access data stored in database management systems such as DB2 and SQL Server.
• Design, develop, and implement ETL/ELT solutions for data ingestion, cleansing, business-rule execution, and data distribution.
• Apply data analytics best practices in data modeling, ETL pipelines, and near-time data solutions.
• Coordinate with business analysts and users to validate requirements.
• Implement solutions to integrate external data with in-house data.
• Test and validate data flows and prepare ETL processes according to business requirements.
• Design and implement data conversion strategies from legacy systems to new platforms.
• Perform design validation, reconciliation, and error handling in data-load processes.
• Optimize SSIS package and SQL execution to improve data-load performance.
• Design SSIS packages using file-exchange tasks, including secure file transfer, and import and export files through FTP/SFTP.
• Participate in requirements gathering, data mapping, data extraction and loading, data testing, troubleshooting, documentation, performance optimization, and maintenance.
• Create reports using Tableau according to user requirements and deploy them to a report server or integrated SharePoint report server.
• Create reports using dynamic grouping and sorting, on-demand subreports, drill-down and summary features, and cross-tab reports.
• Participate in SDLC activities for existing .NET applications and the new SACWIS system, including requirements verification, design, development, testing, maintenance, and support.
• Work with the system integrator to verify requirements, design, testing, and environment-configuration deliverables and support knowledge transfer and ongoing module maintenance.
• Create and maintain SSRS reports and SSIS ETL packages and support SOA integration initiatives.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed