Data engineer (Snowflake + Hadoop) - Associate - Software Engineering

Profile Description

We’re seeking someone to join our team as Business Analyst with experience in Agile framework with requirements writing in the form of Epics and User Stories.  To be successful, the role will require the individual to understand the banking technology landscape, and to offer creative solutions that integrate current capabilities, and the ability to adapt to changing business requirements.    

WM_Technology

Wealth Management Technology is responsible for the design, development, delivery, and support of the technical solutions behind the products and services used by the Morgan Stanley Wealth Management Business. Practice areas include: Analytics, Intelligence, & Data Technology (AIDT), Client Platforms, Core Technology Services (CTS), Financial Advisor Platforms, Global Banking Technology (GBT), Investment Solutions Technology (IST), Institutional Wealth and Corporate Solutions Technology (IWCST), Technology Delivery Management (TDM), User Experience (UX), and the CAO team.

WM Product Technology 

Wealth Management Product Technology (WMPT) is a dynamic and fast-paced area within the Firm’s WM Technology Division. We are responsible for creating innovative technology solutions for the Private Banking Group (PBG), one of the strategic growth areas of the Firm, providing cash management and lending products and services to our WM clients. This includes state-of-the-art technology for a nationwide network of Private Bankers and product specialists who work with Financial Advisors to provide access to products and services such as online banking, cards, deposit products, residential mortgages, securities-based loans, and tailored lending. If you are an exceptional individual who is interested in solving complex problems and building sophisticated solutions in a dynamic team environment, WMPT is the place for you.

Business Analysis

This is Associate Position that analyzes business processes, identifies needs, and establishes requirements to enhance efficiency and productivity through a blend of business acumen and analytical skills.

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.

At Morgan Stanley India, we support the Firm’s global businesses, with critical presence across Institutional Securities, Wealth Management, and Investment management, as well as in the Firm’s infrastructure functions of Technology, Operations, Finance, Risk Management, Legal and Corporate & Enterprise Services. Morgan Stanley has been rooted in India since 1993, with campuses in both Mumbai and Bengaluru. We empower our multi-faceted and talented teams to advance their careers and make a global impact on the business. For those who show passion and grit in their work, there’s ample opportunity to move across the businesses for those who show passion and grit in their work.

Interested in joining a team that’s eager to create, innovate and make an impact on the world? Read on…

What you’ll do in the role:

• Design, build, and optimize data pipelines using Snowflake and Hadoop technologies for efficient data ingestion, transformation, and storage. 

• Lead or contribute to data migration projects from on-prem to Snowflake on the cloud. 

• Manage the data flows and transformation from the source Money Movement to the data lake, and then to the Datawarehouse using Hadoop technologies.

• Strong SQL skills for data querying, manipulation, and analysis within Snowflake and Hadoop. 

• Work across functional lines to strive for and ensure consistent data quality

• Provide increased focus on analytics and emphasize on providing valuable insights to drive improvement opportunities

• Maintain effective relationships with product owners and application development teams in global locations

• Analyze user specifications and aid in testing and debugging applications

• Work within an Agile team, participating in ceremonies related to the Agile framework

What you’ll bring to the role:

• 4-6 years of hand on expertise in building enterprise level Datalake/Data Warehouse and business intelligence platform

• Hands on expertise on Azure cloud and Snowflake

• Hands on expertise in Hadoop (HDFS, Hive) technologies

• Hands on expertise in writing scripts using Python

• Working experience in Teradata

• Exposure to visualization tools such as Power BI, Business Objects / Tableau

• Strong Linux background

• In-depth understanding of the Informatica ETL tool, ETL/ELT process & best practices

• Ability to analyze business requirements, propose solutions, and implement those solutions

• Ability to learn new concepts and technologies, and implement them to solve business problems

• Experience with JIRA or other ALM tools to create a productive, high quality development environment

• Previous experience in working with global teams

• Proven experience in working within an Agile framework

• Good verbal and written communication skills

• Knowledge of Financial markets, payment solutions & Wealth Management

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.

Morgan Stanley is an equal opportunities employer. We work to provide a supportive and inclusive environment where all individuals can maximize their full potential. Our skilled and creative workforce is comprised of individuals drawn from a broad cross section of the global communities in which we operate and who reflect a variety of backgrounds, talents, perspectives, and experiences. Our strong commitment to a culture of inclusion is evident through our constant focus on recruiting, developing, and advancing individuals based on their skills and talents.