Job Title: Financial Systems Analyst
Reports to: Financial Systems Leader
Location: Ventura, CA
As the Financial Systems Analyst, you will provide systems maintenance, planning, reporting, and analytical support, for Corporate Finance. You will also update, create and enhance analysis and data reporting, and maintain budgeting/forecasting systems, in support of the Finance team and a variety of cross-functional areas. Your contributions in this role will ultimately be in support of our mission to save our home planet.
What You’ll Do
Forecasting / Budgeting Analysis Support
Provide support, analysis, financial modeling in support of the budgeting process by preparing and summarizing revenue and expense reporting, variances and trends
Assist in preparing consolidated fiscal forecasts, comparative analyses, sensitivity and scenario analyses, etc.
Provide support, analysis and financial modeling for ad-hoc reporting and special requests from Finance Managers.
Financial System Maintenance
Manage ETL processes for loading annual budgets from IBM Cognos TM1 system (TM1) 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 automated templates for international entities to load forecast and budget data into TM1.
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.
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.
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.
Who You Are
Deeply committed to our mission of saving our home planet.
Attention to detail and strong organizational skills a must, as is the ability to juggle many tasks at one time and change gears quickly.
Ability to communicate effectively, verbally and written, with a wide variety of people.
Ability to work well under pressure and deadlines.
Ability to support diverse objectives within a multi-channel business, maximizing synergies.
Demonstrates initiative, is conscientious and provides complete follow-through on areas of responsibility.
Comfortable with team-based work structure; ability to remain flexible to change within the work environment and scope of responsibility.
Ability to work in an open-concept office/floor plan.
Experience You Bring
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 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 experience for Excel automation.
Proficiency in a variety of ERP, Financial Reporting, Product Planning and Business Information systems desired (ERP - MS Dynamics AX/365; Financial Reporting & Budgeting – Cognos TM1; Business Information –Tableau and Power BI; Product Line Management - Flex PLM/Windchill; Fixed Assets – Bloomberg BNA; Expense Reporting - Concur).
Must be able to sit for extended periods of time.
Must be able to stand for extended periods of time.
Ability to look at a computer screen for extended periods of time.
Ability to maintain a composed and professional demeanor within a flexible and (at times noisy) work environment.
Must be able to travel internationally and domestically utilizing various transportation methods.
It is the responsibility of every employee to contribute to a positive work environment through cooperative and professional interactions with co-workers, customers and vendors.
Equal Employment Opportunity
All qualified applicants will receive consideration for employment without discrimination on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, or any other factors prohibited by law.