Excel Automation Developer

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?