Technical Business Analyst - SQL

Technology · New York, New York
Department Technology
Employment Type Contractor
Minimum Experience Experienced
Compensation DOE

SoHo Dragon represents a Manhattan based investment bank that is hiring a Business Analyst that is skilled with SQL-Data Models-BI. 


Objectives of this role 

  • Requirement gathering through document & application analysis, focus group discussions, etc.
  • Expertise in documentation like Business Requirement Specification (BRS), Functional requirement Specification (FRS), Test cases, and Execution plan.
  • Good understanding and usage of Confluence or similar documentation tools.
  • Basic understanding of UI and UX design with attention to detail on wireframe diagrams.
  • Good understanding of UML diagrams like workflow, use case, sequence, etc. on Draw.io/ Visio/ similar tool.
  • Preparing Project Plan, Stakeholder’s communication management.
  • Agile Scrum experience, with the capability to manage and drive product backlog, sprint backlog, ceremonies, reviews, feedback.
  • Any prior experience in database/ data warehouse migration would be an advantage.
  • Understanding of Finance domain would be an advantage.


Skills and Requirements


  • 5+ years relevant work experience
  • SQL basics: table Keys, Constraints, Joins, Merge, Unions, Concatenations, Stored Procedures, etc.
  • BI basics: Dimensions- Measures, Data sets, Analytics Expressions, etc. Any BI tool(QlikView, PowerBI, Tableau, etc.) know-how would be an advantage.
  • Data Modelling basics: Conceptual and Logical models, Data Integrations concepts, etc.
  • Data Warehouse basics: Models, Schemas, Transformations, Pipelines, Views, etc.

Thank You

Your application was submitted successfully.

  • Location
    New York, New York
  • Department
    Technology
  • Employment Type
    Contractor
  • Minimum Experience
    Experienced
  • Compensation
    DOE