Financial Systems Engineer

Role:  Financial Systems Engineer

Level: Individual Contributor, P3

Department: Financial Planning & Analysis

Location: Ventura, CA

Years of Experience: 5+

General Summary:

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.

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

Financial System Maintenance/Development

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

General Responsibilities:

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

Hiring range: $120,000 – $135,000 USD Annual

At Patagonia, pay ranges are assigned to a job based on the location specific market median of similar jobs according to 3rd party salary benchmark surveys. Individual pay within that range can vary for several reasons including skills/capabilities, experience, and available budget. Note the full pay range for this role ranges from: $91,800.00 - $137,800.00 USD Annual. The Hiring Range reflects where in the range we intend to hire for this role.

Benefits

Patagonia offers a comprehensive benefits package, including medical, dental, vision, retirement and leave of absence plans. Benefit plans may vary slightly depending on the nature of your employment. 

Employee Conduct
It is the responsibility of every employee to contribute to a positive, inclusive 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.