SYSTEM DESIGN ANALYST (INTENSE TECHNICAL BA)

I have only 2 slots

Share your Profile in BELOW FORMAT:

WORD FILE OF RESUME with Full Name and Title :

Full Name:

Email:

Phone:

Current Location:

Immigration:

Rate: OPEN AND BEST C2C all Inclusive (

LinkedIn:

Title: SYSTEM DESIGN ANALYST (INTENSE TECHNICAL BA):
Client- New York City Human Resources Administration
Location: 400 8th Street Manhattan NY (Hybrid)
Visa: USC GC GC-EAD & H4-EAD (Locals)
Duration : Long term
Rate : $60/hr. on w2 or 70/hr. on C2C (Negotiable)
MOI : INTERVIEW PROCESS WITH CLIENT- 2 rounds total : First Round will be TEAMS CALL and Second Round will be Face to face

CONSIDERED (Please check Commutable distance before applying for the position)

Technical Business Analyst (Explicitly technical - SDD ownership SQL API specs with 13 Years of minimum

Top Priority:

• 13 Years of Technical Business Analyst Experience
• System Design Documentation (SDDs) writing SDDs consumed directly by developers
• Advanced SQL complex queries data validation reconciliation
• API Specifications & System Integrations (JSON/XML)
• Business Requirements Gathering & Documentation (BRDs FRDs SRS)
• System Architecture Documentation (DFDs BPMN ERDs)
• Source-to-Target (S2T) Data Mapping & ETL Validation
• Azure DevOps
• Gap & Impact Analysis
• Agile/Scrum

About the Role : The NYC Human Resources Administration (HRA) is seeking a Technical Business Analyst with strong system design and data analysis capabilities to support the CurRent NYC initiative - a large-scale platform modernizing how HRA manages rental assistance programs including CityFHEPS. This is a technically demanding BA role that sits at the intersection of business requirements and system architecture requiring someone who can not only gather and document requirements but also produce System Design Documentation that development teams consume directly to build and enhance the CurRent City Portal and Landlord Portal.

This is not a traditional BA role. The ideal candidate writes SQL understands data flows and system architecture produces SDDs and can bridge the gap between business stakeholders and technical development teams with precision.

What Youll Do

Requirements & Documentation

• Gather analyze and document comprehensive business and technical requirements through stakeholder interviews JAD sessions and cross-functional workshops with HRA business owners developers and QA teams
• Produce BRDs FRDs SRS documents and Requirements Traceability Matrices (RTMs) ensuring all requirements are clearly defined traceable and testable
• Translate complex business needs into detailed functional and technical specifications maintained in Azure DevOps throughout all Agile sprint cycles

System Design Documentation

• Own the creation of System Design Documents (SDDs) that developers use directly to build and enhance CurRent portal functionalities - including data flows integration touchpoints API specifications business logic and functional architecture
• Document current-state and future-state system architecture interface dependencies data exchange specifications and transformation rules across all CurRent integrated systems
• Produce data flow diagrams (DFDs) process flow diagrams BPMN workflows sequence diagrams and entity relationship diagrams (ERDs) aligned to technical implementation requirements
• Define API payload specifications JSON/XML schemas endpoint behaviors and integration contracts for development and QA teams

Data Analysis & SQL

• Write complex SQL queries to perform data validation reconciliation root cause analysis and backend data investigation across CurRent databases and integrated systems
• Conduct source-to-target (S2T) data mapping data profiling and data quality validation to support system migrations enhancements and integration testing
• Perform data analysis to identify gaps anomalies and discrepancies between systems - translating findings into actionable requirement updates and design decisions
• Support ETL validation and pipeline testing using SQL to verify data accuracy across all processing stages

Gap Analysis & Impact Assessment

• Conduct comprehensive gap analysis between current-state legacy workflows and future-state platform capabilities - documenting findings root causes and recommended design solutions
• Perform system-level impact assessments documenting schema updates interface changes and data dependencies across all CurRent-integrated systems
• Assess feasibility of proposed enhancements and produce structured feasibility documentation for stakeholder and architecture review

UAT & Quality

• Design plan and coordinate end-to-end User Acceptance Testing - producing test scenarios acceptance criteria and traceability matrices aligned to documented requirements
• Use SQL to validate UAT outcomes against expected database results - verifying data accuracy system output integrity and cross-system reconciliation
• Coordinate defect triage root cause analysis and regression validation with development and QA teams through to production sign-off

Stakeholder Collaboration & Reporting

• Liaise between HRA business stakeholders development teams and QA throughout the delivery lifecycle
• Deliver management-level reporting and information dissemination artifacts providing program leadership with visibility into enhancement progress risk items and milestone status
• Facilitate sprint ceremonies including backlog refinement sprint planning and sprint reviews in Azure DevOps

Required Skills

Technical BA & System Design - 5 Years Each:

• Writing System Design Documentation (SDDs) consumed directly by development teams
• Producing BRDs FRDs SRS documents DFDs process flows and BPMN diagrams
• Requirements gathering stakeholder workshops and JAD session facilitation
• Gap analysis feasibility analysis and system-level impact assessments
• User Acceptance Testing coordination including SQL-based data validation

SQL & Data - 5 Years:

• Writing complex SQL queries - joins subqueries aggregations window functions stored procedures
• Source-to-target data mapping data profiling and data quality validation
• Backend data analysis reconciliation and defect investigation using SQL
• ETL validation and pipeline testing

Tools & Methodology - 5 Years:

• Azure DevOps for requirements documentation user stories and sprint management
• Agile/Scrum and iterative delivery methodologies
• MS Visio Lucidchart or equivalent for system and process diagramming
• API documentation tools - Postman Swagger or equivalent

Preferred Qualifications

• Direct experience with NYC or NYS government agency systems - HRA DSS OTDA or equivalent
• Exposure to rental assistance housing benefits eligibility determination or landlord payment systems
• Experience with citizen-facing or landlord-facing self-service portal development
• CBAP CSM or equivalent BA/Agile certification
• Experience with electronic payment workflows - ACH disbursement processing payment enrollment

Why This Role Stands Out

• High-visibility initiative directly impacting thousands of NYC landlords and CityFHEPS recipients
• Technical depth required - this role writes SQL owns SDDs and drives system architecture decisions alongside developers
• Long-term engagement with significant enhancement roadmap ahead
• Hybrid schedule with collaborative mission-driven HRA team