ICF • Columbia, MD 21045
Job #2684362580
Description
Data Analyst, Program Operations
Utility Program Services
Program Delivery
Location: Eastern Region Required (D.C., Maryland, Virginia Preferred) (Remote - Home Office with occasional travel)
Are you ready to make a difference?
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.
Candidate 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.
What you will be doing:
Data Coordination and Analysis - 85%
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
Business Analysis - 15%
Maintain business workflow documents
Work with IT and reporting teams to improve database systems and architecture
If Local, 1-2 times a month travel to our local Columbia MD office location. If not local, potential for quarterly travel to Columbia, MD or Reston, VA office location.
What we need you to have (minimum qualifications):
Bachelor's Degree in (Business, Information Technology, Mathematics, Statistics, Economics, or related subject preferred) and
2+ years of relevant experience
2+ years of advanced experience in MS Excel skills
2+ years of advanced data visualization skills including experience with PowerBI or Tableau
Preferred Skills/Experience:
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
Strong project management skills
Excellent verbal, interpersonal, and written communication skills
Timeliness and strong work ethic
Outstanding analytical skills and attention to detail
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. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO & AA policy (~~~) .
Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation please email ~~~ and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.
Read more about workplace discrimination rights (~~~) , the Pay Transparency Statement (~~~) , or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act. (~~~)
Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position. The pay range for this position is:
$59,469.00 - $101,098.00
Columbia, MD (MD12)
ICF • Reston, VA 22096 • Yesterday
ICF • Reston, VA 22096 • 3 Days Ago
ICF • Reston, VA 22096 • 3 Days Ago
ICF • Washington, DC 20080 • Yesterday
Computer Packages Inc. • Rockville, MD 20850 • 6 Days Ago
EarthScope Consortium • Washington, DC 20005 • Yesterday
Accenture • Washington, DC 20080 • Feb 23
Actalent • Hunt Valley, MD 21065 • 6 Days Ago