Associate, LCD Data and Analytics
Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, investment, and wealth management services. The role involves designing and developing business intelligence dashboards and data analytics solutions to assess operational risk, while collaborating with stakeholders to define business requirements and support implementation efforts.
Responsibilities
- Design and develop business intelligence dashboards and data analytics solutions used to assess operational risk
- Assist the control testing services team with building out automated control testing programs and risk-based sampling approaches
- Transform existing manual processes using automation and other methods including reporting and analytical solutions to allow for efficiency and repeatability
- Translate complex business requirements into creative and impactful designs
- Collaborate with business analysts and stakeholders to define business requirements, perform functional specification reviews, creation of test plans, and assist with testing coordination and signoffs
- Participate in IT sprint planning sessions and project prioritization sessions when applicable
- Ensure key risks and issues are identified, documented, mitigated, and communicated to the appropriate stakeholders or business analyst
- Provide pre and post implementation support, including dashboard maintenance and user education
- Participate in project working groups, requirement workshops, and meetings
Skills
- Master's degree in Quantitative Management, Information Systems, or a related field of study
- Six (6) months of experience in the position offered or six (6) months as an Analyst, or a closely related occupation
- Six (6) months of experience with SQL programming language
- Six (6) months of experience with Python and R for modeling, quantitative analysis, and automated scripts
- Six (6) months of experience with Relational Database and Database Management principles
- Six (6) months of experience with VBA macro automation and Power Query
- Six (6) months of experience with Excel including VLOOKUP, Pivot Tables, and Oracle Crystal Ball
- Six (6) months of experience providing business insights and recommendations based on analytical outcomes
- Six (6) months of experience with Regression modeling
- Six (6) months of experience with Machine Learning including Supervised and Unsupervised learning, training models leveraging historic datasets, and interpreting and evaluating model accuracy and performance
- Six (6) months of experience creating and maintaining Business Intelligence Applications for Risk Reporting in Tableau, Power BI, and IBM Cognos
- Six (6) months of experience with Software Development Lifecycle and Agile Development Principles
- Six (6) months of experience with Scrum Framework
- Six (6) months of experience with Agile Project Management tools including Jira and Microsoft Project
- Six (6) months of experience with Risk Management Framework in Financial Services
- Six (6) months of experience with Risk Metrics including Key Risk Indicator (KRI) and Key Performance Indicator (KPI) Reporting
- Six (6) months of experience with Risk Control Self Assessment
- Six (6) months of experience with Comprehensive Capital Analysis and Review (CCAR)
Benefits
- Medical
- Prescription Drug
- Dental
- Vision
- Health Savings Account
- Dependent Day Care Savings Account
- Life Insurance
- Disability and Other Insurance Plans
- Paid Time Off (including Sick Leave consistent with state and local law, Parental Leave and 20 Vacation Days annually)
- 10 Paid Holidays
- 401(k)
- Short/Long Term Disability
Company Overview
Company H1B Sponsorship