Lead System Analyst

Mindlance; City of Albany (NY); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Mindlance in Albany, NY invites a Lead System Analyst for a 30-month contract in a hybrid role. You will lead end-to-end technical analysis, design, and optimization of complex enterprise systems, guiding stakeholders and vendors through AS-IS to To-Be transformations.

Candidates bring 7+ years in UML/DFD/ER modeling, data modeling, SQL, ETL specifications, and .NET ASP.NET MVC; strong liaison skills between business and IT are essential.

Qualifications

• 84 months of stakeholder communications and outreach supporting business process reengineering.
• 84 months as Lead Systems Analyst or Systems Architect directing end-to-end technical analysis and design using UML/DFD/ER modeling.
• 84 months leading Business Requirements projects with data modeling and normalization to 3NF.
• 60 months reverse-engineering legacy MS Access databases and writing complex SQL with joins/subqueries.
• 60 months liaising between business, vendors and developers to produce ERDs, DFDs, and ETL specs.
• 48 months analyzing or supporting systems with IBM FileNet or Oracle databases.
• 36 months developing multi-tier .NET projects using C# with ASP.NET MVC; building integrations and APIs.

Skills

Stakeholder communications

Lead analyst mindset

UML

DFDs

ER modeling

Data modeling

SQL queries

ETL specifications

C#

ASP.NET MVC

Web services / APIs

Data normalization

Tools

MS Access

IBM FileNet

Oracle

SQL Server

.NET Framework

.NET Core

Job description

Job Title: Lead System Analyst

Location: Hybrid at Albany, NY

Employment: 30 Months Contract

Job Details:

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

"Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."