Analytics Team Lead - Vice President

Morgan Stanley • Edison, NJ

3d

About The Position

Morgan Stanley’s Technology and Risk Controls Engineering team within the Technology Organization is seeking an Analytics Team Lead at the Vice President level. The role provides hands-on data analytics expertise and technical leadership in support of continuous control monitoring. It identifies and evaluates data sources, analyzes data, and assesses its suitability for control metrics. The role partners with teams throughout metric development to define requirements, confirm data suitability, onboard feeds, complete user acceptance testing (UAT), and maintain supporting documentation.

This is a technical leadership position with no direct reports or formal people-management responsibilities. The team lead owns assigned data analytics and metric-development workstreams, coordinates junior analysts’ work through clear expectations, deadlines, and technical guidance, and ensures deliverables meet acceptance criteria and are completed on time. The role also ensures errors are corrected and retested, mentors junior analysts and developers, and reports on workstream progress.

Requirements

• At least 5 years of experience writing Python scripts for data analysis, including extensive knowledge of pandas, regular expressions (re), lambda functions, and NumPy.
• Advanced SQL skills, including developing and reviewing complex queries and validating metric calculation logic.
• Experience developing code using AI-assisted tools such as Claude, OpenAI tools, and GitHub Copilot.
• Experience applying AI agents to automate work processes.
• At least 5 years of demonstrated data analysis experience.
• At least 5 years of experience working with database and reporting teams.
• Experience providing technical leadership for data analytics workstreams and coordinating junior analysts’ work, with accountability for priorities, capacity planning, deadlines, quality, and accurate, timely delivery.
• Ability to exercise independent analytical judgment, resolve ambiguous requirements, challenge assumptions, and recommend appropriate approaches with limited direction.
• Experience translating approved metric requirements into calculation logic, validating results, and supporting engineering handover and UAT.
• Experience reviewing analyses, SQL queries, scripts, and supporting documentation, with strong attention to detail and a structured approach to identifying and resolving errors.
• Ability to mentor junior analysts and developers, explain technical concepts clearly, and provide constructive technical guidance.
• Strong understanding of technology controls and technology risks.
• Intermediate Excel skills, including string manipulation functions, VLOOKUP, and PivotTables.
• Strong communication and organizational skills.
• Project management experience.

Nice To Haves

• Knowledge of DevOps tools and concepts.
• Experience with GitHub and code deployment.
• Adaptability to new technologies and changing requirements.
• Ability to manage competing priorities in a dynamic, fast-paced environment.
• Experience with Snowflake.

Responsibilities

• Collaborate with data subject matter experts, control owners, and team members to understand and document data requirements.
• Independently investigate ambiguous data and metric requirements, challenge assumptions, and recommend appropriate analytical approaches with limited direction.
• Identify and evaluate potential data sources; assess and document data in terms of volume, velocity, variety, veracity, and value.
• Write scripts to extract, transform, and analyze data from various sources, and assess whether data is suitable to support control metrics.
• Translate approved Control Measurement Record requirements into documented, tested, and validated metric calculation logic; coordinate handover to platform engineering and verify implementation through UAT.
• Document requirements for new data sources and enhancements to existing sources.
• Partner with the database team to onboard data feeds in accordance with Technology standards and procedures, including planning, executing, and documenting UAT.
• Guide the visualization team on using data for metric development.
• Follow Software Development Life Cycle policies and maintain documentation demonstrating adherence to required processes for Second Line and Internal Audit review.
• Plan and deliver assigned analytics and metric-development workstreams, including prioritization, capacity planning, quality assurance, dependency management, and milestone tracking.
• Track workstream progress using project management tools such as JIRA, report delivery status, and promptly escalate risks and issues.
• Provide day-to-day technical leadership for junior analysts by coordinating assignments, clarifying requirements and acceptance criteria, setting deadlines, and monitoring work through completion.
• Review junior analysts’ analyses, SQL queries, scripts, testing evidence, and documentation for accuracy, completeness, and adherence to requirements and standards.
• Perform quality assurance checks, including data reconciliation, validation, and peer review; ensure identified errors are corrected and retested before delivery.
• Mentor junior analysts and developers through coaching, code reviews, knowledge sharing, and guidance on analytical methods, coding standards, testing, and documentation.

Benefits

• Comprehensive employee benefits and perks.
• Support for employees and their families throughout their work-life journey.
• Opportunities to move about the business for employees who demonstrate passion and grit.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed