2C
Software Engineer 3
22nd Century Technologies, Inc.
- πΊπΈ United States
- Hybrid
- Manager or above
- 17 hours ago
- Tableau
- Data Modeling
- ETL
- Microsoft SQL Server
- SSRS
- SSIS
- Excel
- T-SQL
- SQL
17 hours ago
The CT Judicial Branch Court Support Services Division's (JBCSSD) mission is to "Provide effective support services within the Judicial Branch by working collaboratively with system stakeholders to promote compliance with court orders and instill positive change in individuals, families and communities.β
The JBCSSD Business Intelligence (BI) Unit:
- Collaborates with stakeholders from the Division and Branch to promote and facilitate data-driven decision-making.
- Utilizes JBCSSD information systems and data development to extract raw data, transform the data into information, and then use the information to provide knowledge to JBCSSD for enhanced decision-making and action.
- Develops data platforms to increase data access across the organization.
- Provides dashboards/reports for stakeholders to enhance the services we provide clients.
- Develops reporting that is integrated into case management systems to provide enhanced intelligence to field staff.
- Evaluates process and program performance through research studies that rely heavily on data and statistical analysis. This can sometimes occur in partnership with colleges/universities and/or research organizations.
- Responds to ad-hoc data requests.
This position requires strong technical skills (such as data development, creation of dashboard/reports) and soft skills (such as communication and business knowledge). JB-CSSD utilizes the Microsoft BI stack and Tableau as the primary platforms and systems.
Scope of Services
The scope of services required for the Business Intelligence developer includes:
- Design, create, deploy, and maintain data warehouse and business intelligence solutions
- Develop data modeling, 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
The minimum skills and experience levels required for a candidate to be considered for this position include:
- A self-starter with strong analytical and problem-solving ability
- Minimum of 5 years' experience in gathering and analyzing business requirements
- Thorough understanding of data warehousing concepts, Star Schema design, and slowly changing dimensions
- Minimum of 5 years' experience assembling and validating large datasets for research/analysis
- Minimum of 9 years' experience with MS SQL Server, including SQL programming and scripting
- Minimum of 5 years' experience working with data in Excel
- Minimum of 9 years' experience as a database developer
- Minimum of 9 years' experience designing, troubleshooting and maintaining SSIS packages and Agent jobs.
- Minimum of 9 years' experience designing, troubleshooting and maintaining SSRS reports and dashboards.
- Minimum of 2 years' hands-on experience working in Tableau or equivalent (Tableau certification preferred).
- Collaborate with cross-functional teams to ensure data accuracy and usability
- Ability to work with staff of varying skill levels, both technical and non-technical
- Strong communications skills including written, verbal, presentation and interpersonal
- Proven ability to produce quality work independently, with minimal supervision
- Proven ability to handle multiple projects simultaneously
The selected candidate will be required to work 40 hours per week commencing on or around November 24, 2026. IT consultants are required to attend their first two days in person in Glastonbury, CT. Thereafter, consultants are currently allowed to work remotely 100% with the project manager's approval.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
Software Engineer 3 Β· 22nd Century Technologies, Inc.