Azure .NET Business Systems Analyst

Software Analyst / Developer – Data Migration & Application ModernizationPosition Summary

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 Implementation

• 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.

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 & QualificationsRequired:

• 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).

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