Data Architect
New York , New York
October 18, 2017
Company Profile
Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, investment management and wealth management services. The Firm's employees serve clients worldwide including corporations, governments and individuals from more than 1,200 offices in 43 countries.
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.

Technology works as a strategic partner with Morgan Stanley business units and the world's leading technology companies to redefine how we do business in ever more global, complex, and dynamic financial markets. Morgan Stanley's sizeable investment in technology results in quantitative trading systems, cutting-edge modelling and simulation software, comprehensive risk and security systems, and robust client-relationship capabilities, plus the worldwide infrastructure that forms the backbone of these systems and tools. Our insights, our applications and infrastructure give a competitive edge to clients' businesses-and to our own.

MS Wealth Management (MSWM) Technology
Morgan Stanley Wealth Management (MSWM) Technology is the global technology department responsible for the design, development, delivery and support of the technical solutions behind the products and services used by the Morgan Stanley Wealth Management (MSWM) business. The department is comprised of 10 organizations: Sales, Banking & Corporate-Client Technology, Investment Products & Markets Technology, Client Reporting, Core Processing, Private and International Wealth Management Technology, Technology Integration Office, Enterprise Infrastructure & Production Management, Capital Markets Application & Data Services, Deployment Planning & Release Management, and the Chief Operating Office. Morgan Stanley Wealth Management (MSWM) Technology works with large scale databases such as DB2 and SQL Server, proprietary and non-proprietary messaging software, a broad variety of vendor products, numerous financial exchanges and regulatory entities, and programming languages ranging from .Net and Java to Cobol and VB.Net.
Location: USA - NY - New York
Global Region: North America
Experience Level: 10-15
Education Level: Bachelor's Degree

Position Description:
Morgan Stanley has recently embarked on an aggressive strategy to increase capabilities and assets in the banking space (deposits, lending, etc.). To support this rapid business expansion, the growth of technology capabilities and services is critical. The position is in a data and reporting group focused on delivering both tactical and strategic database solutions to support sales reporting and risk analysis for retail banking. The individual will participate in the development on data, reporting projects and consult on other strategic and tactical database initiatives.

This position is for a hands-on Senior Data Architect with a minimum of 10-15 years working in the financial IT community. Candidate must possess a strong background in database (Teradata, DB2 and/or Oracle) design and implementation including data warehouse, operational data stores, and data marts. Candidate should have in-depth knowledge and hands-on experience in SQL, performance tuning, ETL (Perl, Informatica), reporting (Business Objects), and data analysis.

The candidate must have strong communication skills and be able work with both users and lead IT team members in a highly collaborative team environment. Candidate should be disciplined, detail-oriented, self-motivated, and delivery-focused.

To be successful, the role will require the individual to understand the banking technology landscape, and to offer creative solutions that integrate current capabilities, vendor capabilities, proprietary system builds, and the ability to adapt to changing database platforms

Skills Required:
- Extensive database/data warehouse design, modeling experience (Power Designer/Erwin).
- In-depth knowledge and hands-on experience with data integration ETL development
- In-depth knowledge and hands-on experience of database/appliance systems, specifically Teradata, Sybase, Oracle and/or DB2
- In-depth knowledge and hands-on experience with reporting and analytic tools such as Business Objects, Tableau, SAS, etc.
- Strong Communication skills
- Team management skills

Skills Desired:
- Experience in the Financial Industry.
- Strong SQL and database performance tuning skills
- Big data knowledge or experience
- Experience with data service architecture.
- Batch processing and scripting in UNIX/Linux Environment (shell scripting, Perl, Autosys)

A little about us:
Since its founding in 1935, Morgan Stanley and its people have helped redefine the meaning of financial services.

Know someone who would be interested in this job? Share it with your network.