At Morgan Stanley, we advise, originate, trade, manage and distribute capital for governments, institutions and individuals, and always do so with a standard of excellence. We are a leading global financial services firm that conducts its business through three principal business segments-Institutional Securities, Wealth Management (WM), and Investment Management. The Firm's employees serve clients worldwide from more than 1,200 offices in 43 countries.


Our WM business is one of the largest in the world with more than $2 trillion in client assets, $73 billion in lending balances, and nearly 16,000 Financial Advisors in 600+ offices across the U.S. Our Financial Advisors focus on delivering timely, customized solutions and services that help clients meet their financial and life goals. Our offering includes brokerage and investment advisory services, financial and wealth planning, access to credit and lending, cash management, annuities and insurance, and retirement services.


As a market leader, the talent and passion of our people is critical to our success. Together, we share a common set of values rooted in integrity, excellence and strong team ethic. Morgan Stanley can provide a superior foundation for building a professional career - a place for people to learn, to achieve and grow. A philosophy that balances personal lifestyles, perspectives and needs is an important part of our culture.


Department Profile

Global Banking Technology (GBT) 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, GBT is the place for you.


Position Description

The position will be responsible for the development of architect and database design, ETL components, providing user access to the data via reports, data extracts, utilizing analysis tools such as OLAP, and for coding stored procedures. The candidate will be working with multiple database systems (Teradata, HIVE, SQL Server, DB2, and Snowflake) including Cloud system, both on prem and public. The roll will require the candidate to possess a strong understanding of database concepts including data warehouse, operational data stores, and data marts. Responsibilities will also require in-depth knowledge of ETL concepts and hands-on experience in implementing data integrations in multiple database platforms using custom development, scripting language such as Unix Shell, and ETL tool such as Informatica. Candidate must have strong experience working with on-prem to cloud migration. Working expericien





Responsibilities:

* Design stable, scalable Application database/Datawarehouse.

* Identify potential improvements to the current design/processes.

* Plan and co-ordinate the data/process migration across databases.

* Participate in multiple project discussions as a senior member of the team.

* Serve as a coach/mentor for junior developers.

* Provide thought leadership.

* Lead team in new initiatives such as cloud strategy. Required Skills

* 15+ years of total experience.

* Experience working with AI tools (ex. copilot) and able to leverage AI tools to increase efficiency.

* Big data Technologies: Hadoop, Hive, Impala, spark, Pyspark, sqoop, HBase, Python

* Hand on experience working in the Cloud (Azure/AWS)

* Indept understand and experience working in architecture design (logical and physical design)

* Strong SQL skills and database programming skills including creating views, stored procedures, triggers, implementing referential integrity, as well as designing and coding for performance.

* Knowledge and hands-on experience of RDBMS systems (e.g.: Sybase, DB2, Teradata, Oracle, Snowflake).

* Good communication and leadership skills.

* Data Integration and ETL Tools: Dataiku, Azure Data Factory, Databricks, Informatica.

* Organization, discipline, detail-orientation, self-motivation, and focused on delivery.

* Strong Shell and Java scripting experience.




Desired Skills

* Experience in the Financial Industry.

* Knowledgeable of financial products Tailored Lending, Margin, Banking/Deposit, and Mortgages

* Experience in DataStage/Erwin

* Experience in building applications in Hadoop eco system (e.g.: HDFS, HADOOP, Pig, Hive).

* Experience with AngularJS

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 $150,000 and $210,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).