Dir, P3, Software Eng III : Job Level - Director

Business Background
Position is for a Data Engineer role in TEDRA department.

TEDRA (Trade Enrichment Data Reporting & Allocations) is part of the Institutional Securities Technology (IST) Division. It 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.

Position Introduction
This is a Kafka data engineer role in the team responsible for developing on the firm's Trade Capture data stores that holds the transactional bigdata for real time and archive processing and getting it into the archives and data lake.
The global team consists of highly technical team members who are adaptable to both hands-on development and project management. We deliver multiple projects for multiple business areas in parallel. The business owners and subject matter experts will be globally distributed, making communication and pro-active to be important. You will be expected to work closely with our operations partners on requirements for projects.
The development will 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 able to work well in teams. Primary Responsibilities
1. Translate business requirement into queries against a set of relational tables and produce reporting based on the requirements.
2. Design and build scalable and performant databases.
3. Database and ETL development, including stored procedures, queries, performance tuning, archiving, etc.; using python, SQL and ETL tools.
4. Build efficient automation scripts (using Python etc.).
The current global team members are all very skilled in domain modeling, database design (both relational and noSQL), big data, kafka, and messaging so this is an excellent opportunity to play a key role in the growing team.

Technical Skills Requirement
> Strong relational database skills especially with DB2/Sybase/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. Primary Responsibilities
1. Translate business requirement into queries against a set of relational tables and produce reporting based on the requirements.
2. Design and build scalable and performant databases.
3. Database and ETL development, including stored procedures, queries, performance tuning, archiving, etc.; using python, SQL and ETL tools.
4. Build efficient automation scripts (using Python etc.).
The current global team members are all very skilled in domain modeling, database design (both relational and noSQL), big data, kafka, and messaging so this is an excellent opportunity to play a key role in the growing team.

Technical Skills Requirement
> Strong relational database skills especially with DB2/Sybase/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 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.

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.