Lead Full Stack Developer

NOVALINK SOLUTIONS LLC

. Serve as a senior-level Lead Full Stack Developer for Connecticut DCF information systems .

Posted 10/22/2026full-timeHartford • Connecticut • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive experience in Full Stack Development, particularly with .NET applications, SQL Server, and ETL processes. Proficient in data analytics, report generation using Tableau, and optimizing data workflows while ensuring compliance with regulatory requirements.

Highest-signal resume keywords

Full Stack DevelopmentSQL Query OptimizationETL/ELT Solutions DevelopmentTableau Report CreationSSIS Package Deployment

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Full Stack DevelopmentSQLT-SQLSSRSSSISTableauETLData MigrationData ModelingData Analytics

Soft Skills

Problem-SolvingAdaptabilityOrganizational SkillsCommunication SkillsCross-Functional Analysis

Tools & Technologies

GitTeam FoundationSalesforceMuleSoftDB2

Industry Keywords

DCFChild ProtectionVendor QualificationData QualityLegacy Systems

Tech Stack

Tools & technologies

ETLSDLCSQLSSISTableau.NET

About the role

Key responsibilities & impact

Serve as a senior-level Lead Full Stack Developer for Connecticut DCF information systems
Participate in requirements verification, design, development, testing, maintenance, and support activities
Support existing .NET applications and participate in the SDLC for the new SACWIS/CCWIS system
Work with the System Integrator to verify deliverables, transfer knowledge, and support ongoing module maintenance
Create and maintain SSRS reports and SSIS ETL packages
Support SOA integration initiatives
Develop Tableau reports and deploy reports to a report server or integrated SharePoint report server
Assist with database architecture, including relational data structures, data marts, data dictionaries, and logical and physical data models
Develop strategies for data acquisition, data quality, and discrepancy management
Migrate and integrate data and processes from legacy systems to new applications and technologies
Develop and maintain documented T-SQL scripts, stored procedures, and triggers according to business rules
Access data in DB2, SQL Server, and other database management systems
Design, develop, and implement ETL/ELT solutions for ingestion, cleansing, business-rule execution, and data distribution
Apply data analytics best practices to data modeling, ETL pipelines, and near-time data solutions
Coordinate with business analysts and users to validate requirements
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 to new platforms
Perform design validation, reconciliation, error handling, troubleshooting, documentation, performance optimization, and maintenance
Optimize SSIS package and SQL execution for data-load performance
Design SSIS packages for file transfer and secure file transfer, including FTP/SFTP import and export
Participate in requirements gathering, data mapping, extraction, loading, testing, troubleshooting, documentation, optimization, and maintenance
Create dynamic grouping, sorting, on-demand subreports, drill-down, summary, and crosstab reports

Requirements

What you’ll need

10 or more years of prior experience demonstrating the required knowledge and skills
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, 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
Experience with Transact-SQL and stored procedures desired
Experience creating, deploying, and maintaining Talend reports
Experience with code control/versioning using Team Foundation
Strong problem-solving, cross-functional analysis, and forward-thinking abilities
Flexibility to adapt to changing situations, handle multiple tasks, and meet tight deadlines
Experience with Salesforce preferred
Experience with MuleSoft preferred
Very organized, proactive, self-directed, self-starting, and driven
Strong abstract thinking and problem-solving skills
Very good verbal and written communication skills
Must comply with Vendor Qualification requirements, DCF Child Protection Background Check, and DCF Non-disclosure Agreement

Benefits

Comp & perks

Full-time, 40 hours per week, Monday–Friday, 8 AM–5 PM
Hybrid work arrangement
Opportunity to work on mission-critical Connecticut child welfare information systems
Professional involvement across requirements, design, development, testing, maintenance, and support
Experience with state government technology and SDLC processes