JOB OVERVIEW
Provide services and support as a Information Technology Center Support (Data Analyst) in the Agriculture And Food Industry Sector focussing on IT Effectiveness Solutions for clients such as United States Department of Agriculture (USDA) | USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program [AMS | C&T]. Generally Located In CONUS : Raleigh, NC and across the South East Region.
RESPONSIBILITIES
- Certified Data Analyst (CDA) | Excel Spreadsheet Modernization [USDA002017] Perform data cleaning, transformation, and analysis of financial / agricultural data using Excel.
- Conduct advanced data analysis for USDA AMS reporting.
- Provide Agriculture And Food Sector related IT Effectiveness Solutions for USDA - AMS Excel Spreadsheet Modernization Services on behalf of The United States Department of Agriculture (USDA) | USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program [AMS | C&T].
- Support Engagment Team with capabilities, past performance, team partners, technical infrastructure, and resources to deliver Market Research Financial Management Report Spreadsheet Modernization for Food And Agriculture Client Industry Sector in an Agriculture And Food Environment USDA AMS C&T Program.
- Understand and document the program structure of the Cotton and Tobacco Program headquarters and regional offices, and align work to the program's needs.
- Handle activities related to administrative management and general management consulting services under NAICS 541611 as they pertain to USDA AMS C&T.
QUALIFICATIONS
Qualifications For Certified Data Analyst (CDA) | Excel Spreadsheet Modernization [USDA001016] Candidates : Microsoft Office Specialist (MOS) | Expert in Excel, CDA (Certified Data Analyst).Experience in Information Technology, Data Science, Financial Analysis, Statistics, Computer Science, or Business Management.Strong background in financial analysis, data management, or agricultural economics relevant to the USDA AMS Cotton & Tobacco Program.Excel Automation : Expertise in using VBA to create, modify, and troubleshoot macros for automating data entry, reporting, and analysis processes.Experience with Excel Power Query and Power Pivot for advanced data modeling and analysis.FUNCTIONAL SKILLSET ATTRIBUTES
Data Analysis Expertise : Ability to perform advanced data analysis using Excel, including data cleaning, transformation, and summarization. Experience with financial data, agricultural data, and budget templates.Advanced Excel Skills : Proficiency with PivotTables, macros, VLOOKUP, INDEX / MATCH, complex formulas, and automated reporting. Experience with building and modernizing Excel templates that involve complex formulas, charts, and financial analysis tools.Business Process Understanding : Ability to understand and optimize the workflow, including budget formulation, financial reporting, and user-fee billing and analysis. Familiarity with USDA reporting requirements related to cotton price statistics, revenue and collection reports, and salary / benefits tracking.Training & Documentation Skills : Expertise in creating user manuals and documentation for updated spreadsheets and systems; experience delivering basic training sessions for end-users.Financial Management Reporting Expertise : Experience in preparing and modernizing budget templates, exhibit expense templates, and personnel salary and benefits tracking reports; familiarity with USDA financial templates for fiscal year reporting, revenue collections, and loan premiums / discounts data analysis.TECHNICAL SKILLSET ATTRIBUTES
Excel Automation : VBA, Power Query, Power Pivot for data modeling and analysis.Database Integration & Management : Experience integrating Excel with databases (e.g., SQL or Access) to streamline data flow; ability to manage large datasets.Financial and Statistical Reporting : Knowledge of financial modeling, cash flow analysis, and reports summarizing agricultural commodity data; ability to generate daily, monthly, and annual statistical reports (cotton prices, user-fees, revenue).Version Control & Troubleshooting : Manage versions of Excel files, track changes, and diagnose errors in formulas, macros, and linked workbooks.ADDITIONAL COMPETENCIES REQUIRED
Attention to Detail : Ability to scrutinize complex macros and formulas and identify errors or inefficiencies.Time Management : Capable of handling multiple spreadsheet modernization tasks across divisions with timely delivery of updates and fixes.Collaborative Teamwork : ProSidian ConsultingJ-18808-Ljbffr