Junior Data Analyst at ICF in Ottawa, Ontario, Canada

Junior Data Analyst Location: Ottawa, ON 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(Ask your recruiter for more details!) 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 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. Candidate AI Usage Policy At ICF, we are committed to ensuring a fair and equitable interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process. However, we understand that some candidates may require accommodations that involve the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance atcandidateaccommodation@icf.com. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed. Canada Remote Office (CD99) Additional Locations: Toronto, ON