Programmer / Developer

STATE OF CONNECTICUT

DEPARTMENT OF CHILDREN AND FAMILIES

STATEMENT OF WORK FOR CCIWS PROGRAM

SENIOR TABLEAU REPORT DEVELOPER / ETL

• . REQUIRED AGENCY :

Department of Children and Families

DCF IS Division

Hudson Street

Hartford, CT

The Department of Children and Families depends on the core, mission-critical applications, LINK and IV-E, Connecticut’s Federally-reimbursed SACWIS (Statewide Automated Child Welfare Information System). Implemented in , available on every desktop, and used by over , social workers and case managers, the application has been enhanced and modified continually to meet data capture and process functionality requirements driven by good child welfare case practice as well as State and Federal legislation and statute. Additionally, LINK continues to experience change chiefly in compliance with the Juan F. Consent Decree as well as the agency’s ongoing goal of improving the safety, permanency and well-being of children in care. The agency is currently committed to developing the next generation Comprehensive Child Welfare information system (CCWIS) and has invested significant resources to ensure that Connecticut has efficient, economic and effective tools to aid our Child Welfare Staff, Providers and the children and families of CT.

DCF Information Systems provides technology expertise and services as well as an information systems infrastructure to the agency and its roughly , employees. DCF Information Systems strives to improve continually improving technology services that are cost-effective and of the highest effectiveness and quality.

The agency needs the service of a senior level Lead Full Stack Developer. The candidate will serve in the capacity of a Lead Developer participating in various SDLC processes including requirements verification, design and development, testing, maintenance, and support activities per the direction of agency management. The specific focus of this candidate will be the to be part of the team which supports existing .NET applications as well as to participates in the SDLC process of the new SACWIS system and work with the System Integrator to ensure the transfer of knowledge and on-going maintenance of the solution for a given module. Specifically, the candidate will be responsible for creating / maintaining SSRS reports and SSIS ETL packages ,supporting SOA integration initiatives and participating in the SDLC process which includes meetings with the SI, verification of deliverables such as requirements, design, testing, and environment configuration.

Specific Services Required :

In the role of the Lead Developer, the following services are required :

In this role, the following services are required :

REQUIRED SKILLS AND EXPERIENCE

Refer to the State contracts for IT Professional Services Agreement (PSX) for experience and skill requirements for the job classification Solution Architect to fill the role. In addition, the agency requires :

A or more years of prior experience demonstrating the following knowledge and skills :

Additional Preferred Qualifications :

WORK SCHEDULE : Full-Time hrs - Monday - Friday, AM - PM

STATE RESOURCES AND OVERSIGHT : DCF IS Management

SECURITY / PRIVACY CONSIDERATIONS : Comply with Vendor Qualification, DCF Child Protection Background Check and DCF Non-disclosure Agreement

GENERAL / MISCELLANEOUS :

POINT OF CONTACT :

Iancu Nicolae

Application Development Manager

State of Connecticut

Department of Children and Families

Mobile