Sponsorship is not available for this position under any circumstances. Candidates who require sponsorship now or in the future—including all F‑1 visa holders (CPT, OPT, and STEM OPT)—will not be considered for this role.
This role will be based out of Buffalo NY or Rochester NY corporate office (4 days on site and 1 day remote)
This role focuses on improving how the bank leverages data to drive sales performance, incentive programs, and strategic decisions. The individual will partner across Business Banking, Retail, Commercial, and Technology teams to assess current processes, streamline and structure data, and support the transition to modern data platforms.
Key Responsibilities:
- Analyze and improve data processes related to sales production and incentive reporting
- Partner with cross-functional teams to modernize data architecture and reporting capabilities
- Develop and deliver leadership reporting and actionable insights
- Support data migration, validation, and testing to ensure accuracy and performance
- Identify best practices and recommend improvements based on enterprise-wide approaches
Required Skills & Qualifications:
- Strong analytical background with experience in data-driven environments
- Proficiency in Snowflake, SQL, Python, Tableau, Alteryx, and similar tools
- Experience working with large datasets and modern data platforms
- Strong collaboration and communication skills across business and technical teams
Additional Details:
- Focus: Business Banking, sales production, and incentive reporting
- Location: Buffalo (preferred); Rochester NY (secondary)
- Schedule: Standard business hours (Monday–Friday)
As the organization modernizes business analytics ecosystems, this role will facilitate the documentation, streamlining and migration of a business analytics SQL server used for sales, incentive, and strategic analytics in partnership with other divisions. Partners with team to understand and support current processes, dependencies and BAU workflows
Responsible for maintaining and evolving the division’s modernized data ecosystem to support enhanced analytical capabilities in partnership with other divisions and aligning with the organization’s data strategy and governance. Maintains structured data environment to enable AI-readiness. Explores AI use cases and other approaches to drive efficiencies.
Primary Responsibilities:•Document legacy SQL server databases, code and interdependencies with other environments, including other SQL servers, Snowflake, Teradata, and enterprise systems of record
•Solicit and understand business needs and translate into optimized database structures, SQL code or Alteryx workflows
•Coordinate with enterprise data and other divisions to source common data from Snowflake leveraging Alteryx, SQL, Python, Tableau and other tools
•Partner with technology and other divisions to migrate SQL server environment to a cloud or colocation server
•Evolve business analytics data ecosystem to support enhanced analytics capabilities, streamlined sales and incentive reporting processes, and AI-readiness
•Prepare well-documented functional specifications for assigned projects, test plans, test scripts and execution of test scripts.
•Responsible for research analysis of complex data ensuring functional design of assigned projects is accurate.
•Serve as subject matter expert to consult and advise on how applications may be impacted by enterprise- wide initiatives, like an acquisition or major change in products/services provided to customers.
•Participate in and document data mapping for integration of systems, conversion and acquisition-related projects to understand how applications may need to change or be impacted by enterprise-wide initiatives, like regulatory requirements, other system enhancements or business initiatives.
•Work with other testing teams, when applicable, to prepare test plans and scripts based on functional specifications, as well as to manage and/or execute test scripts verifying that changes and enhancements work and perform as required. Serve as functional lead with other project team members on other systems that impact the project
•Monitor functional specifications and change requests to ensure project stays within scope and meets regulatory requirements, while ensuring adherence to business requirements and Corporate Technology standards. Ensure the Bank process and documentation is followed to ensure adherence to Corporate Technology standards and regulatory requirements.
•Ensure change requests are consistently documented, reviewed and resolved to ensure application is working to support products and services required by line of business.
•Ensure efficient and timely resolution of issues arising from testing or implementation to ensure expected performance. Ensure issues, incidences and questions are documented, reported as resolved as required.
•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 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.
Education and Experience Required:Combined minimum of 8 years' combined higher education and/or operational/business analytics/systems development experience
Excellent verbal and written communication skills
Excellent organizational skills
Excellent time management skills
Excellent lateral thinking skills
Excellent problem-solving skills
Prior experience multitasking for various components of complex projects.
Prior experience coordinating between applications and business units.
Prior experience working in a team environment as well as autonomously.
Education and Experience Preferred:Bachelor's degree
Subject matter expert in business with knowledge or experience utilizing application/system being supported.
Proven mentoring and leadership capabilities
Ability to recognize project milestones and delivery dates.
Ability to recommend and implement solutions.
M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $103,000.00 - $171,600.00 Annual (USD). The successful candidate’s particular combination of knowledge, skills, and experience will inform their specific compensation.LocationBuffalo, New York, United States of AmericaSkills Required
- Strong analytical background with experience in data-driven environments
- Proficiency in Snowflake, SQL, Python, Tableau, Alteryx
- Experience working with large datasets and modern data platforms
- Strong collaboration and communication skills across business and technical teams
M&T Bank Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about M&T Bank and has not been reviewed or approved by M&T Bank.
-
Retirement Support — Retirement benefits are positioned as a strong pillar, including a 401(k) match and the possibility of an additional employer contribution, plus access to an employee stock purchase plan.
-
Leave & Time Off Breadth — Time-off offerings are framed as competitive, with a flexible PTO approach and paid volunteer time called out as a meaningful add-on to standard leave.
-
Wellbeing & Lifestyle Benefits — Wellbeing support appears comparatively robust, highlighted by mental-health therapy/coaching sessions and broader wellness programming alongside community-oriented perks.
M&T Bank Insights
What We Do
M&T Bank is a multi-state community-focused bank serving New York, Maryland, New Jersey, Pennsylvania, Delaware, Connecticut, Virginia, West Virginia and Washington, D.C. Founded in 1856, the company provides banking, investment, insurance and mortgage financial services to more than 3.6 million consumer, business and government clients.
