Financial Systems Engineer

Patagonia • Ventura, CA

282d • $120,000 - $135,000

About The Position

As the Financial Systems Engineer, you will provide systems maintenance, development, planning, reporting, and analytical support. You will update, create and enhance analysis and data reporting, and maintains budgeting/forecasting systems, in support of the Finance team and a variety of cross-functional areas.

Requirements

• Bachelor's Degree in Finance, Accounting and/or Information Systems.
• 2-5+ year of progressive relevant experience in Financial Planning & Analysis, Operational Finance or Systems Analysis.
• Strong understanding of multi-dimensional and relational databases, data structure and data elements, with an ability to extract and manipulate large and complex data sets.
• Advanced experience in all Microsoft Office programs - especially Excel and PowerPoint.
• VBA and Power Query experience for Excel automation.
• Proficiency in a variety of ERP, Financial Reporting, and Business Information systems desired (ERP - MS Dynamics AX/365; Financial Reporting & Budgeting - IBM Planning Analytics (TM1); Business Information -Tableau and Power BI; Programming Language - TM1py; Expense Reporting - Concur).

Responsibilities

• Provide support, analysis, financial modeling in support of the budgeting process by preparing and summarizing revenue and expense reporting, variances and trends.
• Provide support, analysis and financial modeling for ad-hoc reporting and special requests from Finance Managers.
• Perform yearly roll forward procedures for TM1 including clearing and prepping budget versions, copying budgets to rolling forecast versions, updating attributes for dynamic time series, opening/closing budget inputs, etc.
• Manage ETL processes for loading annual budgets from IBM Planning Analytics (TM1) system to Microsoft Dynamics, as well as loading Actual data from Dynamics to TM1 and perform validations.
• Identify opportunities for improvement of data capture and flow between source systems and financial systems.
• Provide regular backups of TM1 data and reverse migrate to development environment; monitor server capacity and recommend archival or server migration before reaching capacity limits.
• Establish and manage TM1 security and user rights for new users or changes in responsibilities.
• Track license requirements and prevent compliance issues.
• Maintain dimension hierarchies and attributes in TM1 for Departments, Accounts, Measures, etc.
• Update and support budget and labor-related models by creating/modifying TM1 cubes, dimensions, rules, Turbo Integrator (TI) processes, loading and validating data and calculations.
• Troubleshoot TM1 issues and create help tickets with IBM if necessary to resolve.
• Train and support the needs of the overall financial user community.
• Responsible for TM1 maintenance and administration, including maintenance of process documentation.
• Proactively partner with internal and external IT support teams to ensure that the performance of financial systems is maximized and working properly and effectively.
• Exhibit flexibility and willingness to take on new responsibilities and assist with various ad-hoc projects as required.

Benefits

• Comprehensive benefits package, including medical, dental, vision, retirement and leave of absence plans.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Industry: Merchant Wholesalers, Nondurable Goods
• Education Level: Bachelor's degree