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

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

Job summary

M&T Bank Corporation in Buffalo, NY, seeks an experienced analytics professional to develop advanced reports and dashboards, expand existing metrics, and present data-driven improvements across multiple projects. You'll streamline activities and act as a technical SME for the department's reporting and data environment.

Responsibilities include building CI/CD pipelines for analytics, optimizing SQL and data workflows, and delivering complex analyses to support strategic decisions.

Qualifications

• Bachelor's degree with a minimum of 3 years related business line experience, or 7 years combined education/work experience.
• Strong SQL performance and optimization knowledge applied to reporting and analytics.
• Ability to act as a technical SME for departmental reporting and data environment.

Responsibilities

• Develop and maintain Git-based source control and CI/CD practices for reporting and analytics solutions.
• Apply SQL performance and optimization principles, including efficient joins and indexing.
• Serve as a technical SME for the departmental reporting and data environment.
• Develop and produce mid-high complexity departmental reports and analyses.
• Identify trends and engage stakeholders to develop project plans and communicate findings.

Skills

SQL performance optimization

Data analysis

Cross-functional collaboration

Git-based source control

CI/CD practices

Education

Bachelor's degree

Tools

Git

CI/CD

SQL Server

Data Visualization tools

Job description

Overview

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

Salary

The pay range for this position is $62,200.00 - $103,600.00 Annual (USD)

Location

Location Buffalo, New York, United States of America

Company Overview

Great companies have an enduring sense of purpose. At M&T, our purpose is a simple one: make a difference in people’s lives and uplift the communities we serve. M&T Bank Corporation is a financial holding company headquartered in Buffalo, New York. M&T’s affiliates offer advice, guidance, expertise and solutions across the entire financial spectrum, combining M&T Bank’s traditional banking services with the wealth management and institutional capabilities offered by Wilmington Trust. M&T Bank has a network of over 1,000 branches and 2,200 ATMs that span 12 states from Maine to Virginia and Washington, D.C. For more than 165 years, M&T has strived to take an active role in our communities and build long-lasting relationships with our customers. We are a bank for communities—combining the capabilities of a large bank with the care of a locally focused institution. As an employer of choice, we are proud to offer competitive benefits ranging from medical and retirement to forty hours of paid volunteer time, each year. Our core values – integrity, ownership, collaboration, curiosity, and candor – drive the work we do. We seek to further build upon our record of success by bringing in top talent and fresh skill sets while continuing to support the growth and development of our team members

View Our Human Capital Report

View M&T’s Human Capital Report to learn more

Equal Employment Opportunity

M&T Bank is unwavering when it comes to providing equal employment opportunities to all employees and applicants without regard to race, color, national origin, religion, ethnicity, sex, gender identity, age, disability, citizenship, pregnancy, veteran status, military status, marital status, sexual orientation, genetic information or any other characteristic protected under applicable federal, state or local laws

Drug Free Workplace

M&T Bank Corporation has policies and procedures in place to promote a drug free workplace