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

M&T Bank•Buffalo, NY

6d•$62,200 - $103,600•Hybrid

About The Position

The Senior Business Analytics & Reporting Analyst provides advanced support to a business unit across multiple simultaneous projects and programs. The role develops reports and dashboards, expands metrics, recommends data improvements, and represents the unit in high-visibility cross-functional initiatives. It also helps streamline ongoing activities and serves as a technical subject matter expert for the department’s reporting and data environment. The analyst produces complex reports and analysis, translates large datasets into meaningful insights for management, and supports business decisions through analysis across multiple disciplines. The role drives process improvement and automation, supports projects and regulatory changes, leads departmental system support and audit activities, and coordinates with internal partners, vendors, and technology teams. The position is based in Buffalo, New York, with a hybrid work arrangement.

Requirements

Bachelor’s degree and a minimum of 3 years of related business line experience; alternatively, a combined minimum of 7 years of higher education and/or work experience.
Working knowledge of Microsoft SQL Server architecture, including databases, linked servers or connections, authentication, service accounts, database permissions, and connectivity across data sources and environments.

Responsibilities

Develop and maintain Git-based source control and CI/CD practices for reporting and analytics solutions, including 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.
Serve as a technical subject matter expert for the departmental reporting and data environment, understand end-to-end architecture, identify inefficient or high-risk design patterns, and recommend scalable, supportable, and automated solutions.
Develop and produce mid- to high-complexity departmental reports and spreadsheets, including project or product strategy analysis, historical reporting, workflow analysis, and financial analysis.
Identify trends and emerging issues; engage stakeholders to develop project plans, organize virtual and physical events, synthesize viewpoints, and communicate findings through white papers, reports, and other formats.
Perform complex analysis and judgment-based work across multiple disciplines to support business decisions.
Analyze large amounts of data and information to provide meaningful insights and professionally communicate them to management.
Drive continuous improvement of existing processes and develop or enhance processes, maintenance plans, procedural documentation, and custom automation tools.
Identify resources that can support business operations or improve business processes and provide recommendations to management.
Participate in planning and implementing projects, programs, and plans to achieve short- and long-term business objectives; coordinate project design and execution.
Take a lead role in supporting departmental audits, including user recertifications and compliance testing.
Manage planning, testing, and implementation of projects, systems, products, and regulatory changes affecting the department.
Lead departmental system support and coordinate with business partners, vendors, and technology teams to address issues.
Adhere to applicable compliance and operational risk controls in accordance with company and 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 and applicable issues raised by external regulators.
Complete other related duties as assigned.