Job Description
Scope of Services
The State of Connecticut Judicial Branch is looking to engage the services of a Lead Database Developer & Data Business Analyst. This role acts as Single Point of Contact (SPOC) between Business, App Dev, BI, and DBA teams to streamline communication, manage dependencies, and ensure the successful end-to-end delivery of joint initiatives. The scope of services required for the role includes:
Core Technical Skills:
The minimum skills and experience levels required for a candidate to be considered for this position include:
The selected candidate will be required to work 40 hours per week commencing on or around November 23, 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.
The State of Connecticut Judicial Branch is looking to engage the services of a Lead Database Developer & Data Business Analyst. This role acts as Single Point of Contact (SPOC) between Business, App Dev, BI, and DBA teams to streamline communication, manage dependencies, and ensure the successful end-to-end delivery of joint initiatives. The scope of services required for the role includes:
Core Technical Skills:
- 10+ years of experience with SQL Server, must include version 2014 through 2022.
- Tooling Requirements: Experience with tools (Visio/similar, Redgate, SQL Server Data Tools (SSIS, SQL Server Management studio (SSMS), Microsoft Visual Studio) is MUST. Azure DevOps/ Git, SQL Server Agent, Microsoft Service Broker experience is recommended.
- Requirements Gathering & Translation: Collaborate directly with Business Teams to elicit data storage and analytics needs, converting complex business logic into clean, structured relational table designs
- Cross-Team Schema Management:
- Serve as the proactive coordinator and gatekeeper for all data architecture updates. Ensure schema modifications are clearly communicated to the App Dev and BI teams to avoid application crashes or breaking downstream ETL/reporting pipelines
- Primary contact person to DBA team to coordinate planned database downtime window, manage access rights/ permissions and validate backup/restore to ensure uninterrupted database availability.
- Visual Data Modeling: Build, iterate, and strictly maintain logical and physical entityrelationship diagrams (ERDs) and workflow mappings utilizing Microsoft Visio or similar tool.
- Advanced T-SQL Development & Data Optimization:
- Troubleshoot performance issues using indexing and query tuning.
- Knowledge and experience in the design and creation of tables, views, indexes, foreign keys, including the use of appropriate data types, default constraints, etc.
- Significant experience of advanced SQL and T-SQL development, including designing and writing complex queries, data fix scripts, stored procedures, triggers, and user-defined functions
- Deployment & Release Guardrails: Utilize Redgate deployment suites to perform database schema comparisons, manage source control integrations, and safely package release scripts across Dev, QA environments.
- ETL & SSIS Core:
- Must demonstrate knowledge of ETL (Extract-Transform-Load) concepts and SSIS Tasks. Experience in incorporating requirements into technical flow chart highlights Control Flows, Data Flows, parameter/ variable configuration, error handling and deployment configurations.
- Knowledge and experience in the design and creation of XML schema, XML data storage and transformation
- Strong analytical and problem-solving skills.
- Ability to effectively manage time, prioritize tasks, and have a basic understanding of project management.
- Proactive in leading communication across teams.
- Excellent verbal communication skills to explain and transfer knowledge both informally and at design and code review meetings.
- Excellent written communication skills to prepare regular periodic status reports and documentation.
- Knowledge and experience of Microsoft Office Tools.
The minimum skills and experience levels required for a candidate to be considered for this position include:
- Minimum ten (10) years of development experience coding applications using SQL Server 2014 through 2022.
- Collaborate with all teams to review database requirements and maintain finalized documentation.
- Work closely with DBA team during release and post release activities.
- Knowledge and experience in the design and creation of tables, indexes, foreign keys, including the use of appropriate data types, default constraints, etc.
- Knowledge and experience of advanced SQL and T-SQL development, including designing and writing complex queries, stored procedures, triggers, and user-defined functions.
- Perform field mapping (mapping between the source and target structure with data cleansing, if necessary).
- Define the migration process (automated and manual).
- Develop data extractors and loaders.
- Responsible for data management and conversion activities such as Data Assessment, cleansing, extracting, migrating and reconciliation of data.
- Knowledge and experience in the design and creation of XML schema, XML data storage and transformation.
- XML knowledge is required for legacy data conversion into XML-based structures.
- Knowledge and experience in performance tuning techniques.
- Manage the data conversion process and data push process to the various environments.
- Create and maintain technical documentation.
- Provide management level statistics and reports to monitor data migration progress.
- Investigate, analyze and document reported defects.
- Investigate and rectify technical issues within the ETL process.
- Proven ability to work independently with minimal supervision.
- Ability to work well with a team of developers and business analysts.
The selected candidate will be required to work 40 hours per week commencing on or around November 23, 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.
Numbers & Facts
| Location | Glastonbury, CT |
| Industry | Computer/IT Services |
| Company Size | 100 to 499 employees |
| Year Founded | 1997 |
| Website | https://www.tscti.com/careers-0 |
About Company
22nd Century Technologies, Inc., is one of the fastest growing IT Service Integrator and Workforce Solution companies in the United States. Founded in 1997, 22nd Century Technologies is a Certified National Minority Business Enterprise with 6,000+ people including 600+ Cyber SMEs nationwide supporting our customers in all 50 states, Canada, and Mexico. With HQs in Somerset, NJ and Mclean, VA, 22nd Century has 14 offices throughout the United States. As part of our unrelenting focus on quality and compliance, 22nd Century Technologies’ delivery is based on Certified Matured Processes including CMMI L3 Dev & SVC, ISO 20000, ISO 27001, and ISO 9001 quality processes. With a strong focus on the public sector, 22nd Century currently holds government contracts with 14 out of 15 Federal Executive agencies including DoD, 37 other Federal agencies, 50 States, 115+ Local agencies, and 37 School Districts. In the last three years, we have expanded our services to Fortune 500 and other commercial clients and currently support 80+ commercial clients.
Recognized among “Best Company to Work For” by Forbes, 22nd Century Technologies, Inc., consistently exceeds our clients’ expectations by focusing on their absolute satisfaction with jobs while keeping our employees motivated.
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.
Skills
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesResume Builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Resume Builder