> Markdown version of [/jobs/ext/3096640-lead-systems-analyst-or-systems-architect](https://www.wearedevelopers.com/jobs/ext/3096640-lead-systems-analyst-or-systems-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Systems Analyst or Systems Architect - **Company:** Mvp Consulting Plus, Inc. - **Location:** Albany, United States (Remote available) - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** Legacy Database, Microsoft Access, ASP.NET, .NET Framework, Third Normal Form, Application Programming Interfaces (APIs), Business Process Management, C Sharp (Programming Language), Databases, Data Validation, Data Integrity, Extract Transform Load (ETL), Data Mapping, Data Migration, Data Normalization, Data Profiling, Data Security, Relational Databases, Document Management Systems, Electronic Data Interchange (EDI), Entity Relationship Models, IBM Software, Microsoft SQL Server, Model View Controller (MVC), Oracle (Applications), Reverse Engineering, SQL Databases, Systems Architecture, System Integration Testing, Systems Integration, UML, Web Applications, Web Services, Freeform SQL, Enterprise Software Applications, Macros, Analytic Functions, Backend, Database Migration, Vba Programming Language, Database Rules and Triggers - **Published:** September 26, 2026 - **Apply:** https://www.dice.com/job-detail/c83a9c2f-1c92-4561-a334-db57cc886054 ## About the Role 84 months experience with internal and external stakeholder communications and outreach, including the development of presentations and other materials that promote the rethinking of core business processes and envisioning of a reengineered environment. 60 Months of experience reverse-engineering legacy databases (specifically MS Access), including analyzing existing tables, relationships, queries, forms, macros, and VBA modules to identify structural anomalies, and writing complex SQL queries (including multi-table joins, subqueries, and analytical functions) to perform data validation, data profiling, and backend troubleshooting. 60 Months of experience acting as a technical liaison between business stakeholders, software vendors, and application developers to translate business requirements into highly technical system design artifacts, including Entity-Relationship Diagrams (ERDs), Data Flow Diagrams (DFDs), and detailed data mapping/ETL specifications. 48 Months of experience analyzing, designing, or supporting systems integrated with enterprise Document Management Systems (such as IBM FileNet) or enterprise relational databases (such as Oracle). 36 months experience as a developer developing and implementing multi-tier .Net Framework and .Net Core web applications using C# code leveraging ASP.Net patterns: Web Forms and Model-View-Controller (MVC); and designing and implementing system integration points, web services, or APIs to facilitate data exchange. 84 months of experience as a Lead Systems Analyst or Systems Architect directing the end-to-end technical analysis, design, and optimization of complex enterprise systems. Proven expertise utilizing advanced systems modeling methodologies-including Unified Modeling Language (UML), Data Flow Diagrams (DFDs), and entity-relationship modeling-to conduct comprehensive As-Is/To-Be system state evaluations, perform technical gap analyses, and architect scalable, high-performance system workflows and technical specifications. 84 months experience working on Business Requirements Project, as lead Analyst, which involved the application of strategies to gather and document business process requirements of new applications, with logical and physical data modeling, including data normalization (up to 3NF) to transform flat-file or legacy structures into enterprise relational database schemas (e.g., SQL Server, Oracle). Masters Degree in a computer or technology related field ## Description Candidate will work on existing and new initiatives including but not limited to Assessment Management System, Telecommunication Company Information, Pipeline Audit System (PAS), Document and Matter Management (DMM), and 753 Enforcement support, enhancements, and developments efforts. --- Day-to-Day Tasks --- 1. Requirements Gathering & Stakeholder Communication: Collaborate with Department of Public Service (DPS) program staff, business stakeholders, and external entities to gather, analyze, and document business requirements for key initiatives (including Assessment Management, Pipeline Audit, and 753 Enforcement). Lead business process reengineering sessions and deliver presentations on "As-Is" and "To-Be" system states. 2. Technical Analysis & System Modeling: Perform end-to-end technical analysis and design for complex enterprise systems. Author highly detailed technical specifications, system architecture maps, and advanced system models including Unified Modeling Language (UML) diagrams, Data Flow Diagrams (DFDs), and Entity-Relationship Diagrams (ERDs). 3. Legacy Database Reverse-Engineering & Normalization: Reverse- engineer legacy MS Access databases by analyzing tables, relationships, queries, forms, macros, and VBA modules. Identify data integrity issues and design normalized (up to 3NF) relational database schemas for target platforms like SQL Server and Oracle. 4. Technical Liaison & Logic Translation: Act as a technical liaison between business stakeholders, software vendors, and application developers. Translate complex business rules, compliance logic, and workflows into precise technical requirements, pseudocode, database constraints, and system logic for .NET/C# application developers and DBAs. 5. Integration & Document Management Design: Analyze, design, and support system integration points, web services, and APIs to facilitate secure data exchange. Coordinate integrations with enterprise Document Management Systems (such as IBM FileNet) and external agency databases. 6. Data Migration & ETL Planning: Develop comprehensive data migration strategies, data mapping matrices, and Extract, Transform, Load (ETL) specifications to ensure the seamless and secure transfer of legacy data into modernized target systems. 7. Technical Testing & Database Validation: Write and execute complex SQL queries (including multi-table joins, subqueries, and analytical functions) to perform data validation, verify database migration accuracy, conduct system integration testing (SIT), and troubleshoot backend technical issues. ## Related Videos - [".Net is too slow" was not an option](https://www.wearedevelopers.com/videos/100176-net-is-too-slow-was-not-an-option) - [ChatGPT and Java: A Match Made in Heaven or Hell?](https://www.wearedevelopers.com/videos/536-chatgpt-and-java-a-match-made-in-heaven-or-hell) - [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros) - [Building Multi-Tenant ASP.NET Core Applications: Best Practices and Real-World Solutions](https://www.wearedevelopers.com/videos/1552-building-multi-tenant-asp-net-core-applications-best-practices-and-real-world-solutions) - [Grappling With Clunky Old Software? Start by Understanding What’s Inside!](https://www.wearedevelopers.com/videos/1189-grappling-with-clunky-old-software-start-by-understanding-what-s-inside) - [Beyond UML: Making Sense of AI-Generated Code through Visual Architecture](https://www.wearedevelopers.com/videos/2102-beyond-uml-making-sense-of-ai-generated-code-through-visual-architecture) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)