Clevanoo LLC

Senior VBA Developer

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior VBA Developer on a 12 to 18 month contract, hybrid in Tampa, FL. Key skills include MS Access 2003/VBA, T-SQL, ETL, and SQL Server. Locals with Green Cards or citizenship only.
🌎 - Country
United States
πŸ’± - Currency
$ USD
-
πŸ’° - Day rate
Unknown
-
πŸ—“οΈ - Date
December 18, 2025
πŸ•’ - Duration
More than 6 months
-
🏝️ - Location
Hybrid
-
πŸ“„ - Contract
Unknown
-
πŸ”’ - Security
Unknown
-
πŸ“ - Location detailed
Florida, United States
-
🧠 - Skills detailed
#Version Control #Cloud #VBA (Visual Basic for Applications) #Indexing #Documentation #Data Ingestion #Statistics #Migration #"ETL (Extract #Transform #Load)" #SQL (Structured Query Language) #SQL Server #Data Authentication
Role description
Hello, My name is Mirza Azmat and I am working as Talent Acquisition Manager at Clevanoo.com. We deal with US IT and non-IT recruitment services. We have the below opening with our preferred client, let me know if you are available & interested in this position. If interested, please share a copy of your resume and best number to reach. mirza.a@clevanoo.com Position: Senior VBA Developer Location: Hybrid in Tampa, FL Duration: 12 to 18 Month Contract Locals Green Card and Citizens Only REQUIRED SKILLS 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. Qualifications Role Overview We’re seeking a hands 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). \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Best Regards Mirza Azmat | Manager Talent Acquisition Direct Number: 229-303-2013 Email: mirza.a@clevanoo.com Clevanoo LLC www.clevanoo.com 12864 Leopold Trail, Frisco, Texas 75035 https://www.linkedin.com/in/mirza-azmat-65b35417a/