BA/BS/BBA in Finance, Accounting, Business Management, Engineering, Business Analytics, Information Systems, Data Analytics, or related field
Advanced proficiency in Microsoft Excel
Proficiency in Power BI, including dashboard development and data modeling
Advanced background in financial reporting, modeling, analysis, and forecasting
Knowledge of accounting fundamentals and audit concepts
Strong verbal and written communication skills
Effective planning and organizational skills
Responsibilities
Develop capital budgets for New Business projects
Compile and interpret financial and non-financial data
Conduct detailed variance analysis of financial results
Perform cost analysis and propose cost reduction recommendations
Generate and present monthly capital reports for executive reviews
Design and maintain Power BI reports and dashboards
Partner with cross-functional teams to gather information and improve processes
Benefits
Opportunity to support executive-level decision-making
Engagement with cross-functional teams to enhance collaboration
Access to advanced analytical tools and technologies
Focus on data-driven decision making and reporting
Potential career growth in a dynamic construction finance environment
Full Job Description
About this opportunity
Location: Naperville, IL
The Business Support Analyst is responsible for financial, operational, and process analysis, as well as financial modeling, planning, and reporting to support construction activities for Southern Company Gas and its subsidiaries. This position develops and tracks capital budgets for the Engineering and Construction organization, publishes cost, production, and budget metrics for CEO and executive level reviews, and provides support for construction related activities (data analysis, system support, etc.). This position will play a key role in advancing data-driven decision-making through analytics, automation, and scalable reporting solutions.
This is a highly analytical position, which involves the compilation, analysis, interpretation, and presentation of complex financial information. It requires attention to detail, a high level of accuracy, and cross-functional coordination.
Functional Expertise:
Develop capital budgets and forecasts for the New Business project portfolio utilizing financial and operational models.
Compile and interpret financial and non-financial information to determine past performance, project future results, and identify trends to help drive business decisions.
Conduct detailed variance analysis of financial results. Research and summarize financial transactions and events for monthly, quarterly, and annual reporting. Prepare written and verbal explanations.
Perform extensive cost analysis and identify cost reduction opportunities. Propose recommendations to leadership.
Define and implement new metrics and develop insightful reports to proactively track performance and results. Monitor cost drivers and identify areas of greatest impact.
Generate and present monthly capital reports and insights for CEO and executive-level reviews.
Translate complex analytical findings into clear, concise insights to support executive and leadership decision-making.
Design, develop, and maintain Power BI user experiences, reports, and dashboards that deliver clear, actionable insights for operational and executive audiences.
Leverage SQL, Python, or other advanced analytical tools to navigate and analyze large datasets across multiple platforms, enabling data-driven insights and solutions to complex business and operational problems.
Support Construction Operations staffing initiatives with modeling, analysis, and presentations.
Assist with departmental O&M budgets and forecasts.
Create visual presentations (tables, charts, graphs, etc.) of financial data and production metrics to summarize report information.
Partner with cross-functional teams to gather information, improve processes, and resolve complex business and data issues.
Complete ad hoc analysis to support business needs and initiatives.
Contribute to the evolution of analytics, reporting standards, and data processes to support scalability and long-term business needs.
Who we're looking for:
Experience, Knowledge and Key Skills
Advanced proficiency in Microsoft Excel
Proficiency in Power BI, including dashboard development, data modeling, and user-centered report design.
Advanced background in financial reporting, modeling, analysis, and forecasting
Knowledge of accounting fundamentals, audit concepts, practices, and procedures
Effective planning and organizational skills
Strong verbal and written communication skills; ability to communicate with all levels in the organization
Ability to complete assignments with a high level of accuracy and attention to detail
Ability to support multiple resources and adapt to changing priorities
Qualifications
BA/BS/BBA in Finance, Accounting, Business Management, Engineering, Business Analytics, Information Systems, Data Analytics, or related field
