SR FINANCIAL SYSTEM ANALYST – Oracle EPM

Denso•Southfield, MI

About The Position

Job Summary: As a Sr. Financial Analyst for Corporate Planning you will be responsible for working as part of a team that provides direct support to the North America CEO. As a systems analyst you will perform system admin responsibilities for Oracle EPM, provide systems support to North America Power Users, and provide North America EPM Financial Reports for Corporate, US, Canada and Mexico Plants. Responsibilities: Providing functional / technical expertise to support corporate and consolidation process Support monthly financial close, upload and maintain actual, budget and forecast data through Data Management, and maintain mapping tables, and import formats Interpret code, calculation and aggregation script logic Troubleshoot financial statement disconnects of calculations or source systems. Identify root cause and short and long term countermeasures Interact with business stakeholders, end user, peers, and management personnel to resolve system issues Strengthen the processes and systems for collecting, analyzing and presenting management and business information, standardizing and documenting the control framework for financial systems and reporting tools Understand and interpret business requirements and effectively communicate them to IT and Finance Manager - EPM Systems Provide system training to end users and upskill current Business Planning members Partner with IT and Finance Manager – EPM Systems to assist in the development and deployment of Oracle EPM Enhancements through all phases of Software Development Life Cycle (SDLC) including the design, development, test, implementation, and maintenance of financial applications Communicate highly technical information to functional and technical team members and ability to simplify for operational management

Requirements

Bachelor's degree with a major in Accounting, or Business Administration
5 or more years work experience in Accounting or Financial Planning and Analysis
Experience with Oracle's EPM Planning (Hyperion Planning, PBCS, or EPBCS, also acceptable)
Knowledge of Financial Close and Consolidation (FCC) or Hyperion Financial Management (HFM) and Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) or Data Management
Basic knowledge of GAAP with ability to understand linkages between accounts to develop a Balance Sheet, Income Statement, and Cash Flow Statement
Experience in budgeting, forecasting and variance analysis. Able to draw accurate conclusions from financial and quantitative information.
Proficient in Excel, Essbase and SmartView.
Knowledge of Oracle ERP.
Knowledge of Oracle Fusion Data Intelligence (FDI) or FAW (Fusion Data Warehouse)
Ability to pick up new technical knowledge quickly.
Able to work comfortably in a hands-on fast pace department
Experienced in working with cross-functional teams like Accounting, IT and Plant Finance
High level of independent capability and initiative to operate in a flexible work/remote environment
Demonstrate strong analytical skills, problem solving/debugging skills.

Nice To Haves

Previous Hyperion Admin Role
Experience in SDLC deliverables with automotive industry
Experience in BI Tools such as EPM Dashboards and Domo

Responsibilities

Providing functional / technical expertise to support corporate and consolidation process
Support monthly financial close, upload and maintain actual, budget and forecast data through Data Management, and maintain mapping tables, and import formats
Interpret code, calculation and aggregation script logic
Troubleshoot financial statement disconnects of calculations or source systems. Identify root cause and short and long term countermeasures
Interact with business stakeholders, end user, peers, and management personnel to resolve system issues
Strengthen the processes and systems for collecting, analyzing and presenting management and business information, standardizing and documenting the control framework for financial systems and reporting tools
Understand and interpret business requirements and effectively communicate them to IT and Finance Manager - EPM Systems
Provide system training to end users and upskill current Business Planning members
Partner with IT and Finance Manager – EPM Systems to assist in the development and deployment of Oracle EPM Enhancements through all phases of Software Development Life Cycle (SDLC) including the design, development, test, implementation, and maintenance of financial applications
Communicate highly technical information to functional and technical team members and ability to simplify for operational management

Benefits

Medical, Dental, Vision, Prescription Drug plans
401K with 4% Company Match
Vacation/PTO and 13 paid Holidays
Bonus Program
FSA/HSA and Dependent Care Programs
Company provided Life, Disability, ADD and Business Travel Insurance
Various No Cost Wellness & Chronic Condition Management Programs
Various Optional Insurance programs such as legal, identity theft, critical illness, etc.
Tuition Reimbursement
Career Development and Ongoing Training
Employee Assistance Program
Employee Spotlight and Recognition Program
Volunteer Opportunities
Onsite Fitness Center (vary by location)
Cafeteria and food markets (vary by location)
Onsite Health Clinic and Pharmacy (vary by location)