Required on site interview in New York City (there is no web interviews before hand). Will be given a 1 hour test on T-SQL and other BA skills 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 to 85.00 Must Have All The Required Skills • Requite to have 8 years as a BA with being an expert with T-SQL. • Hands-on experience in joints, aggregate functions, ranks, able to understand/explore the data with 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.