Systems Analyst - Expert

Provide a short description of the Position: Candidate will work on existing and new initiatives including but not limited to Assessment Management System, Telecommunication Company Information, Pipeline Audit System (Client), Document and Matter Management (DMM), and 753 Enforcement support, enhancements, and developments efforts.

Provide a list of the day-to-day tasks to be performed by the Selected Candidate: " 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. " 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). " 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. " 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. " 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.
" 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. " 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.