Financial Planning & Modeling Analyst Sr (Hybrid)

Lower Colorado River Authority • Austin, TX

7h • Hybrid

About The Position

Do you have passion for financial planning, modeling, and forecasting? Do you
enjoy working with business owners across an organization, performing scenario
analysis to drive business decisions, and understanding the inner workings of
financial planning applications? If so, then we have a job for you! Our
Financial Planning and Modeling group is responsible for developing the budget
plan and forecasting for the organization. We work with all areas of the
organization to help provide valuable financial analysis and data to make
crucial business decisions that impact the communities that LCRA serves. We are
looking for an independent problem solver with strong financial, systems and
accounting aptitude to take over the cash forecasting model.

Requirements

• Nine or more years of experience in financial planning, finance, accounting, operational or financial analysis, rates analysis or other relevant experience, including acting as functional system support and serving as a finance/accounting liaison to business partners and IT. A degree(s) in finance, business, accounting, economics, information systems or relevant field may be substituted per LCRA guidelines for certain years of experience.

Nice To Haves

• Knowledge of financial and accounting concepts and practices at an advanced level, including skill in developing complex cash forecasting models, as well as proficiency with financial statement analysis and projection
• Extensive experience with Anaplan (highly preferred) or similar CPM budgeting and planning systems (Hyperion, OneStream, etc.)
• Experience performing sophisticated analysis in Excel and financial applications to support strategic business decisions
• Experience with cost allocation methodologies, capital budgeting, and debt structuring
• Experience working with databases, SQL scripting and developing reports in an accounting or financial application, as well as skill in working with large data sets from multiple systems in both Excel and CPM applications
• Familiarity with the electric utility industry and rate making methodologies
• Experience with GAAP accounting and financial reporting practices and tools
• Strong, effective communication skills, particularly between finance, business groups, and IT support
• Ability to work as part of a team with multiple competing priorities under tight deadlines

Responsibilities

• Own all aspects of Anaplan Cash Model
• Provide monthly cash variance analysis
• Model future reserve activity, reserve balances and provide forecast to actual analysis
• Model balance sheets for each of LCRA’s product lines within Anaplan
• Maintain and update mapping logic for actual data within Anaplan
• Perform complex financial planning, modeling, and forecasting functions, including market and rate analysis to solve problems, develop strategies, and predict future outcomes
• Design, develop and document new modules within Anaplan to meet evolving business requirements
• Produce managerial reporting documents and presentations

Benefits

• Competitive salary & medical, dental, vision and legal insurance
• Paid time off, including time for vacation, sick and family care leave
• 401(k) match up to 8% that includes a student loan 401(k) contribution program option
• Life and disability insurance
• Wellness program including wellness incentive
• Extensive learning & development programs

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed