System Analyst - HBITS-08-15024

About the role

This is an on-site, long-term (30-month) System Analyst position (requisition HBITS-08-15024) with the Department of Public Service in Albany, NY 12223. Interviews are conducted in person. The role does not offer visa sponsorship. The analyst will work on existing and new initiatives across multiple systems.

Responsibilities

• Assessment Management System
• Telecommunication Company Information
• Pipeline Audit System (PAS)
• Document and Matter Management (DMM)
• 753 Enforcement support, enhancements, and development efforts

Requirements

• 84 months of experience with internal and external stakeholder communications and outreach, including development of presentations and materials that promote rethinking of core business processes and envisioning a reengineered environment.
• 84 months of experience as a Lead Systems Analyst or Systems Architect directing 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 of experience working on Business Requirements Projects as a lead Analyst, involving 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 of 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.
• Master's Degree in a computer or technology related field.