ICF→
Data & Reporting Analyst – Business Systems at ICF in Reston, VA
Entry LevelOn-siteFull-timeReston, VA$67k–$114k/yr
Skills
power bisqlzycus ianalyzedata analysisadvanced exceldata stewardshipprocurement analyticspythonsparkgrowth mindset
Job Description
Summary: ICF is a global advisory and technology services provider, and they are seeking a Data & Reporting Analyst to help transform value stream data into actionable insights. The role involves owning monthly spend data processing, developing dashboards, and supporting reporting governance across various corporate teams.
Responsibilities:
- Own monthly iAnalyze spend processing, including data intake, normalization and classification, quality validation, reconciliation to source systems, and adherence to defined refresh cadences
- Coordinate data refresh timelines and stakeholder communications to ensure consistency, reliability, and auditability
- Design, build, and maintain Zycus iAnalyze dashboards and reports for Procurement leaders and category teams, publishing standardized views and enabling curated self‑service analytics
- Design, build, and maintain Zycus Insight Studio dashboards for leaders and end users; manage shared report folders and standardized reporting assets
- Develop and support Power BI dashboards, including data modeling, DAX measures, and row‑level security, to meet executive and operational reporting needs
- Provide functional and administrative support for Zycus reporting modules, including iAnalyze, iRisk, Insight Studio, iManage, and iSave (roles and permissions, issue triage, defect tracking, and release awareness)
- Partner with Procurement leadership and Business Transformation to define and execute the reporting strategy, including executive reporting packs, adoption KPIs, taxonomy governance, and training materials
- Maintain comprehensive reporting documentation, including data lineage, transformation logic, calculations, dashboard guides, and change request history
- Contribute to and enhance the AOS knowledge repository to ensure repeatability and continuity
- Collaborate closely with AOS Applications Administration and IT on integrations, data quality initiatives, and logging/monitoring to sustain reliable reporting pipelines
- Support the development, implementation, and sustainment of AI tools and agents as part of the AOS analytics roadmap
Required Qualifications:
- Bachelor's degree in a quantitative field (e.g., Analytics, Finance, Information Systems) or equivalent practical experience
- Minimum 1 year of experience in data analysis and reporting, including ownership of production dashboards and scheduled data refreshes
- Strong proficiency in Power BI (DAX, data modeling, row-level security), advanced Excel, and SQL for data preparation and validation
- Solid understanding of core data concepts, including cardinality, parent-child relationships, and strategies for joining large datasets
- Demonstrated ability to document processes clearly and communicate insights effectively to both leadership and non-technical audiences
- Data stewardship and accuracy; Process discipline and documentation; Stakeholder partnership and collaboration; Critical thinking and problem solving; Growth mindset and continuous improvement
Preferred Qualifications:
- Experience with procurement and spend analytics, including taxonomy management, vendor normalization, and GL/AP data integration
- Experience defining executive reporting packs and establishing analytics governance models
- Knowledge of sourcing and procurement functions, including category strategies, supplier risk, and compliance controls
- A data-engineering mindset, with familiarity in ETL best practices, reproducible pipelines, testing/validation, and change management
- Proficiency with Python and/or Spark, and advanced use of complex Excel or Java functions
- Hands-on experience with the Zycus reporting stack (iAnalyze, Insight Studio) and familiarity with iRisk, iManage, and iSave
Required Skills: Power BI, SQL, Zycus iAnalyze
Important Skills: Data analysis, Advanced Excel, Data stewardship, Procurement analytics
Nice-to-Have Skills: Python, Spark, Growth mindset