Business Systems Analyst VI- Buffalo NY

M&T Bank•Buffalo, NY

4d•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

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

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