Job Information
Eligo Energy, LLC FP&A Analyst / Sr. Analyst in Chicago, Illinois
Position Duties:
Establish and improve financial planning process using advanced analytics and data-driven methodologies
Generate 3-statement financial forecasts, leveraging programming and data analysis techniques for increased accuracy and automation
With each period’s close, analyze variances and use advanced analytical tools to forecast and make actionable recommendations to all levels of the business
Act as controller for the natural gas business unit and various marketing partnerships, creating separate monthly P&Ls for each
Develop and implement automated processes for selecting and reporting on relevant KPIs that drive financial performance
For ad hoc analyses, collect and process data from multiple sources (operational databases, accounting statements, colleagues/business partners) into logically flowing models
Collaborate with the financial accounting team on regular tasks (e.g., monthly close support) and ad hoc requests, utilizing technical skills to optimize processes
Successful Candidate Traits:
Comfortable creating robust financial models at varying levels of detail for the overall company, business units, and potential projects, using programming and data analysis techniques
Embraces data-driven decision-making and challenges legacy analyses or business assumptions
Proactively interacts with all levels of the business, both requesting information and assistance and providing such in a timely and enthusiastic manner
Looks beyond assigned duties or formal reporting structure; maintains a flexible and collaborative approach to working with other teams and departments; aims to be seen as a value-add expert on cross-functional projects
Requirements
Required Skills:
Expertise in Excel or equivalent (e.g., Google Sheets), focusing on clear and logical structuring of financial models
Intermediate understanding of financial accounting
Knowledge of relational databases and the ability to extract data using SQL SELECT queries, including joining multiple tables
Ability to automate data manipulation and analysis via proficiency in Python or other programming languages
Experience:
Minimum 2 years in a corporate FP&A organization, including:
Operating budgeting, forecasting, and variance analysis
Capital budgeting and project evaluation
General financial modeling of business issues
Benefits
Health Care Plan (Medical, Dental & Vision)
Retirement Plan (401k, IRA)
Life Insurance (Basic, Voluntary & AD&D)
Paid Time Off (Vacation, Sick & Public Holidays)
Work From Home