Data Engineer - VP Level

This is a Lead Data & Analytics Engineering position at the Vice President level, which is 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.

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 Lead Software Engineering position at Director level, which is part of the job family responsible for developing and maintaining software solutions that support business needs.

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.

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

TEDRA (Trade Enrichment Data Reporting & Allocations) is part of the Institutional Securities Technology (IST) Division. TEDRA is responsible for maintaining, distributing, and reporting on trading, revenue, risk, and reference data (client, product, and pricing). As the authoritative source of key data sets, we are at the forefront of database technology and are heavily involved in data engineering, data science, data visualization, and machine learning efforts across the Firm.

This is a data engineer role in the team responsible for developing the firm's data messaging platforms and data stores that holds both transactional, reference data and aggregated risk measures for real time and archive processing and getting it into the operational data stores (ODS), archives and DataMart.

The global team consists of highly technical team members who are adaptable and hands on in software development and life cycle management and proficient in devops. We deliver multiple projects for multiple business areas in parallel. The business owners and subject matter experts are globally distributed making communication to be important. The candidate is expected to collaborate closely with our users and support partners.

The development is to be performed using an agile methodology which is based on scrum (time boxing, daily scrum meetings, retrospectives, etc.) and XP (continuous integration, refactoring, unit testing, etc.) best practices. Candidates must therefore be able to work collaboratively, demonstrate good ownership and be a team player.

The current global team members are all very skilled in domain modeling, database design (both relational and noSQL), big data, Spark, kafka, and messaging where it is an excellent opportunity to play a key role in the growing team.

What you’ll do in the role:

• Design and build scalable and performant databases.

• Database and ETL development, including stored procedures, queries, performance tuning, archiving, etc.; using python, SQL and ETL tools.

• Build efficient automation scripts (using Python etc.).

What you’ll bring to the role:

• Strong relational database skills especially with DB2/SQL Server or/and Postgres/Greenplum.

• Kafka and MongoDB knowledge is a plus. However, willing to train.

• Knowledge of Spark, Snowflake, and Databricks is desirable.

• Create high quality and optimized stored procedures and queries.

• Experience with Power Designer or some similar modeling tool.

• Python and Unix / K-Shell.

• Strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts.

• Familiar with lifecycle of a trade and flows of data in an investment banking operation.

• Experienced in Agile development process.

• Effective communication skills.

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 85 years. At our foundation are five core values — putting clients first, doing the right thing, leading with exceptional ideas, committing to diversity and inclusion, and giving back — that guide our more than 80,000 employees in 1,200 offices across 42 countries. At Morgan Stanley, you’ll find trusted colleagues, committed mentors and a culture that values diverse perspectives, individual intellect and cross-collaboration. We Firm is differentiated by the caliber of our diverse team. While our company culture and commitment to inclusion define our legacy and shape our future, helping to strengthen our business and bring value to clients around the world. Learn more about how we put this commitment to action: morganstanley.com/diversity. 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.

We're committed to bringing passion and customer focus to the business.

Expected base pay rates for the role will be between $135,000 and $205,500 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).