FP&A Analyst / Sr. Analyst
Eligo Energy, LLC
Chicago, illinois
Job Details
Full-time
Full Job Description
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