Business Systems Analyst VI - Oracle FDI/OAC Platform Support

M&T Bank•Buffalo, NY

1d•$103,000 - $171,600

About The Position

Responsible for facilitating complex projects from proposal through post-implementation. The role partners with lines of business to understand application requirements and the end-user experience, provides feedback, and leads project activities to ensure test plans and specifications are completed on time and established milestones are met. The position supports Oracle FDI and Oracle Analytics Cloud (OAC) platform reporting and production support. It translates Finance requirements into technical solutions, supports integrations and downstream reporting, investigates complex data and production issues, and helps ensure applications meet business, regulatory, and Corporate Technology standards. The role also provides technical direction and mentorship to other developers and support resources.

Requirements

Combined minimum of 8 years of higher education and/or operational, business analytics, or 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 across various components of complex projects.
Prior experience coordinating between applications and business units.
Prior experience working both in a team environment and autonomously.
Advanced hands-on expertise in Oracle FDI, Oracle Analytics Cloud (OAC), and enterprise Finance reporting/data solutions.
Demonstrated ability to architect and develop OAC reporting and analytics solutions.
Strong understanding of semantic modeling, reporting datasets, data integration, data transformation, and downstream reporting consumption.
Advanced SQL and financial data analysis skills, including tracing complex data issues across multiple layers and platforms.
Deep understanding of General Ledger, instrument-level financial data, adjustments, reconciliations, and Finance reporting.
Experience designing and supporting integrations or extracts for downstream platforms such as Workiva, Axiom, Oracle EPM, and Profitability.
Demonstrated experience leading complex production incidents and root-cause analysis across multiple systems.
Ability to translate Finance requirements into scalable technical solutions and evaluate alternative approaches.
Experience defining technical standards, operating procedures, testing approaches, and production support processes.
Strong ability to influence and align Finance, Data, and Technology stakeholders without relying solely on direct authority.
Ability to provide technical direction and mentorship to developers and support resources.
Subject matter expertise in the supported business application or system.
Proven mentoring and leadership capabilities.
Ability to recognize project milestones and delivery dates.
Ability to recommend and implement solutions.

Nice To Haves

Bachelor's degree

Responsibilities

Prepare functional specifications, test plans, test scripts, and execute test scripts for assigned projects.
Research and analyze complex data to ensure assigned projects’ functional designs are accurate.
Mentor less experienced staff in application training, research analysis, and project methodology.
Schedule and facilitate project team meetings and document and distribute minutes as applicable.
Meet with business clients to discuss requested application changes arising from business initiatives, regulatory or compliance requirements, contractual agreements, or routine system maintenance; clarify specifications and participate in design discussions.
Gather and review business requirements concerning application functionality and the end-user experience, provide feedback, and ensure technology teams understand project requirements.
Coordinate complex projects and estimate assigned project components, including timelines and phases.
Advise on application impacts from enterprise-wide initiatives such as acquisitions or significant changes to products and services.
Serve as test coordinator for large initiatives involving multiple applications, when needed.
Participate in and document data mapping for system integrations, conversions, acquisitions, regulatory requirements, system enhancements, and business initiatives.
Coordinate with testing teams to prepare test plans and scripts, manage or execute testing, and verify that changes and enhancements work as required; serve as functional lead with project members working on other impacted systems.
Monitor functional specifications and change requests to keep projects within scope, meet regulatory requirements, and adhere to business requirements and Corporate Technology standards.
Ensure change requests are documented, reviewed, and resolved so applications support business products and services.
Coordinate timely resolution and documentation of issues arising during testing or implementation.
Manage post-implementation follow-up, including gathering feedback, resolving issues, and conducting a debrief comparing actual results with planned timelines and financials.
Assist with expense and capital budgets and employee appraisals.
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 internal control standards, including timely implementation of audit points and issues raised by regulators, as applicable.
Complete other related duties as assigned.
Architect, develop, and support Oracle FDI and Oracle Analytics Cloud reporting and analytics solutions.
Support Finance reporting and data solutions, including semantic modeling, reporting datasets, data integration and transformation, and downstream reporting consumption.
Analyze financial data and trace complex data issues across multiple layers and platforms.
Support integrations or extracts for downstream platforms such as Workiva, Axiom, Oracle EPM, and Profitability.
Lead complex production incident investigations and root-cause analysis across multiple systems.
Define technical standards, operating procedures, testing approaches, and production support processes.
Influence and align Finance, Data, and Technology stakeholders and provide technical direction and mentorship to developers and support resources.