Financial Systems Analyst

Subaru•Camden, NJ

22d•$70,000 - $97,000

About The Position

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.

Requirements

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.
Understanding of financial processes.
Ability to perform functions independently with minimal supervision, operate flexibly according to evolving priorities, and achieve stated goals within agreed-upon timelines.

Nice To Haves

Experience in facilitating and maintaining data integrations across financial systems Preferred
Experience with data mining and data analytics tools (e.g., SQL, Qlik, Power BI, etc.).
Proficiency in Microsoft Excel including data modeling, advanced functions, and macros.
Proficiency in VBA scripting and/or C# Preferred
Experience with Enterprise Performance Management (EPM)/Corporate Performance Management (CPM) tools such as OneStream, Hyperion, etc. Preferred
Experience with Enterprise Resource Planning (ERP) systems such as Oracle E-Business Suite (EBS) or other financial systems preferred

Responsibilities

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 OneStream.
Imports general ledger and planning data into OneStream.
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 OneStream, training users, and transitioning from legacy reporting tools.
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.
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 OneStream 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.
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.
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.
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.