Data Engineer - Director

About the role

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 Data & Analytics Engineering position at the Director 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.

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

Responsibilities

• Translate business requirement into queries against a set of relational tables and produce reporting based on the requirements.
• 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.)

Requirements

• Strong relational database skills especially with DB2/Sybase/SQL Server or/and Postgres/Greenplum.
• Required knowledge of Spark, Snowflake, and Databricks
• 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.

Benefits

At Morgan Stanley, we raise, manage and allocate capital for our clients – helping them reach their goals. We do it in a way that’s differentiated – and we’ve done that for 90 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.

Pay

Expected base pay rates for the role will be between $120,000 and $155,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.