VP, Lead Data & Analytics Eng

Morgan Stanley; Montreal; On-site; CAD 100,000 - 125,000; Full time

Job summary

A leading global financial services firm in Montreal is seeking a skilled Data Engineer to develop data messaging platforms and enhance data stores. The ideal candidate will possess strong SQL and Python skills, have experience in ETL development, and thrive in agile environments. Collaborating with global teams, you'll play a key role in database technology and data engineering efforts, contributing alongside a talented team dedicated to excellence in client service.

Benefits

Comprehensive employee benefits

Opportunity for professional growth

Inclusive work environment

Qualifications

• Experience with building scalable and performant databases.
• Strong knowledge of relational database performance and tuning.
• Familiar with the lifecycle of a trade and data flows in banking.

Responsibilities

• Convert business requirements into queries for reporting.
• Develop ETL processes and automation scripts.
• Collaborate with team members to deliver projects.

Skills

Strong relational database skills

Python

SQL

Effective communication skills

Data analytics

Data visualization

ETL development

Agile development process

Tools

DB2

Postgres

Spark

Snowflake

Databricks

Power Designer

Kafka

MongoDB

Job description

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

Position Introduction

This is a data engineer role in the team responsible for developing the firms 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.

Primary Responsibilities

• business requirement into queries against a set of relational tables and produce reporting based on the requirements.
• and build scalable and performant databases.
• and ETL development including stored procedures queries performance tuning archiving etc.; using python SQL and ETL tools.
• efficient automation scripts (using Python etc.).

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 80000 employees in 1200 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.

Required Experience : Exec

Key Skills

• Adobe Analytics
• Data Analytics
• SQL
• Attribution Modeling
• Power BI
• R
• Regression Analysis
• Data Visualization
• Tableau
• Data Mining
• SAS
• Analytics

Employment Type : Full-Time

Experience : years

Vacancy : 1