Join the diverse and dynamic team that powers Michigan's largest energy provider and one of the nation's largest gas and electric combination utilities. Consumers Energy services 6.7 million of Michigan's 10 million residents - caring for our friends and neighbors in all 68 Lower Peninsula counties. We embrace a cleaner and leaner utility vision focused on eliminating energy waste and adding renewable energy from sources such as wind and solar.
At Consumers Energy, we offer more than just a place to work. We foster a culture that supports career development, growth, and stability, and we take pride in offering our co-workers excellent benefits and compensation packages. We are deliberately creating an inclusive culture that makes our diverse team of co-workers feel valued, supported, and empowered every day. We're a company made up of thousands of people, all with different stories to share and work to do, but we stand united in our company purpose: world class performance delivering hometown service.
Department Summary
The Budget, Planning & Analysis team is looking for an analyst to support and strengthen the Long Term Financial Plan for Electric Operations and Engineering. The primary function will be to providing support to the Long Term Financial Plan which includes, supporting Program Managers annually with the financial plan submission into the Business Planning System, maintaining and reviewing 5+ years of planned investments and expenses, assist with preparing executive level reports, presentations, and summaries, and building exhibits and workpapers for regulatory filings.
In addition, the analyst role will be supporting and partnering with a number of programs and Program Managers for the current year financial forecasting process which includes maintaining forecast worksheets costing out the work, analyzing actual spend versus forecast variances, executing financial journal entries and postings to correct mischarging, and assisting Program Managers with unit cost reporting, problem solving, and financial deep dives.
The key responsibilities of this role:
Contribute to the development of the annual long term financial plan, including reviewing and balancing >2,000 projects and budgetary line items
Facilitate Training and Working Session to end users for the Business Planning System (BPS) used to maintain the long term financial plan
Prepare executive level reports, presentations, and summaries
Conduct financial and risk/opportunity analyses
Unit cost and metrics calculation and reporting
Rate case financial support, including exhibit and workpaper development and facilitating audit and discovery request questions
Required Qualifications
Bachelor's degree in finance, related area or equivalent experience
5+ years of related work experience in the finance field
Preferred Qualifications:
Utility Accounting experience
Previous budgeting/financial planning experience
Experience and/or knowledge of the electric distribution and generation business
SAP/BI experience
Advanced Excel, including pivot tables and complex formulas (e.g. vlookup)
SharePoint Online Power-User/Design
Experience with Tableau or PowerBI
Essential Functions
Conducts a variety of financial and risk analyses, financial studies, investigations, and operation studies; performs cost allocations; reviews and evaluates work products, methods, and procedures; conducts financial & statistical research; performs analysis of statistical data; recommends and implements modifications for improvement to programs, policies, and procedures as appropriate. Collects, compiles, and analyzes information from various sources on a variety of topics, including complex financial, analytical, budget or administrative issues; monitors and evaluates the efficiencies and effectiveness of basic financial operations. Participates in the development of the annual Long Term Financial Plan monitors revenues and expenses for assigned sections; directs the forecast of additional funds needed for staff, equipment, materials, and supplies; implements adjustments as necessary. Prepares executive level reports, presentations, summaries, and correspondence; creates comprehensive technical records and reports; Monitors and reports budget variances; provides ad-hoc reports; ensures a high level of accountability on all projects; evaluates budgetary changes; Develops long-range financial planning and revenue requirements; forecasts the impacts of potential future events; provides responsible, accurate, and thorough technical and administrative project support to Finance Management; operates variety of office equipment. Observes safe work practices and safety methods; performs other duties as assigned.
All qualified applicants will not be discriminated against and will receive consideration for employment without regard to protected veteran status, disability, race, color, religion, sex, sexual orientation, gender identity or national origin.