Sr Financial Systems Analyst

The Sr Financial Systems Analyst role manages and supports the operation, maintenance, and processes of the organization's financial systems and reporting. The role is responsible for system and reporting updates during month-end close. The role will also manage process improvement, implementations, upgrades, design, testing, and configuration of supported systems and reporting tools. The role serves as a subject matter expert regarding system processes, data, dimensionality, and reporting.

Essential Functions :

• Manage, maintain, and support the Company’s Oracle EPM application & Oracle OIC SQL Database for actual reporting, budgeting, and forecasting (configuration, assumptions, business rules, data load rules, dimensions, security, translation, forms, reports, and data transfer and validation between cubes)
• Manage, administer, and maintain processes that feed information into the Oracle SQL database and EPM – includes running and monitoring of OIC integrations, Fusion reporting, and manual data compilation
• Responsible for the accuracy, integrity, and timeliness of financial data maintained in the EPM and OIC SQL database
• Troubleshoot and resolve issues related to the system, data, reporting, or user issues.
• Update, maintain, and create various financial reports / dashboards using tools such as EPM, Excel, Power BI, Access databases.
• This role demands a comprehensive understanding of end-to-end processes including relationships, dependencies, touchpoints, etc.
• Manage and maintain a SharePoint site (home page, security, links, etc.) that stores financial reporting, cross reference information, and training documentation.
• Assist in identification, design, and implementation of Finance / Accounting process improvement
• Provide expert-level support for our financial systems; includes assistance with report writing.
• Provides guidance and training to Finance users on report writing using tools such as SmartView, EPM forms / reports, Power BI, and Excel (including VBA automation)
• Develop advanced reports,
• Ensure integration points and data flows between systems are efficient and optimal
• Ensure standards for data quality and integrity between systems are developed in accordance with best practices
• The manager will collaborate closely with IT staff and external consultants to maintain the system’s software, hardware, operating system, and communications. As a subject matter expert, the manager will provide expertise on system processes, data management, dimensionality, and reporting, while fostering strong work relationships and ensuring seamless IT process flow.
• Diagnose and resolve problems with the applications, reports, and interfaces.
• Manage, maintain, and create process & procedure documentation, functional requirements
• Other duties as assigned

Education : Bachelor Degree

Work Experience Required :

Knowledge, Skills, and Abilities :

Physical Requirements :