Junior Data Analyst

Morgan-Stanley; Dallas (TX); On-site; USD 80,000 - 100,000; Full time

Job summary

Morgan Stanley in Dallas is seeking a Junior Data Analyst to support data wrangling, reconciliation, and reporting for Crypto-related investigative analytics within Financial Crime Risk. You will work with SQL, Python, Excel, and Alteryx to prepare datasets for investigative workflows and ensure data quality.

Collaboration across Fraud, GFC, and Technology teams is essential. Ideal candidates have 0-3+ years in data analysis, a detail-oriented mindset, and an interest in financial crime

Qualifications

• 0-3+ years of data analysis experience or related roles.
• Working knowledge of SQL or similar query languages; exposure to Python, Alteryx, Excel is a plus.
• Basic understanding of data validation, reconciliation, and data quality practices.
• Strong attention to detail, especially for data accuracy and control-oriented environments.
• Ability to work with structured and semi-structured datasets in a regulated setting.
• Interest in Financial Crime and Crypto-related analytics.

Responsibilities

• Perform foundational data wrangling and preparation across datasets related to Fraud, GFC, and blockchain transactions.
• Assist in data reconciliation and validation to ensure accuracy of investigation datasets.
• Support creation and maintenance of recurring reporting outputs and analytical deliverables.
• Work with senior analysts to prepare datasets for investigative workflows; structure and clean data for downstream use.
• Conduct data quality checks and escalate inconsistencies or anomalies.
• Collaborate with stakeholders across Fraud, GFC, and Technology teams to meet data needs.
• Assist in handling restricted datasets accessible to US-based staff with data governance controls.
• Contribute to production reporting support with recurring data refreshes and validation tasks.
• Document data processes, assumptions, and transformations in audit-ready format.

Skills

SQL

Python

Excel

Alteryx

Data wrangling

Data validation

Attention to detail

Tools

Alteryx

Excel

Job description

We're seeking someone to join our team as a Junior Data Analyst in NFR Data & Analytics to support data wrangling, reconciliation, and reporting workflows for Crypto-related investigative analytics within our Financial Crime Risk program.In the Legal & Compliance division, we assist the Firm in achieving its business objectives by facilitating and overseeing the Firm's management of legal, regulatory and franchise risk. This is an Analyst level position within the NFR Data & Analytics team, which supports Financial Crime and Fraud stakeholders by delivering data preparation, analytics, and reporting used in investigative workflows.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 you'll do in the role:Perform foundational data wrangling and preparation across datasets related to Fraud, GFC, and blockchain transactions.Assist in data reconciliation and validation activities to ensure accuracy and completeness of investigation datasetsSupport the creation and maintenance of reporting outputs and recurring analytical deliverables.Work with senior analysts to prepare datasets for investigative workflows, including structuring and cleaning data for downstream useConduct data quality checks and basic issue identification, escalating data inconsistencies or anomalies as appropriateSupport cross-functional data needs by collaborating with stakeholders across Fraud, GFC, and Technology teamsAssist in handling restricted datasets accessible only to US-based staff, ensuring adherence to data governance and access controlsContribute to production reporting support, including recurring data refreshes and validation tasksDocument data processes, assumptions, and transformations in a clear, audit-ready formatWhat you'll bring to the role:0-3+ years of experience in data analysis, data wrangling, or related analytical rolesWorking knowledge of SQL or similar query languages; exposure to data tools (e.g., Python, Alteryx, Excel) is a plusBasic understanding of data validation, reconciliation, and data quality practicesStrong attention to detail, particularly in data accuracy and control-oriented environmentsAbility to work with structured and semi-structured datasets in a regulated settingInterest in Financial Crime and Crypto-related analyticsStrong communication skills with the ability to follow requirements and translate data into structured outputsAbility to manage multiple tasks and work in a team-oriented, deadline-driven environmentWillingness to learn new tools, datasets, and analytical approaches in a rapidly evolving domainPlease note that the location listed for this role is temporary. The position’s work location will transition to 1445 Ross Ave, Dallas, TX 75202 at a future date . In-Person interviews will be required for the role.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 that’s differentiated – and we’ve 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 - aren’t just beliefs, they guide the decisions we make every day to do what's best for our clients, communities and more than 80,000 employees in 1,200 offices across 42 countries. At Morgan Stanley, you’ll 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. There’s 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 https://www.morganstanley.com/about-us/global-offices into your browser.Expected base pay rates for the role will be between $80,000 and $100,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.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.For more information, please visit : https://www.morganstanley.com/people-opportunities/eeo .