Financial Systems Analyst

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.

Core Responsibilities

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 OneStream. 
  • Imports general ledger and planning data into OneStream.

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 OneStream, 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 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.

   

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.

Additional Responsibilities

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

Required Skills & Personal Qualifications

• 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 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
• 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.
• 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

Compensation: The recruiting base salary range for this full-time position is $70000 - $97000 / year. Within the range, individual pay is determined by factors, including job-related skills, experience, and relevant education or training. Additionally, this role is bonus-eligible, with a target bonus percentage that provides an opportunity to earn even more based on your performance. (Internal Job Grade: P2) 

Why Join Us? In addition to competitive salary and an incomparable culture, Subaru offers an amazing benefits package that includes:

   Total Rewards & Benefits:

          -  Medical, Dental, Vision Plans

          -  Pension, Profit Sharing, and 401K Match Offerings

          -  15 Vacation days, 5 Floating Holidays, 5 Sick days, and 9 Company Holidays

          -  Tuition Reimbursement Program: $15,000 yearly benefit

          -  Vehicle Discount Programs

   Learning & Development:

          -  Professional growth and development opportunities

          -  Direct partnership with senior leadership

          -  Formal Mentorship Program

          -  LinkedIn Learning License 

   Visit our careers landing page for additional information about our compensation and benefit programs.

About Subaru

Love. It’s what makes Subaru, Subaru®. As a leading auto brand in the US, we strive to be More Than a Car Company®. Subaru believes in being a positive force in the communities in which we live and work, not just with donations but with actions that set an example for others to follow. That’s what we call our Subaru Love Promise®.

Subaru is a globally renowned automobile manufacturer known for its commitment to innovation, safety, and sustainability. With a rich history dating back to 1953, Subaru has consistently pushed the boundaries of automotive engineering to deliver vehicles that offer not only exceptional performance but also a unique blend of utility and adventure.

Subaru's company culture is built on collaboration, diversity, and a shared passion for our product. We foster an inclusive environment that encourages employees to bring their unique perspectives and talents to the table. Our team members are driven by a common goal: to create exceptional vehicles that inspire and delight our customers.