CAM Analyst II

M&T Bank•Getzville, NY

9d•$26 - $43

About The Position

Overview: Leads and/or participates in projects within one or more functional areas of Default Servicing (internally known as Customer Asset Management – CAM) and represents these areas in cross-functional, high-visibility projects. This role combines technical expertise in simple automation and data transformation with strong collaboration and communication skills to deliver efficient reporting solutions and process improvements. Primary Responsibilities: Serve as resource in a defined area of CAM and represent business practices and interests in various projects with internal and external stakeholders. Interact with business partners across Residential Mortgage platforms to leverage technology, system enhancements and projects, while also representing inclusive needs for all aspects of default servicing. Develop and produce non-routine departmental reports and spreadsheets, including project or product strategy analyses, historical reporting, workflow analyses and financial analyses for one or more functional areas of CAM. Conduct non-routine analysis and judgment-based work over a single or closely related disciplines to support CAM decisions. Conduct non-routine data review, research, and/or reconciliation for assigned areas of CAM. Build and maintain queries for data transformation and reporting, ensuring efficiency and scalability. Draft and/or edit procedures related to one or more functional areas of CAM to maintain their currency. Support departmental audits, user certifications and compliance testing for CAM. Lead and participate in planning, testing and implementing new projects, systems, products and regulatory changes impacting assigned CAM team(s). Rewrite and optimize existing queries, develop new tools, and contribute to strategic enhancements of reporting systems. Assist with providing departmental system support, coordinating with internal business partners, external vendors and Technology to address issues for assigned CAM team(s). Understand and adhere to the Company’s risk and regulatory standards, policies and controls in accordance with the Company’s Risk Appetite. Identify risk-related issues needing escalation to management. Promote an environment that supports belonging and reflects the M&T Bank brand. Maintain M&T internal control standards, including timely implementation of internal and external audit points together with any issues raised by external regulators as applicable. Complete other related duties as assigned. Supervisory/Managerial Responsibilities: Not Applicable Education and Experience Required: Associate degree and a minimum of 3 years’ related experience, or in lieu of a degree, a combined minimum of 5 years’ higher education and/or work experience, including a minimum of 3 years’ related experience Experience in collections and/or default servicing Experience with Visual Basic Applications (VBA) Experience with Power Query Proven analytical skills Strong organizational skills Expert level Excel skills Write advanced formulas. Use array formulas, named ranges, and advanced conditional formatting. Serve as an internal resource for Excel troubleshooting and guidance. Proven verbal and written communication skills Education and Experience Preferred: Prior experience in functional areas supported: Mortgage Default Servicing M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $26.00 - $43.34 Hourly (USD). The successful candidate’s particular combination of knowledge, skills, and experience will inform their specific compensation.

Requirements

Associate degree and a minimum of 3 years’ related experience, or in lieu of a degree, a combined minimum of 5 years’ higher education and/or work experience, including a minimum of 3 years’ related experience
Experience in collections and/or default servicing
Experience with Visual Basic Applications (VBA)
Experience with Power Query
Proven analytical skills
Strong organizational skills
Expert level Excel skills
Write advanced formulas. Use array formulas, named ranges, and advanced conditional formatting. Serve as an internal resource for Excel troubleshooting and guidance.
Proven verbal and written communication skills

Nice To Haves

Prior experience in functional areas supported: Mortgage Default Servicing

Responsibilities

Serve as resource in a defined area of CAM and represent business practices and interests in various projects with internal and external stakeholders.
Interact with business partners across Residential Mortgage platforms to leverage technology, system enhancements and projects, while also representing inclusive needs for all aspects of default servicing.
Develop and produce non-routine departmental reports and spreadsheets, including project or product strategy analyses, historical reporting, workflow analyses and financial analyses for one or more functional areas of CAM.
Conduct non-routine analysis and judgment-based work over a single or closely related disciplines to support CAM decisions.
Conduct non-routine data review, research, and/or reconciliation for assigned areas of CAM.
Build and maintain queries for data transformation and reporting, ensuring efficiency and scalability.
Draft and/or edit procedures related to one or more functional areas of CAM to maintain their currency.
Support departmental audits, user certifications and compliance testing for CAM.
Lead and participate in planning, testing and implementing new projects, systems, products and regulatory changes impacting assigned CAM team(s).
Rewrite and optimize existing queries, develop new tools, and contribute to strategic enhancements of reporting systems.
Assist with providing departmental system support, coordinating with internal business partners, external vendors and Technology to address issues for assigned CAM team(s).
Understand and adhere to the Company’s risk and regulatory standards, policies and controls in accordance with the Company’s Risk Appetite.
Identify risk-related issues needing escalation to management.
Promote an environment that supports belonging and reflects the M&T Bank brand.
Maintain M&T internal control standards, including timely implementation of internal and external audit points together with any issues raised by external regulators as applicable.
Complete other related duties as assigned.