Data Engineer - Financial Crimes - Associate

3 months ago

Base Salary

$90k - $150k/yr

Responsibilities

Design, develop, and implement robust PySpark-based ETL frameworks with error handling and fault tolerance.
Perform data enquiry, analysis, and sourcing in relational and big data database environments.
Develop 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 address evolving business requirements.
Respond to data access, query design, and performance optimization questions from business analysts and developers.
Troubleshoot data issues and collaborate with data providers and upstream teams to identify root causes and drive resolution.
Provide Level-3 production support as needed.
Use AI-enabled tools for data mapping, data lineage creation, and data profiling to improve turnaround time and data quality.

Experience coding in PySpark, Python, and SQL.
Strong knowledge of relational databases and data modeling.
Strong SQL query-writing skills.
Strong analytical and troubleshooting skills.
At least 5 years of financial industry technology experience and knowledge of financial services data.
Good verbal and written communication skills.
Preferred experience with graph databases and Stardog, Autosys job definitions, data modeling tools such as Power Designer, Linux Shell, Java development, and data quality rules and implementation.

Morgan Stanley offers comprehensive employee benefits and perks supporting employees and their families.
The role offers opportunities for career mobility within the business.
Expected base pay is $90,000 to $150,000 per year at commencement, with total compensation potentially including incentives, bonuses, and other benefit programs.

10,000+ employees