Data Engineer - Director- Data & Analytics Engineering

Overview

We’re seeking someone to join our CDRR Technology team as a Data Engineer, in Firmwide Data Office to As a member of our Software Development team, we look first and foremost for people who are passionate about solving business problems through innovation and engineering practices. You'll be required to apply your depth of knowledge and expertise to all aspects of the software development lifecycle, as well as partner with stakeholders to stay focused on business goals.

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 Director position that provides specialist data analysis and expertise that drive decision-making and business insights as well as crafting data pipelines, implementing data models, optimizing data processes for improved data accuracy and accessibility, including applying machine learning and AI-based techniques.

Since 1935, Morgan Stanley is known as a global leader in financial services, always evolving and innovating to better serve our clients and our communities in more than 40 countries around the world.

What You’ll Do In The Role

• The Firmwide Data Office department is recruiting for an enthusiastic, dynamic, hands-on and delivery focused Data and ETL Engineer.
• As a member of our Software Development team, we look first and foremost for people who are passionate about solving business problems through innovation and engineering practices.
• You'll be required to apply your depth of knowledge and expertise to all aspects of the software development lifecycle, as well as partner with stakeholders to stay focused on business goals.
• We embrace a culture of experimentation and constantly strive for improvement and learning.
• You'll work in a collaborative, trusting, thought-provoking environment-one that encourages diversity of thought and creative solutions that are in the best interests of our customers globally.
• You'll combine your design and development expertise with a never-ending quest to create innovative technology through solid engineering practices. You'll work with highly inspired and inquisitive team of technologists who are developing & delivering top quality technology products to our clients & stakeholders.
  
  

• Minimum 4+ Years of strong development experience building robust Data ingestion pipelines using tools like Python, PySpark and Snowflake as well as Autosys/Airflow.
• Strong experience in writing multi-processing scripts using Python and distributed processing scripts using PySpark.
• Strong problem-solving skills, business acumen, and demonstrated excellent oral and written communication skills with both technical and non-technical audiences.
• Experience in closely working with application teams and managing all the DB related activities such as DB modeling, design, development, maintenance and support
• Strong experience in python for automating data cleansing, data re-formatting, data transformations
• Strong Skills in Relational Databases including database design, writing complex queries and stored procedures, performance tuning
• Strong Data Modeling skills - Enterprise Data Model (OLTP) and Dimensional modeling.
• Well versed with principles, techniques and best practices of data modeling.
• Extensive experience in designing and developing of complex mappings, applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner and sorter transformations
• Experience in integration of various data sources like DB2, SQL Server, and Flat Files into the staging area
• Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Modify, Aggregator, XML parsing stages.
• Knowledge about DevOps implementation in Data space
• Extensive experience working on UNIX/Linux platform, Python scripting and managing Bachelor's/Master's Degree in Computer Science, Computer Engineering, Data Analytics or related field
  
  

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

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.