Senior Full Stack .NET/Azure Developer

ESG Consulting; Hartford (CT); On-site; USD 110,000 - 150,000; Full time

Job summary

ESG Consulting is seeking a Senior Full Stack .NET/Azure Developer who currently resides in Connecticut. You will design and develop web-based customer-facing UI, create Power Apps, and implement enhancements/bug fixes for existing .NET applications within an Agile Scrum team.

The role includes requirements analysis, data migration validation, and collaboration with product owners, developers, testers, and data specialists to deliver incremental releases.

Qualifications

• Proficiency in ASP.NET MVC and Entity Framework for web application development.
• 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 and Visio.

Responsibilities

• Collaborate with OEC stakeholders to elicit, analyze, and document requirements.
• Translate needs into user stories and maintain a refined Azure DevOps 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 with modernized components.
• Define and maintain functional, non-functional, and reporting requirements with 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.
• Work with Azure SQL databases to design schema and optimize performance.
• Collaborate on SSIS-based ETL processes and data migration activities.
• Participate in code reviews for performance, maintainability, and security.
• Develop and maintain comprehensive data validation scripts for migrated data.

Skills

ASP.NET MVC

Entity Framework

C#

Agile/Scrum

SQL scripting

Data migration

Azure SQL

Power Apps

Tools

Azure DevOps

Azure App Service

SSIS

SQL Server Management Studio

Job description

Senior Full Stack .NET/Azure Developer needed -must currently reside in CT. Seeking a Senior Developer to support development work across OEC, include design and development of Power Apps, web base customer facing UI, and enhancements/bug fixes for current .NET applications.

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 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 & Qualifications

Required:

• Proficiency in ASP.NET MVC and Entity Framework for web application development.
• 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.
• 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