BI & Data Analytics Engineer

Overview

In the Technology division, we leverage innovation to build the connections and capabilities that power our Firm, enabling our clients and colleagues to redefine markets and shape the future of our communities. This is a Data & Analytics Engineering position at Director level, part of the job family responsible for providing specialist data analysis and expertise that drive decision-making and business insights, as well as crafting data pipelines, implementing data models, and optimizing data processes for improved data accuracy and accessibility, including applying machine learning and AI-based techniques. Since 1935, Morgan Stanley is known as a global leader in financial services, always evolving and innovating to better serve our clients and our communities in more than 40 countries around the world.

This is a Lead Business Intelligence & Data Analytics Engineering position at Director level, which is part of the job family responsible for developing and maintaining innovative software solutions. The candidate will partner with Business and Technology teams to provide timely actionable analysis / insights to measure, grow, and supervise business areas, products, and services in Morgan Stanley Wealth Management.

AIDT under Wealth Management Technology provides consistent, trusted, and integrated business information across all platforms and delivery channels within Morgan Stanley Wealth Management (MSWM) businesses. AIDT areas of expertise include but not limited to Enterprise Data Warehouse (EDW) and Datalake (DL), cross-business-unit Information Management, Business Intelligence, AI / ML and more. AIDT team synthesizes and provisions a multitude of business-critical metrics and underlying detailed information in all Core areas of MSWM. The Data Visualization team provides insightful and actionable business intelligence solutions for various business units under wealth management. Examples of essential data domains and metrics include Assets, Revenue, Account Demographics, Financial Advisor (FA) information, Securities and Cash Transactions, Risk, Stock Plan, Retirement, Financial Wellness, and other key areas. The candidate will work on one or many visualization projects, and the role requires active participation with leadership teams, business units and technology groups across the project lifecycle. Specific assignments will depend on the size and complexity of the project.

What You'll Do In The Role

• Develop and build enterprise level Full Stack applications using BI and ETL technologies.
• Design and develop scalable data models to create intuitive reports and dashboards.
• Design and development of ETL / Hadoop, including stored procedures, queries, performance tuning, archiving, etc., using Python, SQL and ETL tools.
• Development of new transformation processes to load data from source to target, or performance tuning of existing ETL code (mappings, sessions) and Hadoop Platform.
• Build data pipelines and efficient automation scripts (using Python).
• Undertaking end-to-end project delivery (from inception to post-implementation support), including review and finalization of business requirements, creation of functional specifications and / or system designs, and ensuring that end-solution meets business needs and expectations.
• Analyze existing designs and interfaces and apply design modifications or enhancements.
• Provide insights and analysis findings for ad-hoc issues.

What You'll Bring To The Role

Good To Have Skills

What You Can Expect From Morgan Stanley

We are committed to maintaining the first-class service and high standard of excellence that have defined Morgan Stanley for many years. Our values—putting clients first, doing the right thing, leading with exceptional ideas, committing to diversity and inclusion, and giving back—guide the decisions we make every day. We offer attractive and comprehensive employee benefits and perks, and opportunities for growth across our global offices.

Equal Employment Opportunity

It is the policy of the Firm to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, creed, age, sex, sex stereotype, gender, gender identity or expression, transgender, sexual orientation, national origin, citizenship, disability, marital and civil partnership / union status, pregnancy, veteran or military service status, genetic information, or any other characteristic protected by law. Morgan Stanley is an equal opportunity employer committed to diversifying its workforce (M / F / Disability / Vet).

J-18808-Ljbffr