Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist | Excel

Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist

ProSidian Seeks a Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist | Excel Spreadsheet Modernization - DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt [1099] Technical Element Basis Key Personnel | Analyst 4 Labor Category - High Level Exempt [1099] Professional aligned under services related to NAICS: 541611 - DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt [1099] Technical Element Basis located CONUS: Washington, DC | Reston, VA | Memphis, TN | Raleigh, NC | Charlotte, NC Across The South East Region supporting responsible for overseeing farming, ranching, and forestry industries, as well as regulating aspects of food quality and safety and nutrition labeling.

Seeking Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist candidates with relevant Agriculture And Food Sector Experience (functional and technical area expertise also ideal) to support professional services engagement for Agriculture And Food Sector Clients such as USDA. This as a Technical Element or Contract W-2 (IRS-1099) Position and ProSidian reserves the right to convert to a Full-Time ProSidian employed W-2 Position.

JOB OVERVIEW

Provide services and support as a Information Technology Center Support (Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist) in the Agriculture And Food Industry Sector focussing on IT Effectiveness Solutions for clients such as United States Department of Agriculture (USDA) | USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program [AMS | C&T] Generally Located In CONUS: Washington, DC | Reston, VA | Memphis, TN | Raleigh, NC | Charlotte, NC and across the South East Region.

RESPONSIBILITIES AND DUTIES - Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist | Excel Spreadsheet Modernization [USDA015020]

Develop and deliver training on Expert Microsoft Excel with Visual Basic for Applications (VBA), including complex automation tasks. Create VBA macros, custom Excel functions, and automated workflows. Lead hands-on training sessions for advanced Excel users.

Qualifications

Desired Qualifications For Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist | Excel Spreadsheet Modernization [USDA015020] Candidates:

Proficiency in Advanced Microsoft Excel features (Power Query, Power Pivot, Macros) and advanced VBA programming for automation. Expertise in developing custom Excel solutions and delivering technical training.

Job Title: Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist

Labor Category: Microsoft Excel Automation Specialist

This role combines expertise in Advanced Microsoft Excel features, VBA programming, and training delivery, ensuring the individual can not only develop complex VBA solutions but also effectively teach others how to leverage advanced Microsoft Excel functionalities and automation. The Microsoft Excel Automation Specialist category reflects the advanced technical skills required for VBA programming and Microsoft Excel automation, as well as the ability to conduct high-level training.

To fulfill the technical requirements for the specified Course: Expert Microsoft Excel with Visual Basics training courses, each course would require specific labor categories, expertise, skillsets, certifications, and experience.

Expert Microsoft Excel with Visual Basics (Item No.: 35)

Labor Category: Microsoft Excel Automation Specialist, Visual Basic for Applications [VBA] Developer, Data Analyst, Training Specialist

Expertise:

Proficiency in Advanced Microsoft Excel features, including Power Query, Power Pivot, Advanced Formulas, and Macros.

Strong understanding of VBA programming for automating complex tasks such as dynamic reporting, data cleaning, and form development in Microsoft Excel.

Experience with creating Custom Microsoft Excel Functions, User Forms, and complex data automation through VBA.

Skillsets:

Proficiency in writing, debugging, and optimizing VBA code.

Expertise in teaching advanced Microsoft Excel functionalities, including the creation and management of Microsoft Excel dashboards, automated reports, and complex workflows.

Ability to guide users through hands-on exercises in VBA development.

Certifications:

Microsoft Office Specialist (MOS) Microsoft Excel Expert Certification Required for advanced and intermediate courses.

Microsoft Office Specialist (MOS) Microsoft Excel Expert.

Advanced VBA Certification or significant demonstrated experience with Visual Basic programming Preferred for the expert-level course.

Experience:

5+ years of experience working with Advanced Microsoft Excel and VBA scripting.

Demonstrated ability to automate processes using VBA for real-world applications.

Proven track record of conducting Expert Microsoft Excel and VBA training for technical and non-technical audiences.

Experience in delivering corporate or government training on Microsoft Excel, with a proven ability to engage learners and customize the course content to meet specific organizational needs.

Education / Experience Requirements / Qualifications:

Bachelor's degree in Business, IT, or related field. 5+ years of experience working with advanced Excel and VBA development. Proven ability to automate real-world applications and conduct corporate or government training.

Skills Required:

Proficiency in VBA code writing, debugging, and optimization. Expertise in creating custom functions, Excel dashboards, and automating reports. Strong ability to guide users in VBA development exercises.

Competencies Required:

Strong communication and instructional skills. Ability to translate complex VBA concepts into understandable lessons for diverse learners. Ability to manage time and prioritize training objectives.

Ancillary Details Of The Roles:

Experience delivering advanced Excel training in a corporate or government environment. Ability to manage multiple training sessions while maintaining engagement and content quality.

Familiarity with training methodologies and the use of modern technologies for delivering technical content. Proven ability to balance technical content with practical instructional delivery.

Other Details:

This role is critical for training users in advanced Excel and VBA automation, ensuring they can streamline workflows and improve productivity. The role requires both technical development skills and instructional expertise.

Additional Information

CORE COMPETENCIES

• Teamwork ability to foster teamwork collaboratively as a participant, and effectively as a team leader
• Leadership ability to guide and lead colleagues on projects and initiatives
• Business Acumen understanding and insight into how organizations perform, including business processes, data, systems, and people
• Communication ability to effectively communicate to stakeholders of all levels orally and in writing
• Motivation persistent in pursuit of quality and optimal client and company solutions
• Agility ability to quickly understand and transition between different projects, concepts, initiatives, or work streams
• Judgment exercises prudence and insight in decision-making process while mindful of other stakeholders and long-term ramifications
• Organization ability to manage projects and activity, and prioritize tasks

OTHER REQUIREMENTS

• Business Tools understanding and proficiency with business tools and technology, including Microsoft Office. The ideal candidate is advanced with Excel, Access, Outlook, PowerPoint and Word, and proficient with Adobe Acrobat, data analytic tools, and Visio with the ability to quickly learn other tools as necessary.
• Commitment - to work with smart, interesting people with diverse backgrounds to solve the biggest challenges across private, public and social sectors
• Curiosity the ideal candidate exhibits an inquisitive nature and the ability to question the status quo among a community of people they enjoy and teams that work well together
• Humility exhibits grace in success and failure while doing meaningful work where skills have impact and make a difference
• Willingness - to constantly learn, share, and grow and to view the world as their classroom

BENEFITS AND HIGHLIGHTS

At ProSidian, we invest in our employees to help them stay healthy and achieve work-life balance. Our team members receive a comprehensive benefits package that includes Competitive Compensation, Group Health Insurance Health Benefits, 401(k) Retirement Savings Plan Contributions, Vacation and Paid Time off (PTO) Benefits, Pre-Tax Payment Programs, Purchasing Discounts & Savings Plans, a ProSidian Employee & Contractor Referral Bonus Program, Performance Incentives, etc. Our comprehensive benefits package includes a medical, dental and vision plan. Our growing list of benefits currently include the following:

• Competitive Compensation: Pay range begins in the competitive ranges with full Gold Level (Tier 1)