Treasury Data Analyst II (Hybrid in Buffalo, NY)

Work Location/Arrangement: This is a hybrid position requiring four days/week of in-office work at the One M&T Plaza office in Downtown Buffalo, NY.

Overview:

Provides technological and data support, including software support, report development, ETL (extract, transform, load) program design and in-depth data analysis.

Primary Responsibilities:

• Support design and implementation of routine and non-routine processes to extract, transform and load processes established to aggregate various data sources across the Bank used in analysis and modeling. Create technical and design specifications based on business requirements and in clear and concise formats.
• Lead documentation efforts as needed.
• Apply critical thinking to independently navigate issues.
• Support design of quality assurance on data feeds and remediation of inconsistent or erroneous data to ensure accuracy of data used in these analyses; investigate and respond to ad-hoc data questions.
• Support design and implementation of data structures through proper change management for use by multiple risk practice groups.
• Execute, maintain and design reports and data visualization using appropriate analytical software.
• Provide analysis and data support to groups and departments across the Bank as needed.
• 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.

Education and Experience Required:

• Bachelor's degree and minimum of 1 years' relevant work experience, or in lieu of a degree a combined minimum of 5 years' higher education and/or work experience, including a minimum of 1 years' relevant work experience
• Track record of strong ability to manage and analyze large data sets, with careful attention to detail
• Strong interpersonal skills, with an equally strong desire to learn
• Excellent computer skills and strong knowledge of pertinent word processing, spreadsheet and database software

Education and Experience Preferred:

• Bachelor's degree with coursework and proven proficiency in Computer Science, Computational Mathematics, Quantitative Finance, Management Information Systems or related subject area
• Minimum of 2 years' data analysis experience and/or prior experience in banking or financial services industry
• Programming experience using SQL, SAS or related language
• Experience designing automated processes to move, format, standardize and scrub large amounts of data
• Experience building databases for purposes of data standardization, data archiving and reporting
• Experience creating, maintaining and managing SQL Server Integration (SSIS) packages
• Programming experience using reporting or visualization software

M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $71,600.00 - $119,300.00 Annual (USD). The successful candidate's particular combination of knowledge, skills, and experience will inform their specific compensation.

Location

Buffalo, New York, United States of America