Excel VBA Developer Jobs

1 job found

14d ago

Excel Automation Developer

Quantam Solutions Remote 🌍 Remote

Remote

14d ago

$45 - $50/hr Contract Analytical Skills Automation Data Integration

Apply Now

Job Description

Quantam Solutions offers a remote, contract opportunity for an experienced Excel Automation Developer. In this role you will support an enterprise financial systems project by automating Excel-based journal entry forms and exporting data to flat file formats for PeopleSoft integration. The position pays USD 45 - 50 per hour, spans an initial 6 months with potential extension, and requires working in the Eastern Time zone. This remote role includes collaboration with business stakeholders and opportunities to contribute to ongoing automation efforts.

Benefits

401(k)
Dental insurance
Health insurance
Life insurance
Paid time off
Vision insurance
Work from home

Responsibilities

Develop and enhance Excel-based forms used for journal entry processing.
Create custom Excel ribbon buttons or macro-enabled controls 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, and non-project journal entries.
Validate chart field values and ensure formatting and length standards, such as leading-zero formatting like 00001.
Ensure exported files meet 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.
Collaborate with business stakeholders to refine requirements in environments with limited formal documentation.
Troubleshoot Excel automation issues, file formatting problems, and data validation errors.
Support an ongoing enterprise project with iterative enhancements and long-term automation needs.

Requirements

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.
Solid 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 the ability to work directly with business users.

Technologies

Microsoft Excel, VBA, PeopleSoft, Java

Additional details

Remote role (Virtual Interview)
6-month project with possible extension
Must be able to work on Eastern Time
Some flexibility is available; work may occur outside standard 9:00 AM to 5:00 PM hours as project deadlines and communication require

Compensation

Pay: $45.00 - $50.00 per hour

Work location

Remote

Application questions

Will you now, or in the future, require sponsorship for employment visa status (e.g., H-1B visa status)?
Do you have experience creating custom Excel ribbon buttons, toolbar actions, or user-triggered automation?

View full job page →

Get Excel VBA Developer Jobs alerts

New Excel VBA Developer Jobs, daily.