Business Analyst with TSQL
- 1pointsystem
17 Days Ago
NA
NA
New York-NY
8-20 Years
Required Skills: BA, TSQL, Jira, PowerBI
Job Description
Role: Business Analyst with expert experience with T-SQL
Work location: 333 Avenue, New York NY 10001
Duration: 1.5 years
Required to work 3 days on site (Policy is subject to change in future)
This is 35-hour work week not 40 hours.
Required to work 3 days on site (Policy is subject to change in future)
This is 35-hour work week not 40 hours.
Require on site interview
8 years of experience as a Business Analyst with 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 )
Project: Special Education Student Reporting and Analysis
Required Skills/Experience:
8 years of experience as a Business Analyst with 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 )
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.
