Financial Data Analyst II

Company: M&T Bank
Location: Buffalo
Posted on: January 16, 2022

Job Description:

Financial Data Analyst II - Controller Overview:Conduct technical research, prepare/analyze financial, tax and/or regulatory information to provide to senior management, regulators, internal/external audit and other interested parties; adherence to internal controls while ensuring the quality of data being reported. - - - - Primary Responsibilities:

• Participate in and execute on the Department's data validation program, which tests the completeness and accuracy of data as it flows through various M&T systems. This includes performing analytics to identify anomalies in data, interpreting data lineage, querying data platforms to obtain data for testing, understanding code for reperformance of complex calculations and transformations made to the data, and working with our Enterprise Data Services and Business Lines to investigate and remediate any data issues. -
• Assist in the build out of an automated solution to some components of the data validation program.
• Assist with internal controls assessment and testing, including the build out of automated interface testing, working with Technology to build out testing scripts, assisting in the performance of user acceptance testing over the testing scripts, and ensuring proper IT controls around the testing scripts.
• Assist in the development of data governance initiatives including collaborating on the build out of end-to-end data lineage with the Enterprise Data Office and participate in the assessment of critical data fields by interpreting complex logic and investigating the potential impact of fields.
• Assist with the design of other projects as applicable and occasionally lead projects of moderate scope.
• Use judgment based on the analysis of information to identify meaningful information.
• May be required to make presentations to immediate managers or peers on subject matters in which they have expertise.
• Provide cross training/support to team members.
• Participate in training and development opportunities across Finance and among supported businesses.
• Understand and adhere to department timelines and deliverables.
• 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. Supervisory/Managerial Responsibilities:May train junior staff Education and Experience Required:
  • Bachelor's degree and a minimum of 2 years of experience OR Associate's degree and a minimum of 4 years of experience in either accounting, auditing, or data-centric discipline (data engineering, data science, data architecture, information systems, or computer science)
  • Good knowledge of database structure and data architecture
  • High level of PC competencies (Excel, PowerPoint, Word, MS SQL Server). -Data visualization or data querying applications preferred, including Teradata, Hive or Impala, as well as experience with Python programming. - - - - - - - - - - - -
  • Strong willingness to learn new tools or new ways of working for process improvement - - - - - - - - - - - - - - - - - - - - - -
  • Strong analytical and critical thinking skills
  • Good verbal and written communication skills
  • Professionally skeptical mindset
  • Strong attention to detail, problem-solving skills, and a technical, logical thought process Education and Experience Preferred:
    • Prefer previous data engineering or data architecture experience
    • Prefer previous IT Audit experience
    • Bachelor's degree in either accounting, data science/ analytics, information systems, computer science or related fields #LI-RS1LocationBuffalo, New York, United States of America

Keywords: M&T Bank, Buffalo , Financial Data Analyst II, Accounting, Auditing , Buffalo, New York