Excel Specialist, Spreadsheet Modernization

Job Description:

  • Develop and modernize Excel templates
  • Troubleshoot complex workbooks
  • Automate data entry, reporting, and analysis processes using VBA
  • Perform advanced data analysis, including data cleaning, transformation, and summarization
  • Build templates with complex formulas, charts, and financial analysis tools
  • Integrate Excel with databases to streamline data flow
  • Manage large datasets and ensure effective data structures
  • Generate daily, monthly, and annual statistical reports on cotton prices, user fees, and revenue
  • Manage Excel file versions and track changes across multiple divisions
  • Diagnose and fix errors in formulas, macros, and linked workbooks
  • Understand and optimize workflows for budget formulation, financial reporting, and user-fee billing and analysis
  • Work closely with USDA Cotton & Tobacco divisions to understand spreadsheet needs
  • Deliver customized spreadsheet solutions and ensure user satisfaction
  • Support modernization and training phases
  • Produce thorough, accurate, documented work products that meet established criteria and delivery schedules
  • Collaborate with firm leadership, team members, Fellows, partners, and clients

Requirements:

  • Bachelor’s in IT, Computer Science, or related field
  • 3+ years of experience
  • Microsoft Office Specialist (MOS) Expert in Excel desired/required as a professional certification
  • Advanced Excel proficiency, including PivotTables, Power Query, VBA, macros, VLOOKUP, INDEX/MATCH, complex formulas, charts, and automated reporting
  • Strong data analysis and reporting skills, including data cleaning, transformation, and summarization
  • Experience with financial data, agricultural data, budget templates, financial modeling, cash flow analysis, and user-fee analysis
  • Strong background in financial analysis, data management, or agricultural economics relevant to the USDA AMS Cotton & Tobacco Program
  • Experience building and modernizing Excel templates
  • Experience with Excel Power Pivot
  • Experience integrating Excel with SQL or Access databases
  • Ability to manage large datasets and ensure proper data structure
  • Proficiency generating daily, monthly, and annual statistical reports related to cotton prices, user fees, and revenue
  • Ability to manage Excel file versions and track changes
  • Ability to diagnose and fix errors in formulas, macros, and linked workbooks
  • Understanding of budget formulation, financial reporting, user-fee billing and analysis, and USDA reporting requirements
  • Excellent oral and written communication skills
  • Proficiency with Microsoft Word, Excel, PowerPoint, Publisher, Adobe Acrobat, Access, Outlook, data analytic tools, and Visio
  • Proficiency in project management methodologies and tools
  • U.S. citizenship required
  • No visa sponsorship; H-1B and TN visa sponsorship not supported
  • Subject to background checks and, for designated positions, drug testing
  • Employees are subject to regulatory and mandatory training requirements
  • No specific licensure required

Benefits:

  • Competitive Compensation
  • Group health insurance including medical, dental, and vision insurance
  • Employer contribution of 50% of employee-only premiums under the Health and Vision Plan
  • 401(k) Safe Harbor Retirement Savings Plan with before-tax contributions and investment options
  • Vacation and paid time off (PTO): 2 weeks vacation/sick days
  • 10 federal government holidays
  • Pre-tax payment programs, including Premium Only Plan (POP) and Flexible Spending Account (FSA) Plan
  • Purchasing 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 incentives
  • Professional connections, client interaction, leverageable experience, and thought leadership opportunities
  • Flexible remote work arrangement
Back to blog

Other Jobs To Apply

No other job posts for this day.

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...