Career Search

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

Date Posted: 4/12/2018

Job Snapshot

Job Description

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, data manipulation and analysis.      
POSITION RESPONSIBILITIES: Maintain Structured Query Language (SQL) and extract, transform and loading processes established to aggregate various data sources across the Bank used in analysis and modeling.   Complete quality assurance on data feeds, rectifying inconsistent or erroneous data to ensure the accuracy of data used in these analyses; investigate and respond to ad-hoc data analysis questions.    Maintain the data structures through proper change management for use by multiple risk practice groups.    Provide application, server support and error resolution for the Treasury Business Analysts. Document and maintain data process procedures to serve as reference; adhere to established controls to ensure data quality.    Use appropriate analytical software to develop custom balance sheet and risk analytic.   Provide financial analysis and data support to other groups/departments across the Bank as needed.   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).   Create Technical / design specification based on business requirements in clear and concise formats.   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 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 Balance Sheet.    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.  
     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, or in lieu of a degree a combined minimum of 4 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.   
  IDEAL QUALIFICATIONS PREFERRED: Design and use of Tableau Analysis/Reporting tool Proven ability to manage and analyze large data sets, with careful attention to detail.         Strong interpersonal skills, with an equally strong desire to learn Advanced computer skills and strong knowledge of pertinent word processing, spreadsheet and database software. 2 years’ prior experience in banking or financial services industry. Minimum 1 years’ programming experience using SQL, SAS or related language. Minimum 1 years’ experience designing automated processes to move, format, standardize and scrub large amounts of data. Minimum 1 years’ experience building databases for the purpose of data standardization, data archiving and reporting. Experience creating, maintaining and managing SQL Server Integration (SSIS) packages.  
 
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.