Business Analyst with Expert Experience with T-SQL (100% Onsite Interview)

Require on site interview- (no web interviews before hand). Must be locale to New York City. 8 years of experience as a Business Analyst with 4 years of strong T-SQL with hands-on experience in joints, aggregate functions, ranks, able to understand/explore the data with T-SQL. Will go onsite to take (T-SQL coding test ) Required to work 3 days on site (Policy is subject to change in future) Work location: 333 Avenue, New York NY 10001 This is 35 hour work week not 40 hours. Hourly rate 65.00 to 75.00 with Experis Benefits. Corp. to Corp rate 80.00 Project: Special Education Student Reporting and Analysis Required Skills/Experience • Requite to have 8 years as a BA with 4 years of experience T-SQL. • Required to have done conducting business, code and/or systems analysis • Expertise in T-SQL, with an ability to understand and analyze T-SQL code • Perform the role of a Programmer Analyst with a strong understanding of T-SQL, • Experience with client focused requirements analysis with excellent Critical Thinking and Problem Solving Skills. • Experience in performing the duties of a business analyst, including but not limited to: conducting business, code and/or systems analysis, elicitation, and validation of requirements, and producing requirements documentation, and creating/validating test scripts. • Experience actively working with a wide range of stakeholders, including but not limited to: Customers, Project Managers, Technical Teams, and other Business Analysts . • Experience with business process reengineering and optimization, including analyzing and formulating As-Is and To-Be processes and requirements . • Must be able to take part in elicitation sessions and capture requirements and action items. • Must be able to convert elicitation outputs into analysis artifacts - business process diagrams, use cases, requirements, UML diagrams, system context diagrams, etc. • Must be able to work with data team to write data requirements. • Must be able to track all requirements' activities to make sure nothing falls through the cracks. • Familiarity with SDLC methodologies both Waterfall and Agile. • Technologies: SQL Server, Expertise in T-SQL, with an ability to understand and analyze T-SQL code, Application Lifecycle Management systems, JIRA, Power BI. Responsibilities • Responsible for communicating effectively with users and IT staff to identify needs and evaluate alternative business solutions with project management. • Analyze environment and internal processes, document, and design “as is” and “to be” processes. • Refine business cases. • Create necessary project documentation. • Need Senior BA to also perform the role of a Programmer Analyst with a strong understanding of T-SQL to be able to understand/document the as-is process and provide requirements for to-be process.