← Back to jobsJob ID col-cmwjga4ce0h3j89hqpfx3h5qc

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

Qualifications

  • 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
  • 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
  • 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
  • the ability to understand the end-to-end architecture, identify inefficient or high-risk design patterns, and recommend more scalable, supportable, and automated solutions
  • Bachelors and a minimum of 3 years related business line experience
  • A combined minimum of 7 years higher education and/or work experience

Required skills

CI/CDData AnalysisGitMicrosoft SQL ServerSQL Performance Optimization

Full job description

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

M&T Bank

  • Senior Level
  • $62K/yr - $104K/yr

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

Benefits

  • Hybrid work arrangement

Qualifications

  • 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
  • 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
  • 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
  • the ability to understand the end-to-end architecture, identify inefficient or high-risk design patterns, and recommend more scalable, supportable, and automated solutions
  • Bachelors and a minimum of 3 years related business line experience
  • A combined minimum of 7 years higher education and/or work experience
  • 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
  • The ability to understand the end-to-end architecture, identify inefficient or high-risk design patterns, and recommend more scalable, supportable, and automated solutions
  • Bachelors and a minimum of 3 years related business line experience,
  • A combined minimum of 7 years higher education and/or work experience.

Required skills

  • CI/CD, Data Analysis, Git, Microsoft SQL Server, SQL Performance Optimization

Experience

  • 3+ years

Company

  • Full-service U.S. commercial bank with wealth management services.
  • Buffalo, New York, USA
  • https://www3.mtb.com/

Job details

Employment type

Full-time

Seniority level

3+ years

Sector · Sub-sector

Consulting · IT Consulting

Date posted

Nov 3, 2026

Work mode

Hybrid

Job source

mtb.wd5.myworkdayjobs.com

Company

M&T Bank

Consulting

Full-service U.S. commercial bank with wealth management services.

See all 4 jobs from M&T Bank →

Similar jobs

Matched on role, skills and location · live jobs only

See more Business Analyst jobs in Buffalo

New York Life

1w ago

Senior Associate - Business/Technical Analyst

Full-timeHybridNew York, NY$81K – $116K/yr

New York Life is hiring a Senior Associate - Business/Technical Analyst for its Tech Data AI Ventures team.

Why similarSame roleData AnalysisNew York

Zebra Technologies

1w ago

Operational Excellence, Business Analyst II

Full-timeHybridHoltsville, NY$68K – $103K/yr

Zebra Technologies is seeking an Operational Excellence Business Analyst II to support data-driven business decision-making.

Why similarSame roleData AnalysisHoltsville

J RAM IT Consulting

1w ago

Business System Analyst

Full-timeHybridNew York, NYCompetitive

J RAM IT Consulting is seeking a Business System Analyst with strong London-market experience. The role focuses on data mapping, source-to-target mapping, data analysis, and documenting business and functional requirements.

Why similarSame roleData AnalysisNew York

Get new Business Analyst jobs in Buffalo by email

Create job alert

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

M&T Bank · $62K – $104K/yr

Apply on company site