Business Systems Analyst V - Oracle Enterprise OAC Platform Support

001 Manufacturers and Traders Trust Co; Buffalo (NY); In loco; USD 86.000 - 143.000; Tempo pieno

Descrizione del lavoro

M&T Bank Corporation is seeking a senior analytics professional to drive complex finance analytics initiatives in Buffalo, NY. You will lead the design, development, and deployment of Oracle FDI, UCL, and OAC reporting solutions, ensuring data quality and timely delivery to stakeholders.

You will collaborate with Finance, Data, and Technology teams, mentor junior staff, and guide projects from proposal through post-implementation to meet business goals.

Competenze

• Minimum of 6 years combined higher education and/or operational/business analytics experience.
• Strong verbal and written communication skills.
• Strong organizational skills and time management.
• Strong lateral thinking and problem-solving abilities.
• Proficiency with PCs and relevant software packages.
• Excellent problem-solving skills to assist in issue resolution.

Mansioni

• Develop, test, deploy, and maintain Oracle FDI, UCL, and OAC reporting solutions for Finance.
• Create and maintain OAC datasets, semantic models, analyses, dashboards, and reports.
• Build UCL data structures and extracts for Workiva, Axiom, and downstream consumers.
• Support GL-to-instrument processing with data validation, reconciliation, and issue resolution.
• Produce functional specifications, test plans, and documentation for projects.
• Lead meetings with business teams to clarify requirements and deliver solutions within scope.

Conoscenze

Verbal communication

Written communication

Organizational skills

Time management

Lateral thinking

Problem solving

PC proficiency

Formazione

Bachelor's degree

Strumenti

Oracle FDI

Oracle Analytics Cloud (OAC)

Workiva

Axiom

Oracle EPM

Profitability reporting

Descrizione del lavoro

Education and Experience Required

Minimum of 6 years combined higher education and/or operational/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 as well as pertinent software packages. Excellent problem solving skills to assist in issue resolution.

Education and Experience Strongly Preferred

Bachelor's degree Hands-on experience with Oracle FDI and/or 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 is preferred. Subject matter expert in business with knowledge or experience utilizing application/system being supported. Capable of working on multiple projects of a complex nature. Advanced understanding of applications supported with a sound knowledge of interfacing/integrated applications. Advanced knowledge and focus of the entire system to work on projects outside of normal BAU. Ability to effectively use project management, word processing and spreadsheet applications. Excellent understanding of the Bank’s application framework. Familiarity with application development software and hardware platforms. Ability to understand business(es) being supported and its terminology. Ability to effectively present to all levels of management Ability to multitask for various components of complex projects. Ability to coordinate between applications and business units. Ability to work in a team environment as well as autonomously. Ability to recognize project milestones and delivery dates. Ability to recommend and implement solutions. Proactive Detail-oriented. Strong understanding of Bank acquisition methodology or relevant conversion experience

Overview: Responsible for facilitating complex projects from proposal through post implementation. Participates in meetings with lines of business to identify their requirements in how an application looks and feels to the end user; provides feedback on them. Serves as project lead to ensure test plans and specifications are completed in a timely basis and project meets established milestones. Considered Subject Matter Expert in assigned systems within 18 months of being assigned.

Primary 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. Responsible for preparing well documented functional specifications for assigned projects, test plans, test cases and execution of test cases. Responsible for research analysis of complex data ensuring functional design of assigned projects is accurate. 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. Schedule and facilitate project team meetings, document and distribute meeting minutes as applicable. Meet with business client to discuss requested application changes related to an enterprise-wide or business initiative, compliance/regulatory requirement, required system change due to contractual agreement or system maintenance (business as usual [BAU]) ensuring a thorough understanding of specifications for assigned applications. Participate in design discussions and document/deliver required functional specifications. Participate in meetings with lines of business to identify their requirements in how an application looks and feels to the end user and provide feedback to clients regarding business requirements to ensure technology applications support internal/external customer needs and products/services as provided by lines of business. Review business requirements with technology team to ensure understanding of project requirements. Coordinate and provide estimates for large projects and complete estimates for assigned component on assigned projects, inclusive of timelines and project phases. 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. 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. 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, and manage and/or execute test cases 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/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 and resolved as required. Coordinate and manage post implementation by getting feedback, resolving any issues and completing a debrief including actual to plan for timeline and financials. 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.

M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $85,800.00 - $143,000.00 Annual (USD). The successful candidate’s particular combination of knowledge, skills, and experience will inform their specific compensation.

Location Buffalo, New York, United States of America

Great companies have an enduring sense of purpose. At M&T, our purpose is a simple one: make a difference in people’s lives and uplift the communities we serve. M&T Bank Corporation is a financial holding company headquartered in Buffalo, New York. M&T’s affiliates offer advice, guidance, expertise and solutions across the entire financial spectrum, combining M&T Bank’s traditional banking services with the wealth management and institutional capabilities offered by Wilmington Trust. M&T Bank has a network of over 1,000 branches and 2,200 ATMs that span 12 states from Maine to Virginia and Washington, D.C. For more than 165 years, M&T has strived to take an active role in our communities and build long-lasting relationships with our customers. We are a bank for communities- combining the capabilities of a large bank with the care of a locally focused institution. As an employer of choice, we are proud to offer competitive benefits ranging from medical and retirement to forty hours of paid volunteer time, each year. Our core values - integrity, ownership, collaboration, curiosity, and candor - drive the work we do. We seek to further build upon our record of success by bringing in top talent and fresh skill sets while continuing to support the growth and development of all our team members. View M&T’s Human Capital Report to learn more.

M&T Bank is unwavering when it comes to providing equal employment opportunities to all employees and applicants without regard to race, color, national origin, religion, ethnicity, sex, gender identity, age, disability, citizenship, pregnancy, veteran status, military status, marital status, sexual orientation, genetic information or any other characteristic protected under applicable federal, state or local laws.

M&T Bank Corporation has policies and procedures in place to promote a drug free workplace.

Career Site Privacy Notice