Required Skills: HTML, CSS

Job Description

The Connecticut Department of Public Health (CT-DPH) aims to predict, prevent, detect, and respond to public health threats faster and more efficiently than ever before. Under this initiative, CT-DPH is committed to achieving this vision by developing and deploying approaches that move the public health community from siloed and brittle public health data systems to connected, resilient, adaptable, and sustainable ‘response-ready’ systems capable of meeting today and tomorrow’s health challenges.  

(Data Modernization Initiative (DMI) Program Overview  

Various sections and programs currently track and manage critical information through disparate Excel files and Word documents. This manual, unstructured approach creates compliance risks, missed deadlines, and limited data visibility. Transitioning from a paper-based workflow to an automated Microsoft Power BI ecosystem through a Data Submissions and CGMS Portal has been a comprehensive, modernized, and successful strategy.  The core program goals focus on eliminating manual data entry, enforcing data governance, and providing stakeholders with real-time decision-support capabilities and data analytics.

Workstream Overview – (CGMS) Contracts, Grants, Management SystemThe (CGMS) Contracting process manages the full lifecycle of contract development and execution, progressing through the following key stages.  The current environment combines manual and system-assisted processes that support the full lifecycle of grants, contracting, financial reporting, and payment/refund activities. The process begins with the Contractor Information Intake process and moves through the below steps/phases, ending with the routing, approval, and execution phase.

• Contractor Information Intake: Program initiates the process by providing contractor details and required supporting documentation.
• Electronic Department Agreement Request (EDAR) Checklist Preparation: Program compiles and validates all required documentation, approvals, and data elements necessary for contract routing.
• Electronic Department Agreement Request (EDAR) Submission: The formal contract request is submitted through the EDAR system, including fiscal data, contract type, and supporting materials for CMS review.
• Legal Review & Contract Language: Contract language is reviewed and revised collaboratively by Legal, Program, and CMS.
• Contract Development & Initiation: CMS prepares the appropriate contract template and ensures readiness for execution.
• Routing, Approval & Execution: The Contract Specialist manages approvals, signatures, and final contract execution and distribution.