Software Consultant

Job ID: 65035Software Analyst / Developer – Data Migration & Application Modernization Client: State of Connecticut - The Office of Early Childhood (OEC)Duration: 12+ MonthsLocation: Hartford, CTHybridPosition SummaryThe 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 ResponsibilitiesRequirements 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 ImplementationDesign, develop, and refactor components using ASP.NET 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 & TestingDevelop 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 CollaborationServe 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 RequiredProficiency in ASP.NET 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). PreferredExperience 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 DeliverablesUser 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 Tested .NET 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