Excel Automation Specialist – Excel Spreadsheet Modernization

This is a fully remote position, open to applicants in Virginia, +1 more state.

📋 Description

• Develop, enhance, and resolve issues with Excel macros.

• Utilize Power Query and Power Pivot for sophisticated data analysis and modeling.

• Streamline data entry, reporting, and analysis processes through VBA automation.

• Design and update Excel templates featuring intricate formulas, charts, and financial analysis tools.

• Conduct data cleaning, transformation, summarization, and in-depth analysis of financial and agricultural datasets.

• Assist in budget preparation, financial reporting, user-fee billing and analysis, cotton price statistics, revenue and collection reports, and tracking of salaries/benefits.

• Provide IT Center support for USDA Agriculture Marketing Service engagements related to the Cotton & Tobacco Program.

• Collaborate with USDA Cotton & Tobacco divisions to ascertain spreadsheet requirements and deliver tailored solutions.

• Educate users and create documentation for upgraded Excel spreadsheets.

• Oversee multiple spreadsheet modernization projects across various divisions and ensure the achievement of delivery deadlines.

• Guarantee that all deliverables are comprehensive, precise, well-documented, and adhere to established standards.

⛳️ Requirements

• Bachelor’s degree in IT, Computer Science, or a relevant discipline.

• Over 5 years of experience in VBA/Excel automation.

• Proficient in utilizing VBA for the creation, modification, and troubleshooting of macros.

• Familiarity with Excel Power Query and Power Pivot.

• Advanced skills in Excel, including macros, VBA, complex formulas, PivotTables, VLOOKUP, INDEX/MATCH, and automated reporting.

• Experience in data cleaning, transformation, summarization, financial data, agricultural data, and budget templates.

• Proficient in Microsoft Office applications, such as Word, Excel, PowerPoint, Publisher, and Adobe.

• Advanced skills in Excel, Access, Outlook, PowerPoint, and Word.

• Familiarity with Adobe Acrobat, data analytics tools, and Visio.

• Background in financial analysis, data management, or agricultural economics related to the USDA AMS Cotton & Tobacco Program.

• Proficient in financial management reporting, budget preparation, user-fee analysis, database integration, and automation.

• Experience in training and documentation.

• Exceptional oral and written communication abilities.

• Familiarity with project management methodologies and tools.

• U.S. citizenship is mandatory.

• Visa sponsorship is not available; H-1B and TN visas are not supported.

• Subject to background checks and potential drug testing.

• Must adhere to regulatory and mandatory training requirements.

• Professional certifications such as MOS Expert in Excel, Certified Data Analyst, CBAP, Lean Six Sigma, and PMP are considered advantageous.

• No specific licensure is required.

🏝️ Benefits

• Competitive salary.

• Group health insurance, including medical, dental, and vision coverage.

• Employer covers 50% of employee-only premiums for the Health and Vision Plan.

• 401(k) Safe Harbor Retirement Savings Plan with pre-tax contributions.

• Vacation and sick leave totaling 2 weeks.

• Observance of 10 federal government holidays.

• Pre-Tax Payment Programs available.

• Flexible Spending Account (FSA) Plan.

• Discounts and savings through the ProSidian Corporate Perks Benefit Program.

• Employee and contractor referral bonus program, offering up to $5,000 after the referred new hire completes 90 days of employment.

• Performance-based incentives.

• Opportunities for professional networking, client interaction, gainful experience, and thought leadership.

• Flexible remote work arrangements.