The agency continues to serve the interests of justice and the public by resolving matters brought before it in a fair, timely, efficient, and open manner. The meaningful, challenging, and interesting positions have a long-lasting effect that serves to advance justice and ultimately provides for the greater good of all.

East Hartford, Connecticut is known for family-friendly neighborhoods, affordable cost of living, scenic parks, and proximity to Hartford's amenities. Experience a suburban lifestyle with access to parks, schools, and community events while still enjoying easy commuting options. Embrace the charm of New England living in this welcoming and conveniently located town.

Overview:

• Agency is seeking a consultant under the job title specified above to assist with designing and re-engineering various systems in its criminal justice systems portfolio.

Scope of Work

In addition to the standard skills and qualifications for the job class, applicants should have experience in modernizing or rewriting older systems to meet current business function and security requirements:

• Design, create, deploy, and maintain data warehouse and business intelligence solutions.
• Develop data modelling, ETL solutions, and BI/analytical content using Microsoft SQL Server BI stack (SSRS/SSMS/SSIS), Excel, Tableau.
• Respond to ad-hoc data requests for information by writing complex T-SQL
• Collaborate with technical and non-technical stakeholders to solve complex business problems, by gathering requirements, prototyping and testing, or enhancing existing solutions to meet new requirements.

Technical Competencies:

• .NET Framework (4.6.2 and up)
• .NET 6 and above
• .NET MVC 5
• .NET Entity Framework 6 and Entity Framework CORE
• .NET WEB API
• Razor view and/or Blazer
• SQL Server (2016 and up)
• SSIS & SSRS
• IIS (8.5 and up)
• Azure Dev Ops
• SQL Server Performance Skills
• Optimize SQL queries (Query Execution Plans. etc.,)

• Simplify Index analysis.
• Resolve SQL Server deadlocks.
• Identify the root cause of SQL Server blockings.

• Bootstrap and JQuery
• Messaging APIs