Associate, LCD Data and Analytics

Summary: Morgan Stanley is a leading global financial services firm, and they are seeking an Associate, LCD Data and Analytics in Baltimore, MD. 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 provide pre and post implementation support. 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 Required Qualifications: - 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 - Comprehensive Capital Analysis and Review (CCAR) Required Skills: SQL, Python, R, Relational Database Management, VBA macro automation, Power Query, Excel, Oracle Crystal Ball, Regression modeling, Machine Learning, Business Intelligence Applications, Tableau, Power BI, IBM Cognos, Software Development Lifecycle, Agile Development Principles, Scrum Framework, Agile Project Management tools, Jira, Microsoft Project, Risk Management Framework, Key Risk Indicator Reporting, Key Performance Indicator Reporting, Risk Control Self Assessment, Comprehensive Capital Analysis, Review 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