Technical Systems Analyst with .NET Exp

Summary

Job Title: Technical Systems Analyst with .NET Exp

Location: Albany, NY

Duration: 6 Months + Extension

Bill Rate: $80/hour

Job Type: C2C/1099 Contract

Client: To Be Discussed Later

Work Authorization:

• USC
• GC
• H-1B
• OPT-EAD
• GC-EAD

Job Description:
Candidate will work on existing and new initiatives including Assessment Management System, Telecommunication Company Information, Pipeline Audit System (PAS), Document and Matter Management (DMM), and 753 Enforcement support, enhancements, and development efforts.

Responsibilities:

• Gather, analyze, and document business requirements by collaborating with DPS program staff, business stakeholders, and external entities.
• Lead business process reengineering sessions and present As-Is and To-Be system states.
• Perform end-to-end technical analysis and design for complex enterprise systems.
• Develop technical specifications, system architecture maps, UML diagrams, DFDs, and ERDs.
• Reverse-engineer legacy MS Access databases, including tables, relationships, queries, forms, macros, and VBA modules.
• Identify data integrity issues and design normalized relational database schemas up to 3NF for SQL Server and Oracle.
• Act as a technical liaison between business stakeholders, software vendors, application developers, and DBAs.
• Translate business rules, compliance logic, and workflows into technical requirements, pseudocode, database constraints, and system logic.
• Analyze and design system integrations, web services, and APIs.
• Support integrations with enterprise Document Management Systems such as IBM FileNet and external agency databases.
• Develop data migration strategies, data mapping matrices, and ETL specifications.
• Write and execute complex SQL queries, including multi-table joins, subqueries, and analytical functions.
• Perform data validation, migration validation, SIT, and backend troubleshooting.
  Equal Opportunity Employer: We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.