Associate, Risk/Policy Management

Morgan Stanley is a global financial services firm providing investment banking, securities, investment, and wealth management services. The Associate, Risk/Policy Management role develops Power BI dashboards and recurring management reports, translates business requirements into technical specifications, and collaborates with data, risk, and technology teams on reporting, analytics, and data curation.

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

Benefits

Telecommuting permitted up to 2 days per week.

Commission earnings may be included as part of the total compensation package.

Incentive compensation may be included as part of the total compensation package.

Discretionary bonuses may be included as part of the total compensation package.

Other short- and long-term incentive packages may be included as part of the total compensation package.

Morgan Stanley-sponsored benefit programs may be included as part of the total compensation package.

Comprehensive employee benefits and perks.

Opportunity to move about the business for those who show passion and grit in their work.

Company

Global investment banking, securities, wealth and investment management services

New York, New York, USA

http://www.morganstanley.com/

Founded in 1935

10001+ employees

Qualifications

Requires a Bachelor's degree in Computer Engineering, Computer Science or a related field

Requires three (3) years of experience in the position offered or three (3) years as a Software Engineer, Data Scientist, or a related role

Power BI software development, including data modeling and semantic layer implementation

Database and business intelligence management

Writing complex SQL queries using CTEs, subqueries, window functions, and aggregations

Performing complex joins and creating views to manipulate large datasets

Optimizing SQL queries through indexing and analysis to reduce latency

Writing and optimizing DAX calculations including query performance tuning in Power BI

Developing complex data transformation logic using the M formula language in Power Query

Creating dashboards based on business requirements using Power BI, with the ability to drill down data and visualize it with charts, reports, or dashboards

Maximizing query folding and ensuring efficient data transformations to minimize memory overhead and improve refresh speed

Designing and implementing incremental refresh policies for efficient handling of billion-row datasets

Performing granular partition processing using SQL Server Management Studio connected to Power BI workspaces

Designing and implementing dynamic parameters in Power Query, along with error handling and data profiling

Maintaining and supporting existing dashboards

Conducting deep dive model diagnostics using Vertipaq Analyzer to identify high cardinality columns

Implementing dynamic row-level security frameworks using DAX

Developing and deploying Power BI reports

Using MS Excel for data analysis and report generation using Power BI semantic models

Analytical scripting using Python libraries including Matplotlib or Seaborn

JIRA

Required skills

DAX, Data Modeling, JIRA, Matplotlib, Power BI Development, Power Query M Language, Python, Represents the skills you have, SQL, SQL Server Management Studio, Seaborn, Semantic Layer Implementation, VertiPaq Analyzer, click on the tags

Experience

3+ years