Data Analyst, Program Operations
Utility Program Services - Program Delivery
Location: Atlanta, GA | Hybrid
Job Description: To support our growth, we are currently seeking a Data Analyst for our Utility Programs and Services division to manage database and reporting work in Georgia. The Data Analyst will be part of the Georgia Operations team, a cross-functional team of program management, outreach, technical and marketing personnel as well as actively lead project delivery, strategy, and market development efforts.
Candidate will assist in the implementation of utility energy efficiency programs that incorporate installation of energy efficiency equipment in commercial buildings. The Data Analyst will serve as the data scientist for Georgia and provide expertise as needed across the contracted program portfolios. Additionally, the Data Analyst will develop program performance forecasts, both short and long term.
What you will be doing:
- Lead coordination with implementation team on procuring data that will be used in forecasts
- Manage the daily maintenance of databases, utilized by the program implementation team, to ensure data integrity
- Prepare reports to accurately describe activities in the field and to monitor progress towards program goals on customer participation and the completion of eligible projects
- Utilize historic data and simulations to project annual program participation
- Ensure that the programs are performing as expected, and explain forecasted variances to leadership
- Collaborate with program managers to ensure all activities related to quality program delivery are executed
- Maintain and update shared files, resources and program documents to ensure all program staff have access to the latest versions of materials.
- Perform reconciliation task between qualified leads stored in program CRM solution and Project Database
- Identify opportunities to optimize forecasting models, program database and budget accruals
- Maintain business workflow documents
- Work with IT and reporting teams to improve database systems and architecture
What we need you to have (minimum qualifications):
- Bachelor’s Degree in Business, Information Technology, Mathematics, Statistics, Economics, or related subject
- 2+ years of relevant experience in a similar role
- 1+ years of experience in advanced data visualization skills
- 1+ years of demonstrated experience in Excel specifically with Pivot Tables, Formulas, Functions and IF statements
What we would like you to have:
- SQL and database experience
- Excellent verbal, interpersonal, and written communication skills
- Timeliness and strong work ethic
- Experience with statistics and related software (R, SPSS, STATA, EViews, Python, SAS)
- Sound business ethics, including the protection of proprietary and confidential information
- Ability to work with all levels of internal staff, as well as outside clients
- Superior interpersonal skills including courtesy, professionalism, and a cooperative attitude
- Outstanding analytical skills and attention to detail
- Advanced MS Excel experience and skills
Working at ICF
ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future.
We can only solve the world's toughest challenges by building an inclusive workplace that allows everyone to thrive. We are an equal opportunity employer, committed to hiring regardless of any protected characteristic, such as race, ethnicity, national origin, color, sex, gender identity/expression, sexual orientation, religion, age, disability status, or military/veteran status.
Pay Range
The pay range for this position is: $58,161.00 - $98,873.00 Atlanta, GA (GA18)
#J-18808-Ljbffr