Lead Systems Analyst – Data Modeling & Enterprise Systems

Maagsoft Inc.; City of Albany (NY); In loco; USD 140.000 - 180.000; Tempo pieno

Descrizione del lavoro

Maagsoft Inc. seeks a Lead Systems Analyst Data Modeling & Enterprise Systems in Albany, NY. The role demands 14+ years of experience, leading analysis, design and optimization of complex enterprise systems, with strong UML, DFD, and ER modeling expertise.

You will bridge business and technical teams, drive data architecture, and oversee data mapping, ETL specs, and integration with enterprise databases and Document Management Systems.

Competenze

• 14+ years of experience in systems analysis and design.
• Lead roles directing end-to-end analysis of enterprise systems.
• Proven expertise with UML, DFDs, ER modeling and data architecture.

Mansioni

• Lead end-to-end technical analysis, design and optimization of enterprise systems.
• Translate business requirements into technical system design artifacts (ERDs, DFDs, data mappings).
• Collaborate with stakeholders, vendors and developers to ensure scalable, high-performance workflows.
• Reverse-engineer legacy databases and support data validation and ETL processes.

Conoscenze

Stakeholder communications

Enterprise systems analysis

UML modeling

Data modeling

Data flow diagrams

ER modeling

Data normalization (3NF)

SQL queries

Legacy database reverse engineering

ETL specifications

Technical liaison

Formazione

Masters degree in computer or technology field

Strumenti

MS Access

SQL Server

Oracle

IBM FileNet

Descrizione del lavoro

Position Job Title: Lead Systems Analyst Data Modeling & Enterprise Systems

Job ID (Task ID): 15024

Location: Albany, NY

Experience : 14 + Years

Client :State of NY

Requested Qualifications

• 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.
• Masters Degree in a computer or technology related field

Required Documentation

• Resume
• Copy of Candidate Identification (i.e., Driver s License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)