College Aide
Core
Support senior analysts and departments by collecting, cleaning, interpreting, and processing extensive financial datasets for analysis and reporting.
Role type
Junior data analyst / data support specialist
Builds
Dashboards, graphs, charts, and reports for contract awards, spending, KPIs, and budget tracking
Domain
Public sector / municipal government / financial data
Deliverable
dashboards & analysis
Required skills
SQL, Python, R, Microsoft Excel (Pivot Tables, Xlookups), data collection, data cleaning, data visualization, documentation
Preferred skills
Knowledge of PASSPort, Warehouse Management System (WMS), Financial Management System (FMS)
Responsibilities
Gather and clean data from various sources; Query databases and perform gap/diagnostic/descriptive analysis; Create dashboards and charts to present findings; Support senior analysts with data-driven insights; Maintain documentation of data workflows and report instructions
Seniority
Entry-level / Student