Associate, Risk/Policy Management

89 Morgan Stanley Bank, N.A.; New York (NY); Hybrid; USD 125,000 - 140,000; Full time

Job summary

Morgan Stanley Bank, N.A. in New York, NY seeks an Associate, Risk/Policy Management to design, develop and productionize Power BI dashboards and analytics. You will convert business requirements into technical specs, perform testing, and coordinate with Data Control and Credit Risk squads to onboard requirements.

Telecommuting is permitted up to 2 days per week. The role requires a Bachelor's degree in Computer Engineering or Computer Science and 3 years of relevant experience, including

Qualifications

• Bachelor's degree in Computer Engineering, Computer Science or related field.
• 3 years of experience in software engineering, data science or related role.
• Strong Power BI development including data modeling and semantic layer implementation.

Responsibilities

• Design, develop, and productionize recurring management reporting and dashboards.
• Collaborate with Data Control, Credit Risk Agile IT squads and Credit Officers to onboard requirements.
• Convert business requirements into technical specifications and perform testing.

Skills

Power BI

SQL

DAX

Python

Data modeling

ETL/Transformations

M language

Power Query

VerriPitax Analyzer

Row-level security

Excel

JIRA

Education

Bachelor's degree in Computer Engineering or Computer Science

Tools

SQL Server Management Studio

Power BI

Vertipaq Analyzer

Job description

Company Profile: Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, investment, and wealth management services. The Firm's employees serve clients worldwide, including corporations, governments, and individuals from more than 1,200 offices in 43 countries. In the Firm Risk Management division, we advise businesses across the Firm on risk mitigation strategies, develop tools to analyze and monitor risks and lead key regulatory initiatives.

What you'll do

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. Telecommuting permitted up to 2 days per week.

What you'll bring to the role

• -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
• - Requires three (3) years of experience with the following skills: 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; and JIRA.

WHAT YOU CAN EXPECT FROM MORGAN STANLEY:

At Morgan Stanley, we raise, manage and allocate capital for our clients - helping them reach their goals. We do it in a way that's differentiated - and we've done that for 90 years. Our values - putting clients first, doing the right thing, leading with exceptional ideas, committing to diversity and inclusion, and giving back - aren't just beliefs, they guide the decisions we make every day to do what's best for our clients, communities and more than 80,000 employees in 1,200 offices across 42 countries. At Morgan Stanley, you'll find an opportunity to work alongside the best and the brightest, in an environment where you are supported and empowered. Our teams are relentless collaborators and creative thinkers, fueled by their diverse backgrounds and experiences. We are proud to support our employees and their families at every point along their work-life journey, offering some of the most attractive and comprehensive employee benefits and perks in the industry. There's also ample opportunity to move about the business for those who show passion and grit in their work. Expected base pay rates for the role will be between $125,000 and $140,000 per year at the commencement of employment. However, base pay if hired will be determined on an individualized basis and is only part of the total compensation package, which, depending on the position, may also include commission earnings, incentive compensation, discretionary bonuses, other short and long-term incentive packages, and other Morgan Stanley sponsored benefit programs. Morgan Stanley is an equal opportunity employer committed to building and maintaining a workforce that is diverse in experience and background. Our recruiting efforts reflect our strong commitment to a culture of inclusion, where individuals are hired, developed, and advanced based on their skills and talents. Our workforce reflects a broad cross-section of the global communities in which we operate, bringing a variety of backgrounds, talents, perspectives, and experiences. For more information, please visit: https://www.morganstanley.com/people-opportunities/eeo. At Morgan Stanley, we advise, originate, trade, manage and distribute capital for people, governments and institutions, always with a standard of excellence and guided by our core values. Morgan Stanley is dedicated to providing first-class service to our clients, in a way that reflects our commitment to creating a more sustainable future and fostering stronger communities around the world. In each line of business, we strive to demonstrate our belief in the power of transformative thinking, innovative strategies and leading-edge solutions - and in the ability of capital to work for the benefit of all society.