Programmer/Developer

Abacus•Hartford, CT

1d•Hybrid

About The Position

The State of Connecticut Department of Children and Families (DCF) is seeking a senior-level Lead Full Stack Developer for its Information Systems Division. The role supports existing .NET applications and participates in the software development lifecycle for the next-generation Comprehensive Child Welfare Information System (CCWIS), working with the System Integrator to transfer knowledge and support ongoing maintenance for an assigned module. The developer will create and maintain Tableau reports, SSRS reports, and SSIS ETL packages; support service-oriented architecture (SOA) integration initiatives; and participate in requirements verification, design, development, testing, maintenance, and support. The role also contributes to database architecture, data modeling, data migration and integration, data quality, data analytics, ETL/ELT solutions, and reporting. The position is scheduled for 40 hours per week, Monday through Friday, 8:00 AM to 5:00 PM, and is listed as hybrid at 505 Hudson Street, Hartford, Connecticut.

Requirements

At least 10 years of prior experience demonstrating the stated knowledge and skills; the State IT Professional Services Agreement classification requirements for Solution Architect also apply.
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 environment variables, and creating corresponding SQL Agent jobs.
Strong problem-solving, cross-functional analysis, and forward-thinking abilities.
Ability to adapt to changing situations, handle multiple tasks, and meet tight deadlines.
Must be organized, proactive, self-directed, and driven, with the ability to work independently.
Strong abstract thinking and problem-solving skills.
Very good verbal and written communication skills.
Ability to drive work from requirements through implementation.
Comply with vendor qualification requirements, the DCF Child Protection Background Check, and the DCF Non-disclosure Agreement.

Nice To Haves

Experience with Salesforce.
Experience with MuleSoft.
Experience with Transact-SQL and stored procedures is desired.
Experience creating, deploying, and maintaining Talend reports.
Experience with code control/versioning using Team Foundation.

Responsibilities

Develop Tableau reports and create, deploy, and maintain reports according to user requirements.
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 resolving data discrepancies.
Assist with migrating and integrating data and processes from legacy systems to new applications and technologies.
Develop and maintain documented custom SQL scripts, stored procedures, and triggers using Microsoft T-SQL 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 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 to meet business requirements.
Design and implement data conversion strategies for moving from legacy to new platforms.
Validate designs and perform reconciliation and error handling in data load processes.
Optimize SSIS package and SQL execution for data-load performance.
Design SSIS packages for data exchange, including file transfer and secure file transfer, and import and export files using FTP/SFTP.
Participate in requirements gathering, data mapping, extraction, loading, testing, troubleshooting, documentation, performance optimization, and maintenance.
Develop reports using Tableau and deploy them to a report server or integrated SharePoint report server.
Create reporting features including dynamic grouping and sorting, on-demand subreports, drill-down and summary reports, and crosstab reports.
Participate in SDLC activities for existing .NET applications and the new SACWIS system, including meetings with the System Integrator and verification of requirements, designs, testing, and environment configuration.
Drive work from requirements through implementation and provide maintenance and support as directed by agency management.