What are the responsibilities and job description for the Software Consultant position at nLeague?
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
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.
- 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.
- Design, 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.
- 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.
- 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.
- Proficiency 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).
- 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.
- 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 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