Associate, Data & Analytics Engineer

Morgan Stanley•South Jordan, UT

3d•Hybrid

About The Position

Morgan Stanley Services Group Inc. is seeking an Associate, Data & Analytics Engineer in South Jordan, UT to use data to create models depicting fraud trends in the customer base and the consumer population as a whole. Create data visualizations to understand fraud trends. Create effective technology solutions in improving efficiency using different analytical techniques and forecasting. Create rules in the rule’s engine and conduct pre- and post- production testing to ensure effectiveness. Collaborate with cross- functional groups such as Customer Service, Product Management, Engineering, and Technology to enhance tools, data sources, system functionalities, and fraud detection methods. Communicate trends, findings, proposals, and solutions to management and stakeholders. Measure performance using appropriate tools and techniques. Recommend or introduce new tools used for fraud detection, prevention and reporting activities. Execute complex SQL queries including joins, subqueries, unions, and temporary tables. Telecommuting permitted up to 3 days per week.

Requirements

Requires a Master’s degree in Information Systems, Computer Science, Computer Engineering, or a related field of study.
Requires two (2) years of experience in the position offered or two (2) years as an Associate, Business Technology Analyst, Systems Engineer, or a closely related occupation.
Requires two (2) years of experience with SQL queries including joins, subqueries, unions, and temporary tables.
Requires two (2) years of experience with data visualization to create interactive dashboards and reports.
Requires two (2) years of experience with data modeling, validation, testing, and cleansing.
Requires two (2) years of experience with designing and developing ETL pipelines to support end-to-end dataflows.
Requires two (2) years of experience with root cause analysis.
Requires two (2) years of experience with integrating and aggregating data from internal and external sources.
Requires two (2) years of experience with gathering business requirements from stakeholders and translating into actionable analytics solutions.
Requires two (2) years of experience with AGILE methodologies.
Requires two (2) years of experience with enhancing data accuracy through troubleshooting and validation across data layers.
Requires two (2) years of experience with communicating with stakeholders and executive leadership through presentations and reports.
Requires two (2) years of experience with cross-functional partnerships with product, technology, and operations teams to improve data capabilities and workflows.
Requires two (2) years of experience with financial services, data, and products including Online banking, Transaction Data, and Checking and Savings Accounts.
Requires two (2) years of experience with minimizing operational risk including limiting information shared outside the firm, securing firm data, and authenticating clients.

Responsibilities

Use data to create models depicting fraud trends in the customer base and the consumer population as a whole.
Create data visualizations to understand fraud trends.
Create effective technology solutions in improving efficiency using different analytical techniques and forecasting.
Create rules in the rule’s engine and conduct pre- and post- production testing to ensure effectiveness.
Collaborate with cross- functional groups such as Customer Service, Product Management, Engineering, and Technology to enhance tools, data sources, system functionalities, and fraud detection methods.
Communicate trends, findings, proposals, and solutions to management and stakeholders.
Measure performance using appropriate tools and techniques.
Recommend or introduce new tools used for fraud detection, prevention and reporting activities.
Execute complex SQL queries including joins, subqueries, unions, and temporary tables.