Lead Business Systems Analyst

M&T Bank Corporation; Buffalo (NY); On-site; USD 86,000 - 143,000; Full time

Job summary

M&T Bank in Buffalo, NY, seeks a senior project lead to facilitate complex finance analytics projects from proposal through post-implementation. You will coordinate business requirements, test plans, and functional specs while mentoring junior staff.

The role covers developing and maintaining Oracle FDI, UCL, and OAC reporting content, dashboards, and data extracts, with heavy focus on data validation, reconciliation, and production support across multiple systems.

Qualifications

• Minimum of 6 years combined higher education and/or operational/business analytics experience.
• Hands-on experience with Oracle FDI and/or Oracle Analytics Cloud (OAC) or comparable Oracle analytics technologies.
• Strong SQL and financial data analysis skills.
• Experience developing and supporting data extracts and downstream integrations.
• Understanding of General Ledger data and financial reporting processes.
• Experience with data validation, reconciliation, testing, and production support.
• Ability to independently troubleshoot data and reporting issues across multiple systems.
• Understanding of incident, problem, change, and release management processes.
• Strong documentation and communication skills.
• Experience with Workiva, Axiom, Oracle EPM, or Profitability reporting is preferred.

Responsibilities

• Develop, test, deploy, and maintain Oracle FDI, UCL, and OAC reporting solutions supporting Finance reporting and data consumption.
• Develop and maintain OAC datasets, semantic models, analyses, dashboards, and reporting content.
• Build and maintain UCL data structures and extracts supporting Workiva, Axiom, Profitability, and other downstream Finance consumers.
• Support GL-to-instrument processing, including data validation, exception analysis, reconciliation, and issue resolution.
• Develop and maintain Workiva and Axiom extracts and implement changes driven by reporting requirements.
• Execute adjustment-related data changes, testing, validation, and production implementation.
• Perform data analysis using SQL and available Oracle tools to research data and reporting issues.
• Execute system, integration, regression, and user acceptance testing for enhancements and production fixes.
• Troubleshoot production issues and identify root causes across FDI, UCL, OAC, source data, and downstream reporting.
• Support month-end, quarter-end, and year-end reporting activities.
• Maintain technical documentation, data mappings, testing evidence, operating procedures, and production support documentation.
• Work with Finance, Data, and Technology teams to resolve issues and deliver enhancements within established priorities and architecture.
• Prepare well documented functional specifications for assigned projects, test plans, test cases and execution of test cases.
• Serve as mentor to less experienced staff by assisting in application training, research analysis and project methodology consultation.
• Serve as functional lead on complex projects for assigned applications.
• Meet with business client to discuss requested application changes and document functional specifications.
• Coordinate and provide estimates for large projects and complete estimates for assigned component.
• Work with vendor and technical team to gain a thorough understanding of project functionality and provide insight on implementation.
• May serve as Test Coordinator for large project initiatives involving multiple applications.
• Document data mapping for integration of systems, conversion, and acquisition-related projects.

Skills

Verbal and written communication

Organizational skills

Time management

Analytical thinking

Problem solving

Documentation

Education

Bachelor's degree

Tools

Oracle FDI

Oracle Analytics Cloud (OAC)

Workiva

Axiom

Oracle EPM

Profitability reporting

Job description

M&T Bank in Buffalo, NY, seeks a senior project lead to facilitate complex finance analytics projects from proposal through post-implementation. You will coordinate business requirements, test plans, and functional specs while mentoring junior staff.

The role covers developing and maintaining Oracle FDI, UCL, and OAC reporting content, dashboards, and data extracts, with heavy focus on data validation, reconciliation, and production support across multiple systems.