Excel Specialist, Spreadsheet Modernization

This is a fully remote position, open to applicants in District of Columbia, +2 more states.

📋 Description

• Design and enhance Excel templates to meet modern standards.

• Resolve issues in complex workbooks effectively.

• Automate data entry, reporting, and analysis tasks utilizing VBA.

• Conduct advanced data analysis, including cleaning, transformation, and summarization.

• Create templates featuring intricate formulas, charts, and financial analysis tools.

• Connect Excel with databases to optimize data flow.

• Handle large datasets while ensuring efficient data structures.

• Produce daily, monthly, and annual statistical reports on cotton prices, user fees, and revenue.

• Oversee Excel file versions and monitor changes across various divisions.

• Identify and rectify errors in formulas, macros, and linked workbooks.

• Comprehend and enhance workflows related to budget formulation, financial reporting, and user-fee analysis.

• Collaborate closely with the USDA Cotton & Tobacco divisions to assess spreadsheet needs.

• Provide tailored spreadsheet solutions and guarantee user satisfaction.

• Assist in modernization and training initiatives.

• Generate comprehensive, precise, and well-documented work products that satisfy established criteria and timelines.

• Work in partnership with firm leadership, team members, Fellows, partners, and clients.

⛳️ Requirements

• Bachelor’s degree in IT, Computer Science, or a related field.

• 3+ years of relevant experience.

• Microsoft Office Specialist (MOS) Expert certification in Excel is desired or required.

• Advanced proficiency in Excel, including PivotTables, Power Query, VBA, macros, VLOOKUP, INDEX/MATCH, complex formulas, charts, and automated reporting.

• Strong skills in data analysis and reporting, including data cleaning, transformation, and summarization.

• Experience with financial data, agricultural data, budget templates, financial modeling, cash flow analysis, and user-fee assessment.

• Solid background in financial analysis, data management, or agricultural economics pertinent to the USDA AMS Cotton & Tobacco Program.

• Proven experience in building and modernizing Excel templates.

• Familiarity with Excel Power Pivot.

• Experience in integrating Excel with SQL or Access databases.

• Capability to manage large datasets while ensuring proper data structure.

• Proficiency in generating daily, monthly, and annual statistical reports concerning cotton prices, user fees, and revenue.

• Ability to oversee Excel file versions and monitor changes.

• Competence in diagnosing and correcting errors in formulas, macros, and linked workbooks.

• Understanding of budget formulation, financial reporting, user-fee billing and analysis, and USDA reporting requirements.

• Exceptional oral and written communication skills.

• Proficient in Microsoft Word, Excel, PowerPoint, Publisher, Adobe Acrobat, Access, Outlook, data analytic tools, and Visio.

• Knowledgeable in project management methodologies and tools.

• U.S. citizenship is required.

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

• Subject to background checks and, for designated roles, drug testing.

• Employees must comply with regulatory and mandatory training requirements.

• No specific licensure is necessary.

🏝️ Benefits

• Competitive Compensation.

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

• Employer contribution of 50% towards employee-only premiums under the Health and Vision Plan.

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

• Vacation and paid time off (PTO): 2 weeks for vacation/sick days.

• 10 federal government holidays.

• Pre-tax payment programs, such as Premium Only Plan (POP) and Flexible Spending Account (FSA) Plan.

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

• Employee and Contractor Referral Bonus Program: up to $5,000 for referrals after the new hire has been employed for 90 days.

• Performance-based incentives.

• Opportunities for professional connections, client interaction, leverageable experience, and thought leadership.

• Flexible remote work arrangements.