VP, Lead Data & Compliance Analysis (Hybrid)

Morgan-Stanley; Town of Islip (NY); Hybrid; USD 205,000 - 210,000; Full time

Job summary

Morgan Stanley is seeking a Vice President, Lead Business Analysis in New York, NY to drive data analysis, develop SQL scripts, and ensure regulatory data quality for reporting. You will collaborate with Technology, QA, Product, and Operations to gather requirements and implement solutions.

Responsibilities include BRD creation, functional specs, BRD mappings, and leading end-to-end UAT. The role emphasizes data governance, compliance, and audit readiness in a hybrid work environment.

Qualifications

• Master's degree in Finance, Accounting, Statistics, or related field is required.
• Experience in Business Analysis and requirements gathering.
• Proficiency with SQL for data analysis and reporting.
• Knowledge of RDBMS concepts (snowflake/star schema, Hadoop) and data modelling.
• Experience with BI tools (Tableau, Cognos, Business Objects) and ETL tools (Informatica).
• Familiarity with regulatory reporting and compliance technology.

Responsibilities

• Lead data analysis and develop SQL-based scripts for regulatory datasets.
• Gather, analyze, and document business requirements with Agile methodologies.
• Perform end-to-end data gap analysis and coordinate data transformation efforts.
• Create BRDs, functional specs, and test plans; drive UAT and sign-off.
• Collaborate with Technology, QA, Product, and Operations to implement data enhancements.
• Support audit readiness, data lineage, and regulatory reviews with documentation.

Skills

SQL querying

Data analysis

Business analysis

Agile

RDBMS concepts

BI tools

ETL Informatica

Regulatory reporting

Front office trading

Compliance tech

Education

Master's degree in Finance, Accounting, Statistics, or related field

Tools

Informatica

Oracle

SQL Server

Job description

Morgan Stanley is seeking a Vice President, Lead Business Analysis in New York, NY to drive data analysis, develop SQL scripts, and ensure regulatory data quality for reporting. You will collaborate with Technology, QA, Product, and Operations to gather requirements and implement solutions.

Responsibilities include BRD creation, functional specs, BRD mappings, and leading end-to-end UAT. The role emphasizes data governance, compliance, and audit readiness in a hybrid work environment.