Data Engineer - Financial Crimes - Associate

About the role

This is a Principal Software Engineering position at Associate level within the Technology division of Morgan Stanley. The role supports the Firm's business needs through the development and maintenance of software solutions.

Responsibilities

• Design, develop, and implement robust PySpark-based ETL frameworks with error handling and fault tolerance in distributed cluster environments.
• Perform data enquiry, data analysis, and data sourcing in Relational and Big Data database environments.
• Develop a thorough understanding of technology systems, data stores, data pipelines, job streams, and downstream data consumers.
• Translate business requirements into data models and program design specifications.
• Modify ETL and related programs to implement changes driven by evolving business requirements.
• Respond to queries from business analysts and developers regarding data access, query design, and performance optimization.
• Troubleshoot data issues and collaborate with data providers and upstream teams to identify root causes and drive resolution.
• Provide Level-3 (L3) production support as needed.
• Use AI-enabled tools to accelerate data mapping, data lineage creation, and data profiling, improving turnaround time and overall data quality.

Requirements

• Experience with coding in all: Pyspark, Python, SQL
• Strong knowledge of relational databases and data modeling
• Strong SQL query-writing skills
• Strong analytical and troubleshooting skills
• At least 5 years financial industry technology experience and knowledge of financial services data

Qualifications

• Hands-on Experience with Graph Database/Stardog
• Experience with coding Autosys job definitions
• Experience with Data Modeling tools (e.g., Power Designer)
• Experience in Linux Shell
• Experience in Java Development
• Understanding of Data Quality Rules and Implementation

Skills

• Experience with PySpark
• Strong knowledge of SQL
• Strong analytical and troubleshooting skills

Benefits

Morgan Stanley offers a comprehensive benefits package including:

• Discretionary bonuses
• Incentive compensation
• Short and long-term incentive packages
• Employee benefits and perks
• Global offices across 42 countries

Pay

Expected base pay rates for the role will be between $90,000 and $150,000 per year at the commencement of employment. However, base pay if hired will be determined on an individualized basis and is only part of the total compensation package, which, depending on the position, may also include commission earnings, incentive compensation, and other Morgan Stanley sponsored benefit programs.

Schedule

Details on the schedule will be provided during the interview process.

Benefits

Morgan Stanley is an equal opportunity employer committed to building and maintaining a workforce that is diverse in experience and background. Our recruiting efforts reflect our strong commitment to a culture of inclusion, where individuals are hired, developed, and advanced based on their skills and talents. Our workforce reflects a broad cross-section of the global communities in which we operate, bringing a variety of backgrounds, talents, perspectives, and experiences.

Contact

To learn more about our offices across the globe, please copy and paste https://www.morganstanley.com/about-us/global-offices into your browser.