Business Systems Analyst V - Oracle Enterprise OAC Platform Support

M&T Bank•Buffalo, NY

1d•$85,800 - $143,000

About The Position

The Business Systems Analyst V facilitates complex projects from proposal through post-implementation, partnering with lines of business to understand application requirements and provide feedback on how applications meet end-user needs. The role serves as a functional lead on complex projects, ensuring functional specifications, test plans, test cases, project estimates, and milestones are completed and managed appropriately. The analyst researches complex data, supports project delivery, and is expected to become a subject matter expert in assigned systems within 18 months of assignment. The position develops, tests, deploys, and maintains Oracle FDI, UCL, and OAC reporting solutions for Finance reporting and data consumption. It supports data structures and extracts for Workiva, Axiom, Profitability, and other Finance consumers, as well as GL-to-instrument processing, adjustment-related data changes, and reporting integrations. The role performs SQL-based analysis, testing, production support, issue investigation, and troubleshooting across Oracle platforms, source data, and downstream reporting. It also supports month-end, quarter-end, and year-end reporting activities. Working with Finance, Data, Technology, vendors, and other project teams, the analyst gathers and documents requirements, participates in design and data-mapping discussions, coordinates testing, manages change requests, and helps ensure solutions comply with business requirements, Corporate Technology standards, and regulatory obligations. The role maintains technical and operational documentation, mentors less experienced staff, supports post-implementation reviews, and follows the Company’s risk, control, and regulatory standards.

Requirements

Minimum of 6 years of combined higher education and/or operational or business analytics experience.
Strong verbal and written communication skills.
Strong organizational skills.
Strong time management skills.
Strong lateral thinking skills.
Strong problem-solving skills.
Proficiency with personal computers and pertinent software packages.
Ability to work on multiple complex projects and multitask across project components.
Ability to work both independently and in a team environment.
Ability to coordinate between applications and business units.
Ability to recognize project milestones and delivery dates.
Ability to recommend and implement solutions.
Detail-oriented and proactive.
Ability to understand the supported business and its terminology.
Ability to effectively present to all levels of management.
Advanced understanding of supported applications and interfacing or integrated applications.
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.
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.
Subject matter expertise in the business area and knowledge or experience using the supported application or system.

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 through 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, and test cases, and execute test cases for assigned projects.
Research complex data and ensure functional designs for assigned projects are accurate.
Mentor less experienced staff through application training, research analysis, and project methodology consultation.
Serve as functional lead on complex projects, schedule and facilitate project team meetings, and document and distribute meeting minutes as applicable.
Meet with business clients to understand requested application changes and document and deliver required functional specifications.
Participate in design discussions and review business requirements with technology teams.
Coordinate and provide estimates for large projects and assigned project components, including timelines and phases.
Serve as a subject matter expert advising on application impacts from enterprise-wide initiatives.
Work with vendors and technical teams to understand project functionality and provide implementation insight.
May serve as Test Coordinator for large initiatives involving multiple applications.
Participate in and document data mapping for system integrations, conversions, and acquisition-related projects.
Coordinate with testing teams to prepare plans and scripts and manage or execute test cases.
Monitor functional specifications and change requests to keep projects within scope and aligned with regulatory requirements, business requirements, and Corporate Technology standards.
Ensure change requests are documented, reviewed, and resolved, and that Bank processes and documentation standards are followed.
Coordinate timely resolution and documentation of issues, incidents, and questions arising during testing or implementation.
Manage post-implementation feedback, issue resolution, and debriefs comparing actual and planned timelines and financials.
Follow Company risk and regulatory standards, policies, and controls; identify risk-related issues requiring escalation.
Promote an environment that supports belonging and reflects the M&T Bank brand.
Maintain M&T internal control standards, including timely implementation of audit points and applicable issues raised by external regulators.
Complete other related duties as assigned.