Connvertex Technologies Inc.
Senior VBA Developer, ERP, Database Modernization
Connvertex Technologies Inc., Tampa, Florida, us, 33646
Client Name: Kforce
Job Title:
Senior VBA Developer - ERP / Database Modernization
Location:
Tampa FL (Local needed)
Work Type:
Hybrid
Job Type:
Contract (12-18 Months)
Rate:
$70 / hour on W2
Interview Type:
Video
Clear unhidden copy of the visa copy needed.
As of July 22 2021 our team will require that all candidate submissions include a LinkedIn profile. Please do not submit any candidates that do not have a LinkedIn with picture.
Job Description 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).
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.
Required Skills
MS Access 2003/VBA
T‑SQL and SQL Server
ERP/database modernization
ETL and data ingestion pipelines
On‑prem SQL performance tuning
Infor integrations
Employment Type:
Full Time
Experience:
years
Vacancy:
1
#J-18808-Ljbffr
Job Title:
Senior VBA Developer - ERP / Database Modernization
Location:
Tampa FL (Local needed)
Work Type:
Hybrid
Job Type:
Contract (12-18 Months)
Rate:
$70 / hour on W2
Interview Type:
Video
Clear unhidden copy of the visa copy needed.
As of July 22 2021 our team will require that all candidate submissions include a LinkedIn profile. Please do not submit any candidates that do not have a LinkedIn with picture.
Job Description 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).
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.
Required Skills
MS Access 2003/VBA
T‑SQL and SQL Server
ERP/database modernization
ETL and data ingestion pipelines
On‑prem SQL performance tuning
Infor integrations
Employment Type:
Full Time
Experience:
years
Vacancy:
1
#J-18808-Ljbffr