Senior Business Analytics & Reporting Analyst - BSA/AML (hybrid Buffalo, NY)

M&T Bank; Buffalo (NY); On-site; USD 62,000 - 104,000; Full time

Job summary

M&T Bank in Buffalo, NY seeks an advanced analytics professional to develop new reports and dashboards, expand metrics, and present data improvement recommendations.

You will be a technical SME for the department's reporting environment, drive automated solutions, and support cross-functional, high-visibility projects with business partners.

Qualifications

• Bachelor's degree or 7+ years combined higher ed/work experience.
• 3+ years in a related business line role with reporting/analytics.
• Experience in cross-functional projects and audits is a plus.

Responsibilities

• Develop and maintain Git-based source control and CI/CD for analytics.
• Optimize SQL performance, including joins, indexing, and plans.
• Serve as SME for department reporting and data environment.
• Create mid-high complexity reports and financial analyses.
• Identify trends and present findings to stakeholders.

Skills

Git & CI/CD

SQL performance

Data analysis

Stakeholder communication

Education

Bachelor's degree

Tools

SQL Server

Job description

Overview:

This position will be responsible for providing an advanced level of support to their unit (dept) working across several simultaneous projects/programs by developing new reports and dashboards, expanding on existing metrics, as well as presenting recommendations for data improvement. Represent unit (dept) in cross functional, high visibility projects involving business partners outside of the department. Responsible for streamlining ongoing activities

Overview:

This position will be responsible for providing an advanced level of support to their unit (dept) working across several simultaneous projects/programs by developing new reports and dashboards, expanding on existing metrics, as well as presenting recommendations for data improvement. Represent unit (dept) in cross functional, high visibility projects involving business partners outside of the department. Responsible for streamlining ongoing activities

Primary Responsibilities:

• Develop and maintain Git-based source control and CI/CD practices for reporting and analytics solutions, including creation and management of repositories, branching strategies, version control, peer review, and deployment pipelines
• Apply SQL performance and optimization principles, including efficient joins, indexing considerations, query execution plans, filtering, data aggregation, and minimizing unnecessary movement or duplication of large datasets
• Possess working knowledge of Microsoft SQL Server architecture, including SQL Server databases, linked servers/connections, authentication, service accounts, database permissions, and connectivity across data sources and environments
• Serve as a technical SME for the departmental reporting and data environment, with the ability to understand the end-to-end architecture, identify inefficient or high-risk design patterns, and recommend more scalable, supportable, and automated solutions
• Develop and produce mid-high complexity departmental reports and spreadsheets to include but not limited to project or product strategy analysis, historical reporting, work flow analysis, and financial analysis.
• Identify trends, emerging issues and engage relevant stakeholders to develop project plans, organize virtual and physical events, synthesize multiple points of view and communicate findings utilizing such tools as white papers, reports and other relevant formats.
• Perform complex analysis and judgment based work over multiple disciplines to support business decisions
• Go beyond basic reporting and delivery with the ability to analyze large amounts of data and information to provide meaningful insights and professionally communicate those insights to management.
• Drive continuous improvement of existing processes, develop new processes or enhance existing processes where required including maintenance plans, procedural documentation and custom tools for automation. Identify resources that can be utilized to support business operations or improve existing business processes. Provide input and recommendations to management.
• Participate in the planning and implementation of new projects, programs, and plans to achieve short and long term business objectives; coordinate of the design and execution of various projects for the promotion and maintenance of the business.
• Take a lead role in supporting departmental audits including user recerts, compliance testing.
• Manage the planning, testing, and implementation of new projects, systems, products and regulatory changes impacting the unit (dept).
• Act as lead for departmental system support, coordinating with business partners, vendors and technology to address issues for the unit (dept).
• Adhere to applicable compliance/operational risk controls in accordance with Company or regulatory standards and policies.
• 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.

Experience and Education Required:

Bachelors and a minimum of 3 years related business line experience,

OR in lieu of a degree,

A combined minimum of 7 years higher education and/or work experience.

M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $62,200.00 - $103,600.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