Certified Data Analyst, Excel Spreadsheet Modernization

Role Overview

• 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
• Support professional services engagement for Agriculture And Food Sector Clients such as USDA
• Collaborate closely with USDA’s Cotton & Tobacco divisions to understand specific spreadsheet needs, ensure user satisfaction, and deliver customized solutions
• Manage multiple spreadsheet modernization tasks across divisions while ensuring timely delivery of updates and fixes
• Create, modify, and troubleshoot macros for automating processes
• Prepare and modernize budgeting and reporting templates
• Ensure thorough, accurate, appropriately documented work products
• Conduct background checks and drug testing for compliance

Requirements

• 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
• Expertise in using VBA (Visual Basic for Applications) 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
• Ability to perform advanced data analysis using Excel, including data cleaning, transformation, and summarization
• Proficiency with Excel’s advanced features such as PivotTables, macros, VLOOKUP, INDEX/MATCH, complex formulas, and automated reporting
• Familiarity with the USDA's specific reporting requirements, especially those related to cotton price statistics, revenue and collection reports, and salary/benefits tracking
• Expertise in creating comprehensive user manuals and documentation for updated spreadsheets and systems
• Experience in delivering basic training sessions for end-users, ensuring that they understand how to use the new or modernized Excel sheets effectively
• Strong experience in preparing and modernizing budget templates, exhibit expense templates, and personnel salary and benefits tracking reports
• Knowledge of financial modeling, cash flow analysis, and creating reports that summarize agricultural commodity data
• Ability to manage versions of Excel files and track changes, especially when working on complex spreadsheets across multiple divisions

Tech Stack

• VBA

Benefits

• Competitive Compensation: Pay range begins in the competitive ranges with full Gold Level (Tier 1) Group Medical Benefits, Pretax Employee Benefit Plan, plus performance incentives
• Group Health Insurance Including Medical, Dental And Vision Insurance: Contributions are deducted from pay on a Pretax basis
• Employee and family coverage is available with employer contribution of 50% of Employee (only) premiums under the Health and Vision Plan through Blue Cross Blue Shield NC (Blue Options Medical Plan Code: PB07840 / Metallic Level: Gold)
• 401(k) Retirement Savings Plans help you save for your retirement. Eligible employees can make before-tax contributions to the 401(k) Retirement Savings Plan to help you save for retirement
• The flexibility of Paid Time Off (PTO) lets you set your own priorities. Eligible employees use PTO for vacation, a parent-teacher conference, a doctor’s appointment, or any number of events in your life. Currently these benefits include Vacation/Sick days – 2 weeks | Holidays
• 10 Federal Government.
• These Plans offer a full Flexible Spending Account (FSA) Plan and a tax benefit for eligible employees.
• We offer a Purchasing Discounts & Savings Plan through The ProSidian Corporate Perks Benefit Program
• Helping You Do More With Less.
• A Security Clearance is a valued asset in your professional portfolio and adds to your credentials based on past, present, and future work.
• ProSidian Employee & Contractor Referral Bonus Program: ProSidian Consulting will pay up to $5k for all referrals (payments made after new hire has been employed for 90 days) for candidates submitted through our Employee Referral Program.
• There are performance incentives associated with each new client that each employee works to pursue and support.