Data Engineer​/ETL developer - Director

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 the 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.

Morgan Stanley is an industry leader in financial services, known for mobilizing capital to help governments, corporations, institutions, and individuals around the world achieve their financial goals.

Wealth Management and Investment Management Technology (WMIMT) is responsible for the design, development, delivery, and support of the technical platform behind the products and services used by the Business. Morgan Stanley Wealth Management (WM) is a product of the acquisition of Smith Barney from Citigroup, which was completed in June ’13. Its core client base is individual investors, small‑to‑medium‑size businesses and institutions, and high net worth families and individuals.

AIDT under 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 Enterprise Data Warehouse (EDW) and Datalake (DL), cross‑business‑unit Information Management, Business Intelligence, and more. AIDT team synthesizes and provisions a multitude of business‑critical metrics and underlying detailed information in all Core areas of MSWM.

Examples of essential data domains and metrics include Assets, Revenue, Account Demographics, Financial Advisor (FA) information, Securities, and Cash Transactions, and so on.

As an integral part of AIDT, the Data Integration & Delivery team is tasked with providing insightful and accurate business intelligence on Account Performance metrics, Investment Insights, Trade Surveillance, Anti‑Money Laundering and many other aspects of Wealth Management business.

The role is for a data engineer/ETL developer and 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.

• As an ETL / Hadoop developer, design and develop Informatica ETL and Hadoop applications.
• Individual contributor role.
• Undertake 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 the end solution meets business needs and expectations.
• Develop new transformation processes to load data from source to target, or performance tune existing ETL code (mappings, sessions) and Hadoop platform.
• Analyze existing designs and interfaces and apply design modifications or enhancements.
• Coding and documenting data processing scripts and stored procedures.
• Own the release of code into production using firm CICD tools and process.
• Provide business insights and analysis findings for ad‑hoc data requests.
• Unit test software components and complete solutions (including debugging and troubleshooting) and prepare migration documentation.
• Provide reporting‑line transparency through periodic updates on project or task status.

• 6+ years of experience with the technical analysis and design, development, and implementation of data warehousing / data lake solutions.
• 6+ years of strong SQL programming and stored procedure development skills.
• 6+ years of experience developing in Informatica data management in the cloud or Informatica Power Center and Data Stage.
• 4+ years in Python, Control M orchestration, and Bit Bucket, Jenkins, and CICD.
• 4+ years in Hive/Impala/Spark, Unix, and Python.
• Python scripting.
• 4+ years of relational database…