Morgan Stanley

Data Engineer - Financial Crimes - Associate

Morgan Stanley$90K — $150K *
Finance & Insurance
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years of technology experience in the financial industry
  • Proficiency in PySpark, Python, and SQL coding
  • Strong background in relational databases and data modeling
  • Exceptional SQL query-writing capabilities
  • Excellent troubleshooting and analytical skills
  • Good communication skills, both verbal and written

Responsibilities

  • Design and implement robust PySpark-based ETL frameworks with error handling
  • Conduct data analysis and sourcing in relational and big data environments
  • Develop an understanding of technology systems and data pipelines
  • Translate business needs into data models and program specifications
  • Modify ETL programs to adapt to changing business requirements
  • Address data access queries and optimize query performance
  • Troubleshoot data issues and collaborate with upstream teams for resolution
  • Utilize AI tools to enhance data mapping and profiling processes

Benefits

  • Access to AI-enabled tools for improved data quality
  • Participate in a collaborative work environment
  • Potential for incentive compensation and discretionary bonuses
  • Opportunity for career development within the financial services sector
  • Comprehensive Morgan Stanley sponsored benefit programs
Full Job Description

This is a Principal Software Engineering position at Associate level which is part of the job family responsible for developing and maintaining software solutions that support business needs.

What you will do

  • Design, develop, and implement robustPySparkbased ETL frameworks with error handling and fault tolerance in distributed cluster environments.

  • Performdata enquiry,data analysisanddata sourcing inRelational 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 andprogramdesign 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(L3) production support as needed.

  • Use AIenabled tools to accelerate data mapping, data lineage creation, and data profiling, improving turnaround time and overall data quality.

What you will bring

  • Experience withcoding in all:Pyspark, Python, SQL

  • Strong knowledge of relational databases and data modeling

  • Strong SQL query-writing skills

  • Strong analyticaland troubleshooting skills.

  • At least 5 years financial industrytechnologyexperience and knowledge of financial services data

  • Good verbal and written communication skills

Desired Skills:

  • Hands-onExperience withGraph Database/Stardog

  • Experience withcodingAutosysjob definitions

  • Experience with Data Modeling tools (e.g.,Power Designer)

  • Experience in LinuxShell

  • Experience inJava Development

  • Experience and Understanding of Data Quality Rules and Implementation

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, discretionary bonuses, other short and long-term incentive packages, and other Morgan Stanley sponsored benefit programs.

About Morgan Stanley

Morgan Stanley Investment Management are active managers of capital, working to outperform the market and deliver results for their clients. Morgan Stanley Investment Management's long-tenured professionals apply their experience and expertise across public and private markets, in single-sector, multi-asset and custom solutions.

Morgan Stanley Careers

Joining Morgan Stanley today means becoming part of a global team dedicated to strengthening communities, pioneering innovation, and fostering diversity. As a leading global financial services firm, Morgan Stanley offers unparalleled job opportunities, career growth, and a culture of leadership that together create an exceptional employment experience. Work You’ll Do At Morgan Stanley, you will collaborate with knowledgeable professionals to drive innovation and deliver solutions in financial services. Our team is composed of diverse, talented individuals who bring their unique skills and perspectives to work every day, setting the standard for leadership in the global market. Morgan Stanley is not just a company; it's a place where ambitious, creative, and skilled individuals can build a rewarding career. Here, you can experience the benefits of a vibrant culture dedicated to professional growth and diversity training. Internship Programs Kickstart your career with Morgan Stanley’s internship programs. These positions offer invaluable industry insights and professional experience to students and recent graduates. Interns at Morgan Stanley gain hands-on experience, working alongside seasoned experts in a dynamic, supportive environment. Innovation and Professional Growth We believe in the power of innovation to solve complex problems and encourage our team to think differently and act boldly. Morgan Stanley supports your career development through comprehensive training, development programs, and leadership workshops, ensuring that every employee has the tools they need to succeed. Join Our Team Explore the various job opportunities at Morgan Stanley, from entry-level positions to executive roles. We are hiring individuals who are passionate about finance and eager to contribute to a team that values integrity, excellence, and a forward-thinking mindset. Enhance your skills through our networking events, mentorship opportunities, and ongoing professional development. Stay Connected Keep up to date with the latest from Morgan Stanley Careers by subscribing to our job alert emails. Tailor your preferences to receive updates about new postings, career tips, and exclusive insights from our team leaders. Apply Now Ready to take the next step in your career? Search open positions that match your skills and interests on the Morgan Stanley Jobs portal. Prepare your resume, refine your interview techniques, and join a company that values innovation and leadership. At Morgan Stanley, we’re not just building careers—we’re developing leaders. Discover how far your talents can take you by joining our team today.
Learn more about Morgan Stanley
Size
77,000 employees
Market Cap
$144.1 billion
Industry
Net Income
$10.9 billion
Founded
1935
5 Year Trend
+10%
Revenue
$52 billion
NASDAQ

Similar Jobs

More Jobs at Morgan Stanley

More Finance & Insurance Jobs

Find similar Data Engineer - Financial Crimes - Associate jobs: