Associate, Risk/Policy Management

Morgan Stanley•New York, NY

7h•Hybrid

About The Position

Morgan Stanley Bank, N.A. is seeking an Associate, Risk/Policy Management in New York, New York to develop Power BI dashboards. Responsible for the design, development, and production of recurring management reporting. Participate in planning, coordinating and performing all activities related to design, development and implementation of organizational reporting and analytics. Convert business requirements into technical specifications and perform testing. Determine the timeline to accomplish tasks. Collaborate with the Data Control, Credit Risk Agile IT squads and Credit Officers to identify requirements to be onboarded in system. Participate in data curation activities.

Requirements

Bachelor’s degree in Computer Engineering, Computer Science or a related field
Three (3) years of experience in the position offered or three (3) years as a Software Engineer, Data Scientist, or a related role
Three (3) years of experience with Power BI software development, including data modeling and semantic layer implementation
Three (3) years of experience with Database and business intelligence management
Three (3) years of experience with Writing complex SQL queries using CTEs, subqueries, window functions, and aggregations
Three (3) years of experience with Performing complex joins and creating views to manipulate large datasets
Three (3) years of experience with Optimizing SQL queries through indexing and analysis to reduce latency
Three (3) years of experience with Writing and optimizing DAX calculations including query performance tuning in Power BI
Three (3) years of experience with Developing complex data transformation logic using the M formula language in Power Query
Three (3) years of experience with Creating dashboards based on business requirements using Power BI, with the ability to drill down data and visualize it with charts, reports, or dashboards
Three (3) years of experience with Maximizing query folding and ensuring efficient data transformations to minimize memory overhead and improve refresh speed
Three (3) years of experience with Designing and implementing incremental refresh policies for efficient handling of billion-row datasets
Three (3) years of experience with Performing granular partition processing using SQL Server Management Studio connected to Power BI workspaces
Three (3) years of experience with Designing and implementing dynamic parameters in Power Query, along with error handling and data profiling
Three (3) years of experience with Maintaining and supporting existing dashboards
Three (3) years of experience with Conducting deep dive model diagnostics using Vertipaq Analyzer to identify high cardinality columns
Three (3) years of experience with Implementing dynamic row-level security frameworks using DAX
Three (3) years of experience with Developing and deploying Power BI reports
Three (3) years of experience with Using MS Excel for data analysis and report generation using Power BI semantic models
Three (3) years of experience with Analytical scripting using Python libraries including Matplotlib or Seaborn
Three (3) years of experience with JIRA

Responsibilities

Develop Power BI dashboards.
Responsible for the design, development, and production of recurring management reporting.
Participate in planning, coordinating and performing all activities related to design, development and implementation of organizational reporting and analytics.
Convert business requirements into technical specifications and perform testing.
Determine the timeline to accomplish tasks.
Collaborate with the Data Control, Credit Risk Agile IT squads and Credit Officers to identify requirements to be onboarded in system.
Participate in data curation activities.