Charlotte, North Carolina, USA
94 days ago
Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist | Excel Spreadsheet Modernization [USDA015020]

Company Description

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. We help forward-thinking clients solve problems and improve operations.

Launched by former Big 4 Management Consultants; our multidisciplinary teams bring together the talents of nearly 190 professionals globally to complete a wide variety of engagements for Private Companies, Fortune 1,000 Enterprises, and Government Agencies.  Our solution-centric services are deployed across the enterprise, target drivers of economic profit (growth, margin, and efficiency), and are aligned at the intersections of assets, processes, policies, and people delivering value.

ProSidian clients represent a broad spectrum of industries including but not limited to Aerospace And Telecommunications | Consumer Products, Services, And Retail | Development And Sustainability | DOD/Military | Energy, Resources, & Industrials | Financial Services | Government & Public Services | Information Technology, Media, And Telecommunications | Life Sciences & Health Care | Manufacturing And Operations | Nuclear and Environmental | Professional Services |, etc.  Learn More About ProSidian Consulting at https://www.prosidian.com.

Job Description

ProSidian Seeks a Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist | Excel Spreadsheet Modernization [USDA015020] - 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] (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.

 

#VBATraining #ExcelAutomation #ExcelMacros #AdvancedExcel #ExcelVBA #TrainingSpecialist #VBADeveloper #MicrosoftExcel #MOSCertification

Additional Information

CORE COMPETENCIES

Teamwork – ability to foster teamwork collaboratively as a participant, and effectively as a team leaderLeadership – ability to guide and lead colleagues on projects and initiativesBusiness Acumen – understanding and insight into how organizations perform, including business processes, data, systems, and peopleCommunication – ability to effectively communicate to stakeholders of all levels orally and in writingMotivation – persistent in pursuit of quality and optimal client and company solutionsAgility – ability to quickly understand and transition between different projects, concepts, initiatives, or work streamsJudgment – exercises prudence and insight in decision-making process while mindful of other stakeholders and long-term ramificationsOrganization – 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.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 sectorsCuriosity – 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 togetherHumility – exhibits grace in success and failure while doing meaningful work where skills have impact and make a differenceWillingness - 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) Group Medical Benefits, Pretax Employee Benefit Plan, plus performance incentivesGroup Health Insurance Health Benefits:  Group Health Insurance Including Medical, Dental And Vision Insurance: Contributions are deducted from pay on a Pretax basis - Employee and family coverage is available with employer contribution of 50% of Employee (only) premiums under the Health and Vision Plan through Blue Cross Blue Shield NC (Blue Options Medical Plan Code: PB07840 / Metallic Level: Gold - - bcbsnc.com‎) and Dental Plan (Ameritas - www.ameritas.com).401(k) Retirement Savings Plan: 401(k) Retirement Savings Plans help you save for your retirement.  Eligible employees can make before-tax contributions to the 401(k) Retirement Savings Plan to help you save for retirement.  Contributions are deducted from pay on a pretax basis.  A wide range of investment options are available with a personal financial planner available to assist you. The Plan is a Safe Harbor 401(k) Retirement Savings Plan.  Vacation And Paid Time Off (PTO) Benefits:  The flexibility of Paid Time Off (PTO) lets you set your own priorities. Eligible employees use PTO for vacation, a parent-teacher conference, a doctor’s appointment, or any number of events in your life.  Currently these benefits include Vacation/Sick days – 2 weeks | Holidays - 10 Federal Government.Pre-Tax Payment Programs:  Pre-Tax Payment Programs currently exist in the form of a Premium Only Plan (POP).  These Plans offer a full Flexible Spending Account (FSA) Plan and a tax benefit for eligible employees.Purchasing Discounts & Savings Plans:  We want you to achieve financial success. We offer a Purchasing Discounts & Savings Plan through The ProSidian Corporate Perks Benefit Program - Helping You Do More With Less:  https://ProSidian.CorporatePerks.com.  This provides special discounts for eligible employees on products and services you buy on a daily basis.Security Clearance: Due to the nature of our management and operations consulting engagements for Private Companies, Fortune 1,000 Enterprises, and Government Agencies of all sizes; oftentimes there are Security Clearance requirements for Engagement Teams handling sensitive Engagements in the Federal Marketplace.  A Security Clearance is a valued asset in your professional portfolio and adds to your credentials based on past, present, and future work.Leverageable Experience and Thought Leadership:  By collaborating with firm leadership, other members of the team, as well as Fellows and collaborating partners in what is a flat organization, you'll make valuable professional connections, interact with clients daily, gain leverageable Experience, and contribute to Thought Leadership while you build a basket of marketable experiences.ProSidian Employee & Contractor Referral Bonus Program:  ProSidian Consulting will pay up to $5k for all referrals (payments made after new hire has been employed for 90 days) for candidates submitted through our Employee Referral Program.Performance Incentives:  Due to the nature of our management and operations consulting engagements for Private Companies, Fortune 1,000 Enterprises, and Government Agencies of all sizes there are performance incentives associated with each new client that each employee works to pursue and support.Flexible Spending Account:  Pending

------------  ------------  ------------

ADDITIONAL INFORMATION - See Below Instructions On The Best Way To Apply

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. All your information will be kept confidential according to EEO guidelines.ProSidian Consulting has made a pledge to the Hiring Our Heroes Program of the U.S. Chamber of Commerce Foundation and the “I Hire Military” Initiative of The North Carolina Military Business Center (NCMBC) for the State of North Carolina.  All applicants are encouraged to apply regardless of Veteran Status.Furthermore, we believe in "HONOR ABOVE ALL" - be successful while doing things with the right way.  The pride comes out of the challenge; the reward is excellence in the work.  FOR EASY APPLICATION USE OUR CAREER SITE LOCATED ON http://www.ProSidian.com/ OR SEND YOUR RESUME’S, BIOS, AND SALARY EXPECTATION / RATES TO CAREERS @ PROSIDIAN.COM.  ONLY CANDIDATES WITH REQUIRED CRITERIA ARE CONSIDERED. Be sure to place the job reference code in the subject line of your email.  Be sure to include your name, address, telephone number, total compensation package, employment history, and educational credentials.

 

Risk Management | Compliance | Business Processes | IT Effectiveness | Engineering | Environmental | Sustainability | Human Capital

Confirm your E-mail: Send Email