Senior Business Analyst

For more details, please connect with Kajal Verma at or call at View phone number on click.appcast.io.

Direct Client: New York City Department of Social Services


Job Title: Senior Business Analyst


Location: Brooklyn, NY 11238


Duration: 36 Months


Position Type: Contract


Hours Per Week: 35 Hr


Interview Mode: Webcam


Ceipal ID: NYC_BA267_KV


Requirement ID: DSS-ITS-C-20260729-2-67

Project Name M&O Services for DSS Application Systems

Project Description


ITS serves all DSS program areas to fulfill their IT needs. To meet the business needs and ITS' workload, ITS is seeking qualified candidates in the areas of Database design, architecture, and development, including base definition, structure, documentation, long-range requirements, operational guidelines, and protection. Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries. Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of various systems that ITS supports across DSS program areas.

Tasks and Duties

• Develop Business and Technical Requirements
• Identify user stories and translate them into technical requirements
• Break down requirements into deliverable components
• Review requirements with stakeholders for approval
• Create system and process design documentation
• Develop and present business process mockups and data feeds
• Produce Source-to-Target mapping and transformation rules documentation
• Design and Development of Software Applications
• Develop conceptual, logical, and physical data models using Erwin; generate DDL scripts
• Perform data profiling and metadata management
• Design, develop, and implement ETL processes using IBM InfoSphere DataStage
• Support CARES DataMart updates and inter-agency data exchanges
• Develop reports using IBM Cognos Report Studio
• Participate in upgrades (Cognos, Attunity), proof of concepts, and solution evaluations
• Evaluate tools, coordinate with vendors, and support installation/configuration
• Implement data replication to the Operational Data Store using Qlik (Attunity)
• Provide Environment Support
• Develop and maintain Oracle PL/SQL objects (packages, procedures, functions, views, tables)
• Create complex queries for data validation and analysis
• Develop programs for data fixes and manual invoice generation
• Maintain data exchange integrations with systems such as HOME Tracker, BCS, CPS, and OPPM
• Coordinate with networking teams and external agencies for data exchange
• Provide 24/7 support for ETL processes and data replication
• Enhance and maintain ETL programs following best practices
• Execute data fixes and manage batch jobs, including user access updates
• Support system migration, maintenance, and production issue resolution
• Management Reporting and Information Dissemination
• Analyze and document current systems and processes
• Recommend improvements based on stakeholder feedback
• Collaborate with business users, developers, and technical teams
• Perform system, integration, and user acceptance testing (UAT)
• Prepare test protocols and reports to meet audit requirements
• Coordinate Application Testing
• Prepare test environments for system integration testing and UAT
• Develop test cases and acceptance criteria
• Coordinate QA testing among QA teams, developers, and stakeholders
• Ensure adherence to IT quality assurance standards

V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector, Enterprise Solutions, Professional Services, Ecommerce, Projects, and Products. Within Public Sector business unit, we cater IT Professional Services to Federal, State and Local. We have multiple awards/ contracts with 30+ states, including but not limited to NY, CA, FL, GA, MD, MI, NC, OH, OR, CO, CT, TN, PA, TX, VA, NM, VT, and WA.


If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.

Please share my contact information with others working in Information Technology.

Website:


LinkedIn:


Facebook:


Twitter: