2539 jobs - 489 added today
Recruiting? Call us on 01772 639042
Email me jobs relevant to my job search
13 days ago
Morgan Stanley
Location: London
Job type: Permanent
Category: Design / Development Jobs
Job Description
Job Number:
3175921

Posting Date
: Jun 2, 2021

Primary Location
: Europe, Middle East, Africa-United Kingdom-United Kingdom-London

Education Level: Bachelor's Degree

Job
: Development

Employment Type: Full Time

Job Level: Associate

Description

Business Background
Position is for a 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 Description
This is a 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.}

{strategic data mart for OTC (Over the Counter) derivatives products. OTC derivative transaction and confirmation messages are fed into our data mart in real time and we provide data through a consolidated interface allowing our downstream systems to conveniently extract reports across multiple data marts.}

The candidate will be as part of the team involved in building scalable and high performance database and components for regulatory, business analytics (metrics reporting) and operational risk reporting.

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 (timeboxing, daily scrum meetings, retrospectives, etc.), Kanban Jira Boards and XP (continuous integration, refactoring, unit testing, etc.) best practices. The candidate will be able to work collaboratively within a larger team.

Key Responsibilities:
* Translate business requirement into queries against a set of relational tables and produce reporting based on the requirements.
* Design and build reporting layer from different data sources and act as a POC (Point of Contact) for user queries
* Database and ETL development, including stored procedures, queries, performance tuning etc, using SQL and ETL tools such as Informatica or Python Pandas.
* Create efficient testing automation script (using Python etc.) as part of the ETL or reconciliation process.
* Create BOXI (Business Objects) universes for self-service queries or build Tableau Dashboards for users metrics and KPIs.

The current global team members are all very skilled in domain modeling, database design, big data, Java and messaging so this is an excellent opportunity to play a key role in the growing team.

Organization

Skills Required/Desired:
* Strong relational database skills especially with DB2/Sybase.
* Experience in delivery of metrics / reporting in an enterprise environment (e.g. demonstrated experience in BI tools such as Business Objects, Tableau, report design & delivery)
* Strong understanding of ETL processes and experience with tools such as Informatica. Real time message processing experience is a big plus.
* Create high quality and optimized stored procedures and queries
* Experience with Power Designer or some similar modeling tool.
* Strong with scripting language such as 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 is a plus.
* Experienced in Agile development process
* Java Knowledge is a big plus but not essential

Email me jobs relevant to my job search

  Back to the top