Excel Automation Specialist Excel Spreadsheet Modernization USDA006011
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 located in CONUS: Washington, DC, and Reston, Virginia.
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:
- 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.
Professional Certifications:
- Microsoft Office Specialist (MOS) Expert in Excel.
- Certified Data Analyst (CDA).
- Certified Business Analysis Professional (CBAP).
Skills Required
- VBA expertise, advanced Excel automation, Power Pivot/Power Query proficiency.
- Data Analysis Expertise.
- Advanced Excel Skills.
OTHER REQUIREMENTS
U.S. Citizenship Required - You must be a United States Citizen.
ADDITIONAL INFORMATION
ProSidian Consulting is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, creed, religion, national origin, sex, sexual orientation, gender identity and expression, age, disability, or Vietnam era, or other eligible veteran status, or any other protected factor.
FOR EASY APPLICATION USE OUR CAREER SITE LOCATED ON OR SEND YOUR RESUME'S TO .