Business Systems Analyst V - Oracle Enterprise OAC Platform Support
Core
Develop, test, deploy, and maintain Oracle FDI, UCL, and OAC reporting solutions supporting Finance reporting and data consumption.
Role type
Senior Business Systems Analyst (Oracle Analytics)
Builds
OAC datasets, semantic models, analyses, dashboards, and reporting content for Finance consumers
Domain
Financial Services / Oracle Analytics
Required skills
Oracle FDI, Oracle Analytics Cloud (OAC), SQL, data validation, reconciliation, functional specification writing, test planning, project coordination, data mapping, incident management
Preferred skills
Workiva, Axiom, Oracle EPM, Profitability, General Ledger data processes, release management, semantic modeling
Technologies
Oracle FDI, Oracle Analytics Cloud (OAC), Workiva, Axiom, Oracle EPM, Profitability, SQL
Responsibilities
Develop and maintain OAC datasets, semantic models, analyses, dashboards, and reporting content; Build and maintain UCL data structures and extracts supporting downstream Finance consumers; Execute adjustment-related data changes, testing, validation, and production implementation; Perform data analysis using SQL and 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; Serve as functional lead on complex projects for assigned applications; Meet with business clients to discuss requested application changes and ensure thorough understanding of specifications; Coordinate and provide estimates for large projects; Serve as subject matter expert to consult and advise on application impacts from enterprise-wide initiatives; Work with vendor and technical teams to gain understanding of project functionality; Participate in and document data mapping for integration of systems, conversion, and acquisition-related projects; Monitor functional specifications and change requests to ensure project stays within scope and meets regulatory requirements; Ensure change requests are consistently documented, reviewed and resolved; Coordinate and manage post implementation by getting feedback, resolving issues, and completing a debrief; Understand and adhere to the Company's risk and regulatory standards, policies and controls; Maintain M&T internal control standards, including timely implementation of internal and external audit points
