Financial Systems Analyst

Overview

Role Summary

Works with Finance, Information Technology (IT), and other cross-functional teams to help drive continuous improvement and automation for the Accounting and Finance processes. Leverages knowledge of best practices in financial systems, project management, and process enhancement to facilitate the support of the Oracle E-Business Suite (EBS) Enterprise Resource Planning (ERP) system and Enterprise Performance Management- (EPM)-related systems. Supports monthly closings, reporting, analytics, and financial planning projects.

Helps document functional requirements, define and execute test scenarios, and develop/conduct end-user training. Role may spend more time on project planning and tracking or on journal entry oversight, depending on management assignment and workload.

Systems Administration and Maintenance:

• Executes monthly close tasks for the Accounting and Finance teams, including facilitating the Journal Mass Allocation process and providing assistance with journal upload templates.
• Maintains the General Ledger system, overseeing crucial components such as the chart of accounts, periods, budgets, and security rules, while ensuring synchronization of metadata with One Stream.
  • Imports general ledger and planning data into One Stream.

Financial Reporting and Analytics:

• Supports the deployment and ongoing support of Power BI for Finance, which includes building data models, developing interactive reports, integrating with systems like Oracle E-Business Suite (EBS) and One Stream, training users, and transitioning from legacy reporting tools.

Process Improvement and

Cross-Functional Collaboration:

• Supports business teams and senior Financial Information Systems (FIS) staff by assisting in the implementation of automated solutions using tools like Power Automate, Excel, and SharePoint. Collaborates across functions to streamline workflows, document processes, and contribute to continuous improvement initiatives.
• Serves as a liaison between the Finance and Information Technology (IT) departments, facilitating clear communication and collaboration to support financial system enhancements.
• Works alongside IT and Finance teams to document current and future state processes, help implement and prioritize projects based on resource availability and budget constraints, and troubleshoot technical issues on behalf of Finance users.

Training, Documentation, and User Enablement:

• Supports training and user enablement efforts by assisting senior staff in developing and delivering training materials (such as screen capturing relevant processes) for Finance group's use of financial systems (including One Stream and Oracle) as well as responding to user inquiries.

• Develops and maintains detailed documentation of updated processes and procedures in order to promote adoption of financial systems and tools (e.g., Power BI, Sharepoint, Excel), ensure transparency and consistency, and reinforce best practices across the Finance department.

Compliance and Controls:

• Maintains and executes monthly and quarterly controls mandated by the Sarbanes-Oxley Act (SOX) to ensure adherence to regulatory standards.
• Conducts reconciliations between systems to guarantee completeness and accuracy of financial data, facilitating the monthly reconciliation process.

• Ensures compliance with regulatory requirements and internal controls, including SOX regulations, and supports internal and external audits by providing documentation and information as needed.

Project Planning and Tracking:

• Develops and maintains detailed project plans, timelines, and task lists. Ensures that tasks are completed timely across functional and technical teams. Monitors progress and updates stakeholders regularly.
• Works with external implementation partners on project scope, timelines, etc.
• Prepares test scripts and tracks issues related to user acceptance testing (UAT) efforts.

Journal Entry Management:

• Maintains, compiles, and distributes for management review supporting documents for the manual monthly journal entry process, ensuring continuity and accuracy in financial recordkeeping.
• Facilitates the journal entry approval process by extracting relevant information from financial system, ensuring compliance with established protocols including SOX.

• Identifies areas for improvement in order to effectively streamline processes and create efficiencies.
• Completes ad-hoc responsibilities including report requests and project work.

• Bachelor's Degree in accounting, finance, or management information systems required
• At least 4-6 years required of relevant experience required
• Excellent verbal and written communication skills to effectively communicate with stakeholders at all levels, including information technology (IT) professionals, finance teams, and senior management.
• Experience in facilitating and maintaining data integrations across financial systems Preferred
• Experience with data mining and…