Senior VBA Developer

Minisoft Technologies LLC; Tampa (FL); Vor Ort; USD 90.000 - 140.000; Teilzeit

Zusammenfassung

A tech consulting firm is looking for a Senior VBA Developer with deep T-SQL expertise to reverse-engineer a legacy application and implement modern SQL-centric data flows. You will design SQL Server schemas, build robust ETL/data pipelines, and integrate with Infor systems. This role requires ensuring the performance and reliability of on-prem solutions. Ideal candidates should have experience with MS Access and a strong understanding of data integration and security protocols. This is a contract role based in Tampa, Florida.

Qualifikationen

• Experience in reverse-engineering MS Access 2003/VBA applications.
• Proven ability to design SQL Server schemas and robust ETL/data ingestion processes.
• Strong understanding of API design and data integration.
• Integrate Access/SQL with Infor ERP ecosystem via interfaces.
• Maintain on‑prem performance and reliability, with tuning and analytics.
• Define coding standards, version control, and test harnesses.
• Map legacy rules to new data structures with testers' input.
• Plan dependencies and cutover strategies for S4 migration.

Aufgaben

• Reverse-engineer legacy applications and document workflows.
• Design and implement SQL schemas and data flows.
• Build ETL pipelines for data processing and validation.
• Integrate Access/SQL with Infor ecosystem and maintain ERP data security.
• Maintain on‑prem performance: indexing, tuning, statistics, and isolation levels.
• Establish coding standards, version control, and documentation; implement tests.
• Collaborate with estimators and dealers to map legacy rules to modern data models.
• Prepare for S4 migration by isolating dependencies and planning rollbacks.

Kenntnisse

VBA Development

T-SQL Expertise

MS Access 2003

SQL Server Schemas

ETL/data ingestion

API Integration

Indexing and Query Tuning

Tools

SQL Server

Infor Systems

Jobbeschreibung

We’re seeking a hand‑on Senior VBA Developer with deep T‑SQL expertise and the ability to read and write MS Access 2003/VBA. You’ll reverse‑engineer and stabilize the legacy SnapShot application, design and build modern SQL‑centric data flows, and implement integrations that connect the current Access front end (on‑prem) + SQL Server back end ERP with the Infor system. The near‑term focus is delivering the first integration, followed by a broader modernization program (S4 migration to follow).

What You’ll Do

• Reverse‑engineer, read, and author MS Access 2003/VBA code; untangle ~100k lines of legacy logic to document workflows and stabilize critical functions.
• Design and implement SQL Server schemas (approx. 500 fields, with ~100 Q&A fields flowing into SnapShot) to support modernized processing.
• Build robust ETL/data ingestion pipelines (e.g., parsing output files and loading into SQL DB for downstream processing); automate validation and reconciliation.
• Integrate with Infor: design interfaces/APIs/bridge tables and orchestrations to pass configuration/estimator data between Access/SQL and the Infor ecosystem.
• Maintain on‑prem performance and reliability: indexing, query tuning, statistics management, isolation levels, and transactional integrity.
• Establish coding standards, version control, and technical documentation for legacy and modern components; implement unit/integration test harnesses.
• Partner with business (estimators, dealers) to map legacy rules to modern data structures; convert tribal knowledge into testable specifications.
• Prepare for the S4 migration (start‑to‑finish planning) by isolating dependencies, defining cutover strategies, and drafting rollback/safety nets.
• Drive secure handling of ERP data (authentication, role‑based access, auditing), and plan for multi‑year on‑prem operation before any cloud move.

Seniority Level

Mid‑Senior level

Employment Type

Contract

Job Function

Information Technology

Industries

IT Services and IT Consulting