Data Engineer Director- Data & Analytics Engineering

Profile Description

Were 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. Youll 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 youll 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.
• Youll 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.
• Youll 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.
• Youll combine your design and development expertise with a never-ending quest to create innovative technology through solid engineering practices. Youll work with highly inspired and inquisitive team of technologists who are developing & delivering top quality technology products to our clients & stakeholders.

What youll bring to the role:

• 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 Bachelors/Masters Degree in Computer Science Computer Engineering Data Analytics or related field

WHAT YOU CAN EXPECT FROM MORGAN STANLEY:

At Morgan Stanley we raise manage and allocate capital for our clients helping them reach their goals. We do it in a way thats differentiated and weve 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 - arent just beliefs they guide the decisions we make every day to do whats best for our clients communities and more than 80000 employees in 1200 offices across 42 countries. At Morgan Stanley youll 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. Theres 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 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.