Job Title: Data Engineer, Director, P3

Location: NYC, New York (Hybrid)

Department: Wealth Management and Investment Management Technology (WMIMT)

Technology is the key differentiator that ensures that we manage our global businesses and serve clients on a market leading platform that is resilient, safe, efficient, smart, fast and flexible. Technology redefines how we do business in global, complex and dynamic financial markets. We have a large number of award-winning technology platforms that help to propel our Firm's businesses to be the top in the market. Our India technology teams are based in Mumbai and Bengaluru. We have built strong techno-functional teams which partner with our offices globally taking global ownership of systems and products. We have a vibrant and diverse mix of technologists working on different technologies and functional domains. There is a large focus on innovation, inclusion, giving back to the community and sharing knowledge.


Department profile:
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.

Position Overview:

We are seek for an ETL / Hadoop developer to design and develop ETL and Hadoop applications.

As an integral part of AIDT, Banking Data Warehouse is tasked with supporting MS Banks for day-to-day operations, FED reporting and multiple downstream applications. The candidate will be assigned to Lending functionality squad of MS Banks that supports Tailored Lending (TL), Liquidity Access Line (LAL), Private Share Lending (PSL), Line of Credit (LoC), Express Credit Line (ECL) and Margin loans. The role requires credibility, confidence and active participation with leadership teams, business units and technology groups across the project lifecycle.

What you’ll do in the role:

- Design and development of ETL and Hadoop applications.

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

- Development of new transformation processes to load data from source to target, or performance tuning of existing ETL code (mappings, sessions) and Hadoop Platform.

- Analysis of existing designs and interfaces and applying design modifications or enhancements

- Coding and documenting data processing scripts and stored procedures.

- Providing business insights and analysis findings for ad-hoc data requests

- Testing software components and complete solutions (including debugging and troubleshooting) and preparing migration documentation.

- Providing reporting-line transparency through periodic updates on project or task status.


What you’ll bring to the role:

- 5+ years of experience with the technical analysis and design, development and implementation of data warehousing / Data Lake solutions.
- Strong SQL programming and stored procedure development skills.
- 5+ years of experience developing in Informatica or any other ETL tool.
- Understanding/experience in Hive/Impala/Spark will be a plus
- 5+ years relational database experience (experience with Teradata and Snowflake is a big plus).
- Strong UNIX Shell scripting experience to support data warehousing solutions.
- Process oriented, focused on standardization, streamlining, and implementation of best practices delivery approach.
- Experience in optimizing large data loads.


Education: Bachelor's/Master's Degree in Engineering, preferably Computer Science/Engineering

Secondary Skills / Desired skills

Good Team playerExposure to an Agile Development environment would be a plus. Stron-g understanding of Data warehousing domain.Ability to architect an ETL solution and data conversion strategy.Good understanding of dimensional modelling.

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 over 89 years. Our values - putting clients first, doing the right thing, leading with exceptional ideas, committing to diversity and inclusion, and giving back - aren’t just beliefs, they guide the decisions we make every day to do what's best for our clients, communities and more than 80,000 employees in 1,200 offices across 42 countries. At Morgan Stanley, you’ll find an opportunity to work alongside the best and the brightest, in an environment where you are supported and empowered. Our teams are relentless collaborators and creative thinkers, fueled by their diverse backgrounds and experiences. We are proud to support our employees and their families at every point along their work-life journey, offering some of the most attractive and comprehensive employee benefits and perks in the industry. There’s also ample opportunity to move about the business for those who show passion and grit in their work.

To learn more about our offices across the globe, please copy and paste https://www.morganstanley.com/about-us/global-offices​ into your browser.

Expected base pay rates for the role will be between $120,000 to $165,000 per year at the commencement of employment. However, base pay if hired will be determined on an individualized basis and is only part of the total compensation package, which, depending on the position, may also include commission earnings, incentive compensation, discretionary bonuses, other short and long-term incentive packages, and other Morgan Stanley sponsored benefit programs. 

Morgan Stanley's goal is to build and maintain a workforce that is diverse in experience and background but uniform in reflecting our standards of integrity and excellence. Consequently, our recruiting efforts reflect our desire to attract and retain the best and brightest from all talent pools. We want to be the first choice for prospective employees.

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