Lead Systems Analyst / Systems Architect

Trigyn Technologies Limited; City of Albany (NY); On-site; USD 110,000 - 160,000; Full time

Job summary

Trigyn Technologies, Inc. seeks a Lead Systems Analyst / Systems Architect in Albany, NY to drive requirements capture, system modeling and integration across enterprise platforms for a government client.

You will model systems with UML/DFD/ERD, reverse-engineer legacy MS Access data, and translate business rules into precise technical specifications for .NET/C# developers and DBAs.

Qualifications

• Specializes in analysing, designing and implementing information systems.
• Uses analysis and design techniques to solve business problems using information technology.
• Serves as change agent who identifies organisational improvements and trains others to use the systems.
• 84 months experience with stakeholder communications and outreach.
• 84 months as Lead Systems Analyst or Systems Architect directing end-to-end technical analysis, design and optimisation of complex systems.
• 60–84 months reverse-engineering legacy databases (MS Access) and writing complex SQL queries.

Responsibilities

• Gather and document business requirements for initiatives and lead reengineering sessions.
• Perform end-to-end technical analysis and design for complex enterprise systems with UML/DFD/ERD models.
• Translate business rules and workflows into technical requirements, pseudocode and data mappings for developers.
• Design and support system integration points, web services, and APIs for data exchange.
• Develop data migration strategies and ETL specifications for legacy-to-target systems.
• Write and execute complex SQL queries for data validation and SIT.

Skills

Requirements gathering

Stakeholder communication

Technical analysis

System modeling

UML

DFD

ERD

Data migration

ETL

SQL

Education

Master's degree in computer/technology

Tools

IBM FileNet

SQL Server

Oracle

MS Access

Job description

Trigyn's direct government client has an immediate need for Lead Systems Analyst / Systems Architect in Albany, NY.

Description:

• Requirements Gathering & Stakeholder Communication: Collaborate with 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.

Mandatory Qualifications:

• Specializes in analysing, designing and implementing information systems. Assesses the suitability of information systems in terms of their intended outcomes and liaises with end users, software vendors and programmers in order to achieve these outcomes. Uses analysis and design techniques to solve business problems using information technology. Serves as change agent, who identifies the organisational improvements needed, designs systems to implement those changes and trains and motivates others to use the systems.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 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 optimisation of complex enterprise systems. Proven expertise utilising advanced systems modelling methodologies including Unified Modelling Language (UML), Data Flow Diagrams (DFDs), and entity-relationship modelling—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 modelling, including data normalisation (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 analysing 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 artefacts, including Entity-Relationship Diagrams (ERDs), Data Flow Diagrams (DFDs), and detailed data mapping/ETL specifications.
• 48 Months of experience analysing, 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.
• Master's degree in a computer or technology related field.

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 27001:2022 and CMMI Level 5 certified company.