Systems Analyst (Legacy Modernization & Data Modeling)

ACS -

Albany, NY, United States

2 days ago

Apply on www.careerjet.com

Prepare application

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Compensation

$56,183.0 - $88,970.0

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

Microsoft Access ASP.NET .NET Framework Third Normal Form Application Programming Interfaces (APIs) Business Process Management C Sharp (Programming Language) Databases Data Validation Extract Transform Load (ETL) Data Mapping Data Normalization

+24 more

Data Profiling Relational Databases Document Management Systems Electronic Data Interchange (EDI) Entity Relationship Models IBM Software Microsoft SQL Server Model View Controller (MVC) Oracle (Applications) Reverse Engineering SQL Databases Systems Integration UML Web Applications Web Services Freeform SQL Enterprise Software Applications .NET Core Macros Analytic Functions Backend Data Strategy Information Technology Vba Programming Language

Job description

Title: EHS Data Strategy & Reporting Analyst Location: Albany, NY 12207 (Hybrid) Duration: 12 Months Kindly share your most updated resume. Roles & Responsibilities: This…

19 hours ago
Apply easily, Job details: Job Title:EHS Data Strategy & Reporting Analyst Location:Albany, NY, 12207 Duration:12+ Months (Possibility of extension) Payrate:$45-$50/hr with all inclusive Hy…
4 days ago +

Requirements

Experience in internal and external stakeholder communications and outreach, including developing presentations and other materials that support the rethinking of core business processes and the design of reengineered environments.
Experience as a Lead Systems Analyst or Systems Architect directing end-to-end technical analysis, design, and optimization of complex enterprise systems. Experience using advanced systems modeling methodologies, including Unified Modeling Language (UML), Data Flow Diagrams (DFDs), and entity-relationship modeling, to conduct As-Is/To-Be system evaluations, perform technical gap analyses, and design scalable, high-performance system workflows and technical specifications.
Experience working on business requirements projects as a Lead Analyst, including gathering and documenting business process requirements for new applications, developing logical and physical data models, and applying data normalization up to Third Normal Form (3NF) to transform flat-file or legacy structures into enterprise relational database schemas such as SQL Server and Oracle.
Experience reverse-engineering legacy databases, specifically Microsoft Access, including analyzing tables, relationships, queries, forms, macros, and VBA modules to identify structural anomalies and developing complex SQL queries using multi-table joins, subqueries, and analytical functions for data validation, data profiling, and backend troubleshooting.
Experience serving as a technical liaison between business stakeholders, software vendors, and application developers to translate business requirements into technical system design artifacts, including Entity-Relationship Diagrams (ERDs), Data Flow Diagrams (DFDs), and detailed data mapping and ETL specifications.
Experience analyzing, designing, or supporting systems integrated with enterprise Document Management Systems such as IBM FileNet or enterprise relational databases such as Oracle.
Experience developing and implementing multi-tier .NET Framework and .NET Core web applications using C# and ASP.NET patterns, including Web Forms and Model-View-Controller (MVC), as well as designing and implementing system integration points, web services, and APIs for data exchange.
Master’s degree in Computer Science, Information Technology, or a related technology field.