Treasury Data Analyst II (Hybrid in Buffalo, NY)

M&T Bank•Buffalo, NY

1d•$71,600 - $119,300•Hybrid

About The Position

Provides technological and data support, including software support, report development, ETL (extract, transform, load) program design and in-depth data analysis. This is a hybrid position requiring four days/week of in-office work at the One M&T Plaza office in Downtown Buffalo, NY.

Requirements

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

Nice To Haves

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

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.