Senior SQL Developer(VBA)

Senior SQL Developer(VBA)

Posted 1 day ago by 1766051406

Negotiable
Outside
Remote
USA

Summary: We are seeking a hands-on Senior SQL Developer with deep T-SQL expertise and strong experience in MS Access 2003/VBA. This role will focus on stabilizing and reverse-engineering a legacy Access-based application, designing SQL-centric data flows, and delivering integrations between an on-prem Access/SQL Server ERP and modern enterprise systems.

Key Responsibilities:

  • Develop, optimize, and maintain complex T-SQL stored procedures, functions, and data models in SQL Server.
  • Read, modify, and extend MS Access 2003 applications using VBA.
  • Reverse-engineer and stabilize legacy Access/SQL Server solutions.
  • Design and implement ETL/data ingestion pipelines, including file parsing, data loading, validation, and reconciliation.
  • Build and support system integrations, including initial integration with the Infor platform.
  • Support near-term integration delivery and contribute to longer-term ERP modernization initiatives (including future S/4 migration).

Key Skills:

  • Senior-level, hands-on SQL Server development with advanced T-SQL expertise.
  • Strong experience with MS Access 2003 and VBA.
  • Proven experience building ETL/data ingestion pipelines and automating data quality checks.
  • Experience with system integrations and data exchange between legacy and modern platforms.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: Senior

Industry: IT

Detailed Description From Employer:

Job Title: Senior SQL Developer(VBA)

Interview: Virtual

Job Location: Remote

Job Duration: C2H



Note: No sponsorship



We are seeking a hands-on Senior SQL Developer with deep T-SQL expertise and strong experience in MS Access 2003/VBA. This role will focus on stabilizing and reverse-engineering a legacy Access-based application, designing SQL-centric data flows, and delivering integrations between an on-prem Access/SQL Server ERP and modern enterprise systems.



Key Responsibilities:

  • Develop, optimize, and maintain complex T-SQL stored procedures, functions, and data models in SQL Server.
  • Read, modify, and extend MS Access 2003 applications using VBA.
  • Reverse-engineer and stabilize legacy Access/SQL Server solutions.
  • Design and implement ETL/data ingestion pipelines, including file parsing, data loading, validation, and reconciliation.
  • Build and support system integrations, including initial integration with the Infor platform.
  • Support near-term integration delivery and contribute to longer-term ERP modernization initiatives (including future S/4 migration).



Required Skills:

  • Senior-level, hands-on SQL Server development with advanced T-SQL expertise.
  • Strong experience with MS Access 2003 and VBA.
  • Proven experience building ETL/data ingestion pipelines and automating data quality checks.
  • Experience with system integrations and data exchange between legacy and modern platforms.