Business Analyst with Expert T-SQL (Contract – Hybrid – New York, NY)

Business Analyst with Expert T-SQL (Contract – Hybrid – New York, NY)

Our client, a prominent firm in the Computer and Mathematical industry, is seeking a highly skilled Business Analyst with expert experience in T-SQL. This contract position, based in New York, NY (333 Avenue, New York NY 10001), requires 3 days onsite per week (policy subject to change). Please note: this role requires a 100% onsite interview in New York City (no web interviews beforehand), and candidates will be given a 1-hour test on T-SQL and other BA skills. The work week is 35 hours.

This role is ideal for a seasoned professional who can seamlessly bridge the gap between business needs and technical solutions, leveraging deep T-SQL expertise to analyze, document, and optimize complex processes.

What’s the Job? Bridging Business Needs with Technical Solutions Through T-SQL Expertise

As a Business Analyst with expert T-SQL skills, you will play a dual and critical role, combining in-depth data analysis with traditional business analysis functions. Your responsibilities will revolve around understanding complex processes, defining requirements, and ensuring that technical solutions precisely meet business objectives.

• Serve as a Business Analyst and Programmer Analyst: You will perform the crucial duties of a Business Analyst, meticulously conducting business, code, and/or systems analysis. This includes elicitation and validation of requirements, and producing comprehensive requirements documentation. Simultaneously, you will also perform the role of a Programmer Analyst, leveraging your strong understanding of T-SQL to deeply analyze existing code and systems, document “as-is” processes, and provide precise requirements for “to-be” processes. This dual capacity is essential for understanding both the functional and technical intricacies of the systems.
• Conduct Business, Code, and/or Systems Analysis: You will be responsible for conducting thorough business, code, and/or systems analysis. This involves dissecting complex operational workflows, examining existing codebases (particularly T-SQL), and analyzing current system functionalities. Your goal is to fully understand the “as-is” environment, identify pain points, and uncover opportunities for improvement and optimization.
• Elicitation and Validation of Requirements: A core responsibility is the elicitation and validation of requirements. You must be able to actively participate in elicitation sessions, employing various techniques (e.g., interviews, workshops, surveys) to gather comprehensive requirements from stakeholders. You will then rigorously validate these requirements, ensuring they are clear, concise, unambiguous, testable, and aligned with business goals.
• Produce Comprehensive Requirements Documentation: You will be responsible for producing high-quality, comprehensive requirements documentation. This includes creating analysis artifacts such as business process diagrams, use cases, detailed requirements specifications, UML diagrams, and system context diagrams. Your ability to translate elicitation outputs into structured documentation is critical for guiding development and testing.
• Create and Validate Test Scripts: You will actively contribute to the quality assurance process by creating and validating test scripts. This involves designing test cases that directly correspond to documented requirements, ensuring that new functionalities or changes perform as expected and meet business needs. Your involvement in testing helps guarantee the quality of delivered solutions.
• Communicate Effectively with Users and IT Staff: You will be responsible for communicating effectively with users and IT staff to identify their needs and collaboratively evaluate alternative business solutions. This requires excellent verbal and written communication skills to bridge the gap between technical and non-technical stakeholders, ensuring all parties are aligned on project goals and solutions.
• Analyze Environment and Internal Processes (As-Is and To-Be): You will meticulously analyze the current environment and internal processes, rigorously documenting the “as-is” state. Following this, you will design and document the “to-be” processes, outlining proposed improvements, system changes, and new workflows that enhance efficiency, streamline operations, or meet new business requirements. This transformational analysis is a key deliverable.
• Refine Business Cases and Create Project Documentation: You will contribute to project initiation by helping to refine business cases, ensuring they clearly articulate the value, benefits, and feasibility of proposed solutions. You will also be responsible for creating necessary project documentation that supports the project lifecycle, from scope definition to final delivery.
• Leverage T-SQL Expertise for Data Exploration and Analysis: You will utilize your expert knowledge in T-SQL for hands-on data exploration and analysis. This includes writing complex queries using joins, aggregate functions, and ranking functions to understand underlying data structures, identify patterns, and uncover insights crucial for defining accurate requirements and troubleshooting issues. Your ability to directly interact with and explore data is a distinguishing feature of this role.
• Conduct Routine Network Maintenance and Optimization: You will have experience with conducting routine network maintenance and optimization. This could involve performing firmware upgrades, configuration backups, log analysis, capacity planning, and implementing adjustments to improve network performance and reliability on an ongoing basis.
• Troubleshoot Complex Network Issues: You will have proven experience troubleshooting complex network issues. This extends beyond basic connectivity problems to intricate routing loops, performance bottlenecks, intermittent outages, and multi-protocol interoperability challenges, requiring a methodical and analytical approach.
• Develop and Maintain Comprehensive Documentation: You will have experience with developing and maintaining comprehensive documentation for network configurations, diagrams, procedures, and troubleshooting guides. This ensures knowledge transfer, operational consistency, and efficient support for the network infrastructure.

What’s Needed? Your Core Skills for Data-Driven Business Analysis

To excel in this unique Business Analyst role, you’ll need an extensive background in business analysis, expert-level T-SQL proficiency, and strong analytical and interpersonal skills.

• Extensive BA Experience with T-SQL Expertise: You must possess a minimum of 8 years of verifiable experience as a Business Analyst (BA), coupled with being an expert with T-SQL. This indicates a seasoned professional capable of bridging business needs with deep technical understanding, particularly concerning data.
• Hands-on T-SQL for Data Exploration: You must have extensive hands-on experience in using T-SQL for data exploration. This includes advanced proficiency in joins (INNER, LEFT, RIGHT, FULL), aggregate functions (SUM, AVG, COUNT, MAX, MIN), ranking functions (ROW_NUMBER, RANK, DENSE_RANK), and the ability to effectively understand and explore data directly through T-SQL queries.
• Experience in Business, Code, and/or Systems Analysis: You are required to have experience in conducting business, code, and/or systems analysis. This demonstrates your ability to dissect various aspects of an organization’s operations, software, or IT infrastructure to identify challenges and define solutions.
• Expertise in T-SQL for Code Analysis: You must possess expertise in T-SQL, specifically with a strong ability to understand and analyze existing T-SQL code. This means you can read, interpret, and troubleshoot complex SQL scripts, stored procedures, and functions written by developers, aiding in process documentation and improvement.
• Programmer Analyst Capabilities with T-SQL: You are expected to perform the role of a Programmer Analyst with a strong understanding of T-SQL. This goes beyond just querying; it implies an ability to understand programmatic logic within SQL, potentially identifying areas for optimization or re-coding to enhance performance or correct functionality.
• Client-Focused Requirements Analysis: You must have proven experience with client-focused requirements analysis, demonstrating your ability to engage directly with stakeholders, elicit their needs, and translate them into clear, actionable requirements. This is coupled with excellent Critical Thinking and Problem Solving Skills to navigate complex business challenges effectively.
• Comprehensive BA Duties and SDLC Experience: You have broad experience in performing the duties of a business analyst, including elicitation and validation of requirements, producing diverse requirements documentation, and creating/validating test scripts. You also demonstrate familiarity with SDLC methodologies, both Waterfall and Agile, indicating adaptability to different project environments.
• Experience Working with Diverse Stakeholders: You must have proven experience actively working with a wide range of stakeholders, including but not limited to: Customers, Project Managers, Technical Teams (developers, DBAs, QA), and other Business Analysts. Your ability to manage expectations and foster collaboration across these groups is crucial.
• Business Process Reengineering and Optimization Experience: You have practical experience with business process reengineering and optimization. This includes analyzing and formulating As-Is and To-Be processes and requirements, demonstrating your ability to identify inefficiencies and design improved workflows that streamline operations.
• Elicitation and Analysis Artifact Creation: You must be able to effectively take part in elicitation sessions and capture requirements and action items. Crucially, you must then be able to convert these elicitation outputs into analysis artifacts such as business process diagrams, use cases, detailed requirements, UML diagrams, and system context diagrams.
• Data Requirements and Tracking: You must be able to work with data teams to write precise data requirements, ensuring that data models and storage solutions align with business needs. Furthermore, you must be able to track all requirements’ activities meticulously to ensure nothing is missed throughout the project lifecycle.

Technologies: Your Toolset

• SQL Server: Experience with Microsoft SQL Server database platform.
• Expertise in T-SQL: Demonstrated expert-level proficiency in T-SQL for querying, analysis, and understanding code.
• Application Lifecycle Management systems: Familiarity with ALM tools.
• JIRA: Experience with Jira for project management and issue tracking.
• Power BI: Familiarity with Power BI for data visualization and reporting.

If this Business Analyst with Expert T-SQL role in New York, NY, aligns with your extensive BA experience, your deep T-SQL expertise, and your passion for driving complex financial transformations, we encourage you to learn more about this exciting hybrid contract opportunity. This is a fantastic chance to make a significant impact on enterprise data and processes.

Are you ready to blend your business acumen with expert T-SQL skills in a dynamic banking environment?