ICF is a global consulting and technology services company with approximately 9,000 employees, but we are not your typical consultants. At ICF, business analysts and policy specialists work together with digital strategists, data scientists and creatives. We combine unmatched industry expertise with cutting-edge engagement capabilities to help organizations solve their most complex challenges. Since 1969, public and private sector clients have worked with ICF to navigate change and shape the future.

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 the Mid-Atlantic. The Data Analyst will be part of the Mid-Atlantic Operations team, a cross-functional team of program management, outreach, technical and marketing personnel.

The Data Analyst will assist in the implementation of utility energy efficiency programs in both the Residential and Commercial & Industrial sectors. The Data Analyst will serve as the data scientist for multiple utility clients in the Mid-Atlantic and provide expertise as needed across the contracted program portfolios. Additionally, the Data Analyst will develop program performance forecasts, both short and long term.

Why You Will Love Working Here

• Quality of life: Flexible workplace arrangements, work-life balance
• Investment of community: Donation matching, volunteer opportunities
• Investment in you: Tuition reimbursement, 401k matching, Employee Stock Purchase Plan and access to professional development resources
• And many, many more (Ask your recruiter for more details!)

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
• Closely track multiple program budgets and program spend rates
• 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
• Track KPI reports and accurately report progress toward KPI goals on a monthly basis

What We Need You To Have (minimum Qualifications)

• Bachelor’s Degree (Business, Information Technology, Mathematics, Statistics, Economics, or related subject)
• 2+ years of relevant experience
• Data visualization skills including experience with Power BI or Tableau

What We Would Like You To Have

• SQL and database experience
• 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
• Advanced MS Excel experience and skills
• Outstanding analytical skills and attention to detail
• Excellent verbal, interpersonal, and written communication skills
• Strong project management skills