> Markdown version of [/jobs/ext/3550076-lead-systems-analyst](https://www.wearedevelopers.com/jobs/ext/3550076-lead-systems-analyst). 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

- **Company:** KayDev Technology, LLC
- **Location:** Albany, NY, United States
- **Experience:** Expert
- **Contract:** Temporary contract
- **Skills:** Microsoft Access, ASP.NET, .NET Framework, Third Normal Form, Application Programming Interfaces (APIs), Business Process Management, C Sharp (Programming Language), Databases, Data Validation, Extract Transform Load (ETL), Data Mapping, Data Normalization, Data Profiling, Relational Databases, IBM Software, Microsoft SQL Server, Model View Controller (MVC), Oracle (Applications), Standard Sql, Reverse Engineering, SQL Databases, UML, Web Applications, Web Services, Freeform SQL, .NET Core, Macros, Analytic Functions, Backend, Vba Programming Language
- **Published:** September 30, 2026
- **Apply:** https://www.dice.com/job-detail/9d58c8d6-dbd7-49fc-b878-7118cbbcb105

## About the Role

* 84 months of experience in internal and external stakeholder communications and outreach, including presentations that promote business process reengineering
 * 84 months of experience as a Lead Systems Analyst or Systems Architect using UML, Data Flow Diagrams (DFDs), and entity-relationship modeling for As-Is/To-Be evaluations and technical gap analyses
 * 84 months of experience as lead analyst on business requirements projects, including logical and physical data modeling and data normalization (up to 3NF) into SQL Server or Oracle
 * 60 months of experience reverse-engineering legacy MS Access databases (tables, queries, forms, macros, VBA) and writing complex SQL (multi-table joins, subqueries, analytical functions)
 * 60 months of experience as a technical liaison between business stakeholders, vendors, and developers, producing ERDs, DFDs, and data mapping/ETL specifications
 * 48 months of experience analyzing, designing, or supporting systems integrated with IBM FileNet or Oracle

 * 36 months of experience developing multi-tier .NET Framework / .NET Core web applications in C# (Web Forms, MVC), including web services and APIs
 * Master's degree in a computer or technology-related field

## Description

We are seeking an experienced Lead Systems Analyst for a 30-month engagement with a New York State agency in Albany, NY. The Lead Systems Analyst will direct the end-to-end technical analysis, design, and modernization of enterprise systems. Responsibilities include As-Is/To-Be evaluations, reverse-engineering legacy MS Access applications, and designing normalized enterprise relational databases in SQL Server or Oracle. The analyst will also serve as the technical liaison between business stakeholders, software vendors, and application developers., * Lead As-Is/To-Be system evaluations, gap analyses, and system workflow design

 * Gather and document business process requirements for new applications
 * Reverse-engineer legacy MS Access databases, including tables, relationships, queries, forms, macros, and VBA modules
 * Design logical and physical data models and normalize legacy or flat-file structures (up to 3NF) into enterprise relational schemas
 * Write complex SQL queries for data validation, data profiling, and backend troubleshooting
 * Produce technical design artifacts: ERDs, DFDs, UML diagrams, and data mapping/ETL specifications
 * Develop presentations and materials that support business process reengineering


## Related Videos

- [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)
- [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)
- [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba)
- [Best practices: Building Enterprise Applications that leverage GenAI](https://www.wearedevelopers.com/videos/1513-best-practices-building-enterprise-applications-that-leverage-genai)
- [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’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)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)