Business Systems Analyst VI- Buffalo NY

M&T Bank • Buffalo, NY

3d • Hybrid

About The Position

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

Requirements

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

Nice To Haves

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

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

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree