Career Search

Senior Data Analyst - 3DHYV in Buffalo, NY at M&T Bank

Date Posted: 6/6/2018

Job Snapshot

Job Description

Senior Data Analyst
Buffalo, NY


 


 

BASIC FUNCTION:

The Treasury Department develops and utilizes various analytic tools and quantitative models to provide the bank with insight into its current and future risk position as it relates to management of assets/liabilities and liquidity.  Provides technological and data support, including software support, report development and data manipulation and analysis.  

 

POSITION RESPONSIBILITIES:

 Design and implement Structured Query Language (SQL) and extract, transform and loading processes established to aggregate various data sources used in analysis and modeling.   Design quality assurance on data feeds, rectifying inconsistent or erroneous data to ensure accuracy of data used in these analyses; investigate and respond to ad-hoc data questions. 

Provide application and server support and error resolution for the Treasury Business Analysts. Document and maintain proper data process procedures to serve as reference; adhere to established controls to ensure quality in the audit process by maintaining and providing complete and precise documentation and controls evidence. 

Use appropriate analytical software to develop custom balance sheet and risk analytic reports.  Manage Treasury Division projects and initiatives under the guidance and direction from management.  Present data, results and/or recommendations from the Project team to senior management as necessary.

Create Technical / design specification based on business requirements in clear and concise formats.

Provide leadership to the Treasury team in researching, developing, implementing, testing data dimensions and other functionality within the data environment.  Provide financial analysis and data support to other groups/departments across the Bank as needed.

Provide thoughtful analysis to enhance reporting functionality and automation of processes.

Provide guidance and direction to less experienced analysts on data analysis and maintenance of data infrastructure.

Research and provide workflow solutions and process improvement opportunities through data analysis.

Support presentation and visualization of data through standard tools (e.g.Tableau).

Provide support for model developers via data access and  presentation.

Support Treasury Division contributions to bank wide efforts (e.g. Stress Testing).

Provide thoughtful analysis to enhance reporting functionality and automation of processes.

Conduct business in compliance with regulatory guidance including SR (Supervision and Regulation Letters) 10-1, SR 10-6, SR 11-7, Enhanced Prudential Standards, etc.  Adhere to applicable compliance/operational/model risk controls and other second line of defense and regulatory standards, policies and procedures.

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 diversity 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.

 

NATURE AND SCOPE:

The Asset-Liability Management Group’s primary responsibility is to manage the interest rate and liquidity risk of M&T Bank Corporation’s balance sheet.  The analysis created is used by the Bank’s management to support strategic business decisions.  Through this process the group develops strategies to manage the composition of the Bank’s investment portfolio. 

This role is highly technical in nature and requires demonstrated attention to detail, execution, and follow-up on multiple initiatives within the Treasury Division and across the Bank.  The ability to identify, analyze, rationalize and communicate complex business, data problems, and recommend corresponding solutions is a key factor of success in this role.

It is important for the position to communicate with clear narratives, compelling data visualization and technical precision, whether verbally or in-writing.

The position also leads team-based projects related to model development or implementation.

 

MANAGERIAL/SUPERVISORY RESPONSIBILITY:

Not applicable

 

MINIMUM QUALIFICATIONS REQUIRED:

Bachelor’s degree with coursework and proven proficiency in Computer Science, Computational Mathematics, Quantitative Finance, Management Information Systems or related subject area, and a minimum of 3 years’ proven data analysis experience, or in lieu of a degree a combined minimum of 7 years’ higher education and/or work experience, including coursework and proven proficiency in Computer Science, Computational Mathematics, Quantitative Finance, Management Information Systems or related subject area, and a minimum of 3 years’ proven data analysis experience. 

 

 

IDEAL QUALIFICATIONS PREFERRED:

Minimum of 3 years’ prior data analysis experience in banking or financial services industry.

Minimum of 3 years’ proven Asset/Liability experience, with knowledge of QRM Risk Framework.

Experience creating, maintaining and managing SQL Server Integration (SSIS) packages.

Programming experience using  SAS, Tableau, QlikView, SSAS, SSRS, VBA, VB.Net, Crystal Reports.

Advanced knowledge of pertinent word processing, spreadsheet and database software.

Experience in mathematical modeling of financial instruments.

Proven track record for being able to work autonomously, work within a team environment, exhibiting demonstrated leadership and a strong desire to learn and contribute to a group.

Proven experience in leading medium sized projects.

Proven track record of multi-tasking and functioning in a team-based work environment.

Proven ability to manage and analyze large data sets, with careful attention to detail.

Minimum of 2 years’ on-the-job programming experience using Structured Query Language (SQL).

Minimum of 2 years’ on-the-job experience designing automated processes to move, format, standardize and scrub large amounts of data.

Minimum of 2 years’ on-the-job experience building databases for the purpose of data standardization, data archiving and reporting.

Strong interpersonal skills, with an equally strong desire to learn

Advanced computer skills and strong knowledge of pertinent word processing, spreadsheet and database software.

About M&T
At M&T, we strive to be the best place our employees ever work, the best bank our customers ever do business with and the best investment our shareholders ever make. So when looking to advance your career, look to M&T. As a top 20 US bank holding company and one of the best performing regional banks in the country, we offer a wide range of performance based career development opportunities for talented professionals. And through our longstanding tradition of careful, conservative and consistent management and a strong commitment to the communities we serve, we continue to grow with a focus on the future.M&T Bank Corporation is an Equal Opportunity/Affirmative Action Employer.
M&T Bank Corporation does not sponsor individuals for the purpose of obtaining H-1 Visas.
M&T Bank Corporation has policies and procedures in place to promote a drug free workplace.