ZipRecruiter

Log In

1

Excel Vba Developer Jobs in Kentucky (NOW HIRING)

Quantam

Excel Automation Developer

Lexington, KY · On-site

This person does not need to be a full-stack developer, but they should be very strong with Excel, VBA, macros, data transformation, and flat file generation. Key Responsibilities: * Develop and ...

Varsity Tutors

Microsoft Excel Tutor

Louisville, KY · Remote

$18 - $40/hr

What We Look For In a Microsoft Excel Tutor * Advanced Subject Mastery: Deep knowledge of ... basic VBA programming. Ability to explain cell referencing, formula nesting, and data analysis ...

Varsity Tutors

Microsoft Excel Tutor

Lexington, KY · Remote

$18 - $40/hr

What We Look For In a Microsoft Excel Tutor * Advanced Subject Mastery: Deep knowledge of ... basic VBA programming. Ability to explain cell referencing, formula nesting, and data analysis ...

Caldwell Tanks

Design Draftsman

Louisville, KY · On-site

We're looking for a Design Drafter to join our engineering team in Louisville, Kentucky and help ... Proficiency in AutoCAD and Microsoft Excel * Ability to read and interpret technical drawings ...

All JobsExcel Vba Developer JobsExcel Vba Developer Jobs in Kentucky

Excel Vba Developer information

See Kentucky salary details

$9.6K

$117.3K

$138.1K

How much do excel vba developer jobs pay per year?

As of Jun 26, 2026, the average yearly pay for excel vba developer in Kentucky is $117,251.00, according to ZipRecruiter salary data. Most workers in this role earn between $99,900.00 and $134,600.00 per year, depending on experience, location, and employer.

What is the difference between Excel Vba Developer vs Data Analyst?

AspectExcel Vba DeveloperData Analyst
Required skillsVBA programming, Excel automationData analysis, SQL, Excel, visualization
Work environmentFinance, IT, operationsBusiness, marketing, finance
CertificationsExcel VBA certifications, Microsoft Office certificationsData analysis certifications (e.g., CAP, Microsoft Certified Data Analyst)

Excel Vba Developers focus on automating Excel tasks using VBA, while Data Analysts interpret data and create reports. Both roles often work in similar industries and require strong Excel skills, but their core responsibilities differ: automation versus data interpretation.

What are some common challenges Excel VBA Developers face when working with large or complex datasets?

Excel VBA Developers often encounter performance issues when automating tasks with large or complex datasets, as Excel has inherent limitations in processing speed and data capacity. Optimizing code for efficiency—such as minimizing loops, using arrays, and reducing interactions with worksheet cells—can help mitigate these issues. Additionally, ensuring data integrity and error handling becomes increasingly important as complexity grows, so writing robust, well-documented code is essential. Collaborating closely with data owners and end-users can also help clarify requirements and streamline workflows.

What Is an Excel VBA Developer?

An Excel VBA Developer works with the Microsoft event-driven macro programming language, Visual Basic for Applications. You create user-defined functions and automation processes by using code to build a script based on your company’s needs. Your duties include presetting the software with user preferences and performing routine analysis, including data mapping and updating the database. Other responsibilities include working with trading desk personnel to develop processes to enhance workflow efficiency. You handle any of the company’s ad hoc requests to generate data files. You also maintain existing scripts and processes.

What are Excel VBA Developers?

Excel VBA Developers are professionals who specialize in creating, modifying, and maintaining macros, scripts, and custom solutions using Visual Basic for Applications (VBA) within Microsoft Excel. They leverage VBA to automate repetitive tasks, enhance data analysis, and design user-friendly tools and dashboards tailored to business needs. Their expertise helps organizations improve efficiency, accuracy, and productivity in data processing and reporting.

What are the key skills and qualifications needed to thrive as an Excel VBA Developer, and why are they important?

To thrive as an Excel VBA Developer, you need strong proficiency in Excel functions, advanced VBA programming, and a solid understanding of data analysis, usually supported by a degree in computer science, information systems, or a related field. Familiarity with Microsoft Office Suite, version control systems like Git, and relevant certifications such as Microsoft Office Specialist are often required. Attention to detail, problem-solving ability, and effective communication skills help developers understand user needs and deliver robust solutions. These competencies ensure the development of efficient, reliable automated processes that improve productivity and data accuracy within organizations.
More about Excel Vba Developer jobs
What are the most commonly searched types of Excel Vba Developer jobs in Kentucky? The most popular types of Excel Vba Developer jobs in Kentucky are:
What are popular job titles related to Excel Vba Developer jobs in Kentucky? For Excel Vba Developer jobs in Kentucky, the most frequently searched job titles are:
What job categories do people searching Excel Vba Developer jobs in Kentucky look for? The top searched job categories for Excel Vba Developer jobs in Kentucky are:
What are popular job titles related to Excel Vba Developer jobs in KY? For Excel Vba Developer jobs in KY, the most frequently searched job titles are:
Excel Vba Developer jobs near you
Excel Automation Developer

Excel Automation Developer

Quantam

Lexington, KY • On-site

Full-time

Medical, Retirement, PTO

Posted 8 days ago

Job description

Overview:
Quantam Solutions provides IT solutions and consulting for various clients. We offer a competitive hourly wage, health benefits, paid time off, and a 401(k) plan. We're currently seeking an Excel Automation Developer for our client. Candidates must be a U.S. Citizen.
Overview:
Our client is seeking an experienced Excel Automation Developer to support an ongoing enterprise financial systems project. This role will focus on enhancing and automating complex Excel-based journal entry forms used to prepare data for uploading into PeopleSoft.
The ideal candidate will have strong experience building Excel-based tools, creating custom ribbon buttons or macros, consolidating workbook data across multiple tabs, validating data formatting rules, and generating flat files for downstream system processing. This person does not need to be a full-stack developer, but they should be very strong with Excel, VBA, macros, data transformation, and flat file generation.
Key Responsibilities:
  • Develop and enhance Excel-based forms used for journal entry processing.
  • Create custom Excel ribbon buttons or macro-enabled controls that allow users to export data from one tab or all tabs.
  • Automate the conversion of structured Excel data into flat file formats for downstream processing.
  • Consolidate multiple workbook tabs into a single output file containing required header and line detail records.
  • Build logic to support different journal entry types, including: $0 journal entries, project-related, journal entries, non-project journal entries.
  • Validate chart field values and ensure they meet required formatting and length standards, such as leading-zero formatting like 00001.
  • Ensure exported files meet required flat file layout specifications for staging table imports.
  • Support integration needs where exported files are imported into PeopleSoft through Java-based processes and staging tables.
  • Work with business stakeholders to refine requirements where formal documentation may be limited.
  • Troubleshoot Excel automation issues, file formatting issues, and data validation errors.
  • Support an ongoing enterprise project with iterative enhancements and long-term automation needs.

Required Skills and Experience:
  • Strong Microsoft Excel development experience.
  • Advanced VBA/macros experience.
  • Experience creating custom Excel ribbon buttons, toolbar actions, or user-triggered automation.
  • Experience converting Excel workbook data into flat files, CSV, TXT, or other structured output formats.
  • Strong understanding of workbook structures, multiple tabs, named ranges, formulas, and data validation.
  • Ability to consolidate data from multiple Excel tabs into a single file.
  • Experience working with header/detail file structures.
  • Strong data formatting and validation skills, including fixed-length fields, leading zeros, and required field lengths.
  • Ability to work independently from notes, business conversations, and limited formal documentation.
  • Strong communication skills and ability to work directly with business users.

Preferred Skills
  • Experience with PeopleSoft Financials or ERP financial systems.
  • Experience with journal entry processing, general ledger data, or financial transaction files.
  • Experience creating files used for staging table imports.
  • Basic understanding of Java-based import processes or how flat files are consumed by backend applications.
  • Experience working with government, public sector, or enterprise finance teams.

Additional Details:
  • Remote role (Virtual Interview)
  • 6-month project with possible extension.
  • Must be able to work on Eastern Time.
  • Some flexibility is available, and work may be performed outside standard 9:00 AM to 5:00 PM hours as long as project deadlines and communication needs are met.

Skills:
Microsoft Excel,Visual Basic for Applications (VBA),Macros,Excel Automation,Flat Files,Data Validation

Apply