Overview
Skills
Job Details
Role: Software Analyst / Developer Data Migration & Application Modernization
Duration: 6-12 months
Location: 100% REMOTE
Position Summary:
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 stakeholders and technical teams to elicit, analyze, and document business and system requirements.
- 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.
- 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.
Software Development & Technical Implementation
- Design, develop, and refactor components using ASP.NET MVC, Entity Framework, and Azure App Service.
- 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.
- Contribute to CI/CD pipeline setup and optimization using Azure DevOps and Azure Git Repositories.
- Work with Azure SQL databases to design schemas, implement stored procedures, and optimize performance.
Data Migration Validation & Testing
- Develop and maintain omnipotent (comprehensive, reusable) data validation scripts to verify migrated data after each migration cycle in test environments.
- 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 test results using Azure DevOps.
- 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.
Agile/Scrum Collaboration
- Serve as an active member of a cross-functional, self-managed Scrum team responsible for delivering working software increments.
- 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.
- Participate in all Scrum ceremonies including daily stand-ups, sprint planning, reviews, and retrospectives.
Technical Skills & Qualifications:
Required:
- 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.
- 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).
- 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.
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 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
Regards
Tim Patten
tim (at) pullskill (dot) com
551-272-o2o3