Assoc, P2, Data & Analytics Eng II : Job Level - Associate

We are converting Joseph Connon to FTE. He is currently based in Glasgow as contractor and will move to London when he joins as FTE

Job Description -

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. TEDRA is also responsible for front and middle office post-execution applications that facilitate straight-through processing for multiple asset classes. This infrastructure is critical for electronic trading, high frequency trading in particular.

The Global Datamart team within TEDRA is looking for talented data engineers to join our global team who manage KDB+ systems. We have many ETL jobs which are adding data to a central KDB+ partitioned database and replicating it globally. There are extra processes for real time analysis and reporting, as well as a framework to cache and display data on many dashboards. We work closely with the Strats in Hong Kong/London/New York to ensure our KDB+ infrastructure is delivering on business asks and is resilient/future proof.

The responsibilities include -
> Develop current kdb+ based infrastructure to ensure support for queries from native Q and other languages (including Java,C#, python) and enhance the architecture to support a low latency, fast ingestion, highly available database. The goal is to provide easy access to a broad range of trading analytics, pricing and market information for the business units to help them make informed business decisions.
> Develop tools for data acquisition/loading, data quality, and production support covering a broad range of asset classes, data types, and frequencies that meet current and future trading, analytic, and operational needs
> Develop modularized, micro service based components

Responsibilities Include -
- KDB+ Infrastructure Engineering for stability, scalability and capacity planning.
- KDB+ functions: plan & execute database schema changes, bottleneck analysis, outage prevention/resolution, server/database performance improvements, database maintenance, database recovery, etc.
- KDB+ development (stored procedures, ETL, tools) and queries/stored procedures review and optimization.
- Enforce database security, standards & guidelines. Technical Skills Requirement:
- Scripting on linux platforms in languages such as Perl/Python and Unix
- Strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts, memory management, database configurations, etc. - Bachelor of Science Degree or equivalent
- 1-3 years experience or more in a similar field, particularly computing and database background
- Familiarity with KDB+

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.

Certified Persons Regulatory Requirements:
If this role is deemed a Certified role and may require the role holder to hold mandatory regulatory qualifications or the minimum qualifications to meet internal company benchmarks.

Flexible work statement
Interested in flexible working opportunities? Morgan Stanley empowers employees to have greater freedom of choice through flexible working arrangements. Speak to our recruitment team to find out more.

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.