Software Developer

Job ID: 65035

Software Analyst / Developer Data Migration & Application Modernization

Client: State of Connecticut - The Office of Early Childhood (OEC)

Duration: 12 Months

Location: Hartford CT

Hybrid

Position Summary

• The Office of Early Childhood (OEC) is seeking a Software Analyst / Developer to support a major modernization effort to replace a legacy application with a secure scalable cloud-based solution.
• This role combines requirements analysis software development and data migration validation responsibilities within an Agile Scrum framework. The candidate will be a key member of a cross-functional self-managed Scrum team collaborating with product owners developers testers and data specialists to deliver high-quality incremental releases.
• A significant aspect of this position involves supporting the project s data migration efforts including developing and executing automated reusable data testing scripts to validate migration accuracy across environments and documenting data and interface mappings between legacy and modernized systems.

Key Responsibilities

• Requirements Analysis & Documentation
• Collaborate with OEC stakeholders and technical teams to elicit analyze and document business and system requirements.
• Translate business needs into user stories and acceptance criteria maintaining a refined Azure DevOps product backlog.
• Document current and future state workflows integration points and data dependencies.
• Create and validate data mapping documents between legacy and modern systems.
• Develop interface mapping documentation to align legacy screens and functions with modernized application components.
• Define and maintain functional non-functional and reporting requirements ensuring end-to-end traceability.

Software Development & Technical Implementation

• Design develop and refactor components using MVC Entity Framework and Azure App Service.
• Contribute to CI/CD pipeline setup and optimization using Azure DevOps and Azure Git Repositories.
• Work with Azure SQL databases to design schema implement stored procedures and optimize performance.
• Collaborate with data engineers on SSIS-based ETL processes and data migration activities.
• Participate in code reviews ensuring adherence to best practices for performance maintainability and security.

Data Migration Validation & Testing

• Develop and maintain omnipotent (comprehensive reusable) data validation scripts to verify migrated data after each migration cycle in test environments.
• Validate record counts referential integrity field-level transformations and business rule consistency across environments.
• Identify and analyze data discrepancies collaborating with developers and data teams to resolve issues.
• Maintain documentation for data validation procedures testing outcomes and transformation logic.
• Support system integration and user acceptance testing (UAT) by creating and executing test cases.
• Log and manage defects and testing results using Azure DevOps.

Agile/Scrum Collaboration

• Serve as an active member of a cross-functional self-managed Scrum team responsible for delivering working software increments.
• Participate in all Scrum ceremonies including daily stand-ups sprint planning reviews and retrospectives.
• Work closely with the Product Owner to refine and prioritize backlog items and define sprint goals.
• Contribute to a culture of continuous improvement team collaboration and shared accountability.

Technical Skills & Qualifications Required:

• Proficiency in MVC and Entity Framework for web application development.
• Strong understanding of Azure platform services including Azure SQL App Service Azure DevOps CI/CD pipelines and Azure Git Repositories.
• Expertise in developing and executing automated data validation/testing scripts (SQL or other scripting languages).
• Strong grasp of relational databases data modeling and data mapping techniques.
• Experience documenting and validating legacy-to-modern data and interface mappings.
• Proficiency in Azure DevOps for managing work items test cases and defect tracking.
• Solid understanding of Agile/Scrum principles and practices.
• Proficiency in Microsoft Office Suite including Excel (for data analysis) and Visio (for process mapping).

Preferred:

• Experience with legacy system modernization or public-sector transformation projects.
• Knowledge of security access control and user role management in enterprise applications.
• Familiarity with API documentation system integration and report validation.

Key Deliverables

• User Stories with Acceptance Criteria

• Functional & Non-Functional Requirements
• Current/Future State Process Maps
• Legacy-to-Modern Data Mapping Documents
• Legacy-to-Modern Interface Mapping Documents
• Developed and Components
• Data Validation and Migration Testing Scripts
• Test Plans Test Cases and Test Results
• Traceability Matrix
• Deployment Artifacts via Azure DevOps CI/CD
• Status Reports and Issue Logs