Certified Data Analyst (CDA) | Excel Spreadsheet Modernization [USDA002017]
Core
Modernize and maintain complex Excel spreadsheets for financial and agricultural data reporting within the USDA Cotton & Tobacco program.
Role type
Senior IC Data Analyst (Excel Automation & Modernization)
Builds
Automated financial reporting templates, data analysis dashboards, and standardized Excel workflows for USDA clients.
Domain
Agriculture and Food Sector (USDA Cotton & Tobacco Program)
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Advanced Excel (VBA, Macros, Power Query, Power Pivot), Data Cleaning & Transformation, Financial Modeling, Statistical Reporting, Database Integration (SQL/Access), Version Control
Preferred skills
MOS Expert Certification, Agricultural Economics background, Budget formulation expertise, User training & documentation
Technologies
Microsoft Excel, VBA, Power Query, Power Pivot, SQL, Access
Responsibilities
Clean and transform financial/agricultural data; Automate data entry and reporting using VBA macros; Build and modernize complex Excel templates with advanced formulas; Integrate Excel with databases to streamline data flow; Generate daily, monthly, and annual statistical reports on commodity prices and revenue; Diagnose and fix errors in complex formulas and macros.
Seniority
Senior, hands-on IC