Associate, LCD Data and Analytics
About The Position
Morgan Stanley Services Group Inc. is seeking an Associate, LCD Data and Analytics in Baltimore, MD to 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. Telecommuting permitted up to 2 days per week.
Requirements
- Requires a Master’s degree in Quantitative Management, Information Systems, or a related field of study.
- Requires six (6) months of experience in the position offered or six (6) months as an Analyst, or a closely related occupation.
- Requires six (6) months years of experience with the following skills: SQL programming language; Python and R for modeling, quantitative analysis, and automated scripts; Relational Database and Database Management principles; VBA macro automation and Power Query; Excel including VLOOKUP, Pivot Tables, and Oracle Crystal Ball; providing business insights and recommendations based on analytical outcomes; Regression modeling; Machine Learning including Supervised and Unsupervised learning, training models leveraging historic datasets, and interpreting and evaluating model accuracy and performance; Creating and maintaining Business Intelligence Applications for Risk Reporting in Tableau, Power BI, and IBM Cognos; Software Development Lifecycle and Agile Development Principles; Scrum Framework; Agile Project Management tools including Jira and Microsoft Project; Risk Management Framework in Financial Services; Risk Metrics including Key Risk Indicator (KRI) and Key Performance Indicator (KPI) Reporting; Risk Control Self Assessment; and Comprehensive Capital Analysis and Review (CCAR).
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
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
5,001-10,000 employees
