Specialist III-IC Liquidity and Funding

BMO; Chicago (IL); Hybrid; USD 139,000 - 166,000; Full time

Benefits offered by this job

Health insurance

Tuition reimbursement

Accident and life insurance

Retirement savings plans

Job summary

BMO Bank N.A. is seeking a Specialist III-IC Liquidity and Funding to lead analytics for enterprise liquidity risk management. You will automate data pipelines, build dashboards, and support executive decision-making on liquidity and funding risk across scoping portfolios.

This role requires advanced data skills and collaboration with Risk, Finance, and Business teams. The position is hybrid with four days in the office weekly, and the salary range reflects Chicago, IL market norms.

Qualifications

• Master's degree in Finance, Data Science, Computer Science or related field (foreign equivalence accepted) plus 3 years of experience in data analytics, data engineering or CS.
• Bachelor's degree in Finance, Data Science, Computer Science or related field (foreign equivalence accepted) plus 5 years of experience in data analytics, data engineering or CS.
• Experience must include: SAS, R, SPSS, Python for data modeling; SQL for querying and creating tables/views; Dashboarding tools like Power BI or Tableau; advanced Excel pivots and lookups; cloud data platforms (Snowflake, AWS, GCP, Azure); data automation; discovering and translating client requirements; Jira/workflow management.

Responsibilities

• Automate and own end-to-end data pipelines from ingestion to dashboard reporting.
• Monitor daily liquidity stress testing and address issues with commitment items.
• Develop interactive reports/dashboards to visualize trends and breaches for upper management.
• Collaborate with market risk, business lines, and finance to identify and manage liquidity and funding risks.
• Advise on liquidity and funding matters including recovery and resolution planning.
• Develop and maintain the model/framework for liquidity risk measurement and scenarios.
• Lead large data models forecasting liquidity under stress scenarios.
• Coordinate with regulators and stakeholders on risk priorities and reporting.
• Provide insights to pricing and funds transfer pricing processes.

Skills

SAS

R

SPSS

Python

SQL

Dashboarding

Excel Pivot Tables

Snowflake

AWS

GCP

Azure

JIRA

Data Automation

Education

Master's degree in Finance, Data Science, Computer Science or related field

Bachelor's degree in Finance, Data Science, Computer Science or related field

Tools

Power BI

Tableau

Snowflake

AWS

GCP

Azure

Job description

BMO Bank N.A. seeks a Specialist III-IC Liquidity and Funding to support development and execution of Enterprise’s liquidity and funding risk management strategy for executive and Board approval in collaboration with Market Risk Management to recommend liquidity and funding-related risk appetite limits through robust data analytics and visualizations. Automate and own end-to-end data pipelines for different portfolios from data ingestion, transformation and analytics to dashboard reporting. Monitor performance of daily liquidity stress testing processes and address any issues related to commitment items. Develop interactive reports and dashboards to visualize trends and breaches, identify accounts exceeding allocated limits and enable upper management to make data driven decisions. Collaborate with market risk management, businesses, and finance to develop processes to identify, measure, and manage liquidity and funding risks. Advise business/group on liquidity and funding matters, including recovery and resolution planning. Develop and maintain the model and assumption framework used to measure liquidity and funding risk and recommend changes (e.g. review liquidity objectives, positions, and assumptions, including for new business transactions). Identify emerging issues and trends to inform decision-making and understand risk drivers. Recommend and implement solutions based on risk assessments, analysis of issues, and implications for the business. Manage the development of large data models to help forecast liquidity and funding capabilities of the bank under different stress scenarios. Liaise between stakeholders, including industry specialty groups and regulators, to align agendas and advocate company’s position on market or regulatory developments. Monitor performance of liquidity stress testing processes and address issues. Provide input into the planning and implementation of liquidity and funding risk modeling activities and programs. Integrate information from multiple sources to enable more efficient processes, identify patterns and outliers for enhanced data analysis and streamlined reporting. Monitor and track balance sheet usage. Design and produce reports and dashboards. Analyze data and information to provide insights into business product pricing and funds transfer pricing processes.

Requirements: Master's degree in Finance, Data Science, Computer Science or related field (willing to accept foreign education equivalent) plus three (3) years of experience as Solution Specialist, Data Scientist or related occupation in data analytics, data engineering, or computer science OR Bachelor's degree in Finance, Data Science, Computer Science or related field (willing to accept foreign education equivalent) plus five (5) years of experience as Solution Specialist, Data Scientist or related occupation in data analytics, data engineering, or computer science. Experience must include (quantitative experience requirements not applicable to this section):

• SAS, R programming, SPSS and Python for data modeling;
• SQL for querying and creating tables/views for downstream consumption;
• Dashboarding tools, including Power BI or Tableau;
• Data analytics and complex Excel pivot tables and lookup, including index+match, vlookup, and sumifs;
• Using cloud-based data platforms, including Snowflake, AWS, GCP, and Azure to create data structures;
• Optimized processing of data to allow data automation;
• Leading discoveries and gathering complex client requirements to create analytical solutions;
• and Workflow management and JIRA development and tracking.

Hybrid position requiring 4 days in office per week.

The salary range for this specific position in Chicago, IL is $138,632-165,600 per year

Salary:

$90,000.00 - $180,000.00

Pay Type:

Salaried

The above represents BMO Financial Group’s pay range and type.

Salaries will vary based on factors such as location, skills, experience, education, and qualifications for the role, and may include a commission structure. Salaries for part-time roles will be pro-rated based on number of hours regularly worked. For commission roles, the salary listed above represents BMO Financial Group’s expected target for the first year in this position.

BMO Financial Group’s total compensation package will vary based on the pay type of the position and may include performance-based incentives, discretionary bonuses, as well as other perks and rewards. BMO also offers health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans. To view more details of our benefits, please visit: https://jobs.bmo.com/global/en/Total-Rewards

About Us

At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world.

As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one – for yourself and our customers. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we’ll help you gain valuable experience, and broaden your skillset.

To find out more visit us at https://jobs.bmo.com/us/en

BMO is proud to be an equal employment opportunity employer. We evaluate applicants without regard to race, religion, color, national origin, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, transgender status, sexual stereotypes, age, status as a protected veteran, status as an individual with a disability, or any other legally protected characteristics. We also consider applicants with criminal histories, consistent with applicable federal, state and local law.

BMO is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process, please send an e-mail to [e-mail] and let us know the nature of your request and your contact information.