Business Systems Analyst VI- Buffalo NY

Business Systems Analyst VI- Buffalo NY Location: Buffalo, NY 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) Overview: 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. Location Buffalo, New York, United States of America