Excel Automation Specialist - Excel Spreadsheet Modernization [USDA006011]

Company: ProSidian Consulting, LLC
Location: Washington
Posted on: November 14, 2024

Job Description:

Excel Automation Specialist - Excel Spreadsheet Modernization [USDA006011]

• 
  
• Full-time
  
  ProSidian is a Management and Operations Consulting Services Firm focusing on providing value to clients through tailored solutions based on industry-leading practices. ProSidian services focus on the broad spectrum of Enterprise Service Solutions for Risk Management, Compliance, Business Process, IT Effectiveness, Engineering, Environmental, Sustainability, and Human Capital.
  ProSidian seeks an Excel Automation Specialist - Excel Spreadsheet Modernization [USDA006011] - DPLH Est.: 2080 Hrs. ST - 0 Hrs. OT on an Exempt [1099] Technical Element Basis Engagement Team - Analyst 5 Labor Category.
  JOB OVERVIEW
  Provide services and support as an Information Technology Center Support (Excel Automation Specialist) in the Agriculture And Food Industry Sector focusing on IT Effectiveness Solutions for clients such as the United States Department of Agriculture (USDA).
  RESPONSIBILITIES AND DUTIES
  
  
• Create, modify, and troubleshoot Excel macros.
  
• Implement Power Query and Power Pivot for advanced data analysis.
  
  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 while ensuring timely delivery of updates and fixes.
    
  • Collaborative Teamwork: Ability to work closely with USDA's divisions to understand specific spreadsheet needs and deliver customized solutions.
    
  • Adaptability: Flexibility to work with a variety of spreadsheet types and respond to ongoing requirements during modernization and training phases.
    
    Desired Qualifications:
    
    • 
      
    • Excel Automation: 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.
      
      Education / Experience Requirements / Qualifications
      
      • 
        
      • Bachelor's in IT, Computer Science, or related field.
        
      • 5+ years of experience in VBA/Excel automation.
        
        Skills Required:
        
        • 
          
        • VBA expertise, advanced Excel automation, Power Pivot/Power Query proficiency.
          
        • Data Analysis Expertise: Ability to perform advanced data analysis using Excel.
          
        • Excellent oral and written communication skills.
          
          OTHER REQUIREMENTS
          
          • 
            
          • U.S. Citizenship Required - You must be a United States Citizen.
            
          • Background Check And Drug testing may be required.
            
            BENEFITS AND HIGHLIGHTS
            
            • 
              
            • Competitive Compensation: Pay range begins in the competitive ranges with full Gold Level Group Medical Benefits.
              
            • Vacation And Paid Time Off (PTO) Benefits: Eligible employees use PTO for various life events.
              
            • 401(k) Retirement Savings Plan: Eligible employees can make before-tax contributions.
              
              ADDITIONAL INFORMATION
              
              • 
                
              • ProSidian Consulting is an equal opportunity employer and considers qualified applicants for employment without regard to protected factors.
                
              • FOR EASY APPLICATION USE OUR CAREER SITE LOCATED ON http://www.ProSidian.com/ OR SEND YOUR RESUME'S TO CAREERS@PROSIDIAN.COM.
                
                #J-18808-Ljbffr

Keywords: ProSidian Consulting, LLC, Washington DC , Excel Automation Specialist - Excel Spreadsheet Modernization [USDA006011], Other , Washington, DC