Junior Data Analyst – Income Qualified Residential Programs
Location:Toronto or Ottawa preferred, elsewhere inOntario considered.
Ready to make a difference?
ICF is seeking a Junior Data Analyst to help manage energy efficiency programs. This role is responsible for reviewing, analyzing, and reporting on program data to support informed decision‑making by program leadership and delivery teams.
Reporting to a Project Coordinator, the Junior Data Analyst provides regular and ad‑hoc reporting, supports data quality efforts, and contributes analytical insights that help monitor program performance, identify trends, and improve delivery outcomes. This is a junior‑level position well suited to candidates early in their analytics career who are detail‑oriented, comfortable working with data, and interested in supporting large‑scale, mission‑driven programs.
Whyyou will loveworking here:
Quality of life:Flexible work arrangements and a strong emphasis onwork‑lifebalance
Investment in the community:Paid volunteer time anddonation‑matchingopportunities
Investment in you:Professional development support, tuition reimbursement, and access to learning resources
Financialwell‑being:Competitive compensation, extendedhealthand dental benefits, RRSP savings plan with company contribution
And many, many more
What you will be doing:
Review and analyzeprogramdata related to applications, participation, incentives, energy savings, QA/QC findings, trade performance, and customer activity
Produce recurringprogramreports (e.g., weekly, monthly, and quarterly dashboards and summaries) for internalprogramleadership
Respond toad‑hocdata requests and analysis needs to supportprogramplanning, issue resolution, anddecision‑making
Support data validation and quality control efforts to ensure accuracy, consistency, and completeness ofprogramdata
Maintain and update tracking tools, spreadsheets, and dashboards used tomonitorprogramperformance
Assistinidentifyingtrends, anomalies, and opportunitiesfor improvement using quantitative analysis
Support preparation ofclient‑facingreports and materials, contributing analysis and data visualizations as needed
Work withprogramstaff, QA/QC, trade ally management, and IT teams to understand data sources, definitions, and reporting requirements
Leverage emerging analytics andAI‑enabledtools to support data analysis, reporting efficiency, and insight generation
Document assumptions, methodologies, and data limitations clearly and consistently
What we need you to have (minimum qualifications):
Bachelor’s degree in a relevant field (e.g., data analytics, statistics, economics, engineering, environmental studies, business, or a related discipline)
1+ years of relevant experience in data analysis, reporting, or analytical support roles (including internships orco‑opexperience)
What we would like you to have:
Strong quantitative and analytical skills, withdemonstratedexperience working with structured datasets
Proficiencyin Microsoft Excel and experience working with dashboards or reporting tools
Ability to interpret data,identifytrends, and communicate findings clearly tonon‑technicalaudiences
Strong attention to detail and commitment to data accuracy
Comfort using or learningAI‑assistedanalytics and reporting tools
Strong organizational andtime‑managementskills, with the ability to manage multiple requests and priorities
Experience supporting energy efficiency, utility, orpublic‑sectorprograms
Familiarity withprogramtracking systems, CRM platforms, or internal databases
Exposure to Power BI or similar data visualization tools
Experience working with large or complex datasets
Interest in residential energy efficiency,income‑qualifiedprograms, orequity‑focusedinitiatives
Experience contributing toclient‑facingreports or presentations
Ability to work collaboratively withincross‑functionalprogramteams