Business Systems Analyst V - Oracle Enterprise OAC Platform Support

M&T Bank•Buffalo, NY

12h•$85,800 - $143,000•Onsite

About The Position

The Business Systems Analyst V facilitates complex projects from proposal through post-implementation and serves as a functional lead and subject matter expert for assigned applications. The role works with business, Finance, Data, Technology, vendor, and testing teams to understand requirements, develop functional specifications, coordinate project delivery, and ensure applications meet business, customer, regulatory, and Corporate Technology standards. The position supports Oracle FDI, UCL, and OAC reporting solutions for Finance reporting and data consumption. Work includes building and maintaining OAC datasets, semantic models, analyses, dashboards, and reporting content; developing UCL structures and extracts for downstream Finance consumers; supporting GL-to-instrument processing; and maintaining Workiva and Axiom extracts. The analyst also performs SQL-based data research, executes adjustments and testing, troubleshoots production issues, supports periodic reporting cycles, and maintains technical and operational documentation. The analyst coordinates project meetings and estimates, reviews requirements with technology teams, documents integration and conversion data mappings, and works with other teams to prepare and execute test plans and cases. The role mentors less experienced staff, manages scope and change requests, supports post-implementation reviews, and escalates risk-related issues. It also requires adherence to company risk, regulatory, and internal control standards and promotion of an inclusive environment reflecting the M&T Bank brand.

Requirements

At least 6 years of combined higher education and/or operational or business analytics experience.
Strong verbal and written communication skills.
Strong organizational and time-management skills.
Strong lateral-thinking and problem-solving skills.
Proficiency with personal computers and pertinent software packages.
Excellent problem-solving skills to assist in issue resolution.
Subject matter expertise in the supported business, with knowledge or experience using the application or system.
Ability to work on multiple complex projects.
Advanced understanding of supported applications and sound knowledge of interfacing or integrated applications.
Advanced knowledge of the overall system and ability to work on projects beyond normal business-as-usual activities.
Ability to use project management, word processing, and spreadsheet applications effectively.
Excellent understanding of the Bank’s application framework.
Familiarity with application development software and hardware platforms.
Ability to understand supported businesses and their terminology.
Ability to present effectively to all levels of management.
Ability to multitask across components of complex projects and coordinate between applications and business units.
Ability to work both independently and in a team environment.
Ability to recognize project milestones and delivery dates.
Ability to recommend and implement solutions.
Proactive and detail-oriented approach.
Strong understanding of Bank acquisition methodology or relevant conversion experience.

Nice To Haves

Bachelor’s degree.
Hands-on experience with Oracle FDI, Oracle Analytics Cloud (OAC), or comparable Oracle analytics technologies.
Experience developing OAC reporting content, datasets, semantic models, dashboards, or analyses.
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.

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 for 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.
Use 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 functional specifications, test plans, test cases, and execute test cases for assigned projects.
Research and analyze complex data to ensure project functional designs are accurate.
Mentor less experienced staff through application training, research analysis, and project methodology consultation.
Serve as functional lead on complex projects for assigned applications.
Schedule and facilitate project team meetings and document and distribute meeting minutes as applicable.
Meet with business clients to understand requested application changes and associated requirements.
Participate in design discussions and document and deliver functional specifications.
Provide feedback on business requirements to ensure applications support customer needs and business products and services.
Review business requirements with technology teams to ensure project requirements are understood.
Coordinate and provide estimates for large projects and assigned project components, including timelines and phases.
Advise on how applications may be affected by enterprise-wide initiatives, acquisitions, and major changes to products or services.
Work with vendors and technical teams to understand project functionality and provide implementation insight.
Serve as Test Coordinator for large initiatives involving multiple applications when needed.
Participate in and document data mapping for integrations, conversions, and acquisition-related projects.
Work with testing teams to prepare test plans and scripts and manage or execute test cases.
Serve as functional lead with project team members working on other systems that affect a project.
Monitor functional specifications and change requests to keep projects within scope and meet regulatory, business, and Corporate Technology standards.
Follow Bank processes and documentation requirements for Corporate Technology standards and regulatory compliance.
Ensure change requests are documented, reviewed, and resolved to support required business products and services.
Coordinate timely resolution of testing or implementation issues and document, report, and resolve issues, incidents, and questions.
Manage post-implementation activities, including gathering feedback, resolving issues, and completing a debrief comparing actual and planned timelines and financials.
Adhere to company risk and regulatory standards, policies, controls, and Risk Appetite; escalate risk-related issues to management.
Promote an environment that supports belonging and reflects the M&T Bank brand.
Maintain internal control standards, including timely implementation of internal and external audit points and applicable regulator issues.
Complete other related duties as assigned.