Job Description

Job Summary:

We are seeking a

Senior MS Access Developer

with 5-6 years of overall experience in database development and support, including a

minimum of 3-4 years of hands-on experience with Microsoft Access

. The ideal candidate is highly proficient in designing and maintaining complex Access databases, automating processes using VBA, and delivering insightful reports that support business operations and decision-making.

Key Responsibilities:

Design, develop, and maintain scalable and secure

MS Access databases

, tailored to business and operational requirements. Build

custom forms, queries, and reports

using MS Access and SQL for finance, operations, logistics, and other departments. Write and optimize

VBA (Visual Basic for Applications)

scripts to automate data entry, validation, reporting, and other repetitive tasks. Develop and manage

automated reporting workflows

for weekly, monthly, and ad-hoc needs.

Integrate MS Access with Excel, SQL Server, and other systems

for seamless data exchange and dynamic dashboards. Perform rigorous

data validation, cleansing, and integrity checks

to maintain accuracy across all reports and databases. Support legacy database migration efforts and upgrade older MS Access versions to newer environments (2016/2019 or Microsoft 365). Collaborate with cross-functional teams to gather requirements and deliver actionable data insights. Provide documentation and

train end users

on MS Access systems and reports. Troubleshoot and resolve technical issues related to

Access database performance, access, and data quality

.

Required Skills & Qualifications:

5-6 years of total IT experience

, with at least

3-4 years in MS Access development

. Strong command of

MS Access (2013/2016/2019)

including query design, report generation, and data management. Proficient in

VBA for Access

and writing complex SQL queries (joins, subqueries, aggregations). Experience with

reporting and data visualization

using Access reports and Excel (PivotTables, charts, formulas). Familiarity with

SQL Server integration

and data import/export between Access and external systems. Strong problem-solving and troubleshooting skills. Excellent communication skills for gathering requirements and explaining technical concepts to non-technical users.

Preferred Qualifications:

Experience in migrating or consolidating legacy Access applications. Exposure to Microsoft 365/Power Platform is a plus. Ability to work independently and manage multiple projects.
Job Types: Full-time, Contractual / Temporary
Contract length: 3 months

Pay: ?199.41 - ?500.00 per hour

Expected hours: 35 per week

Benefits:

Flexible schedule
Schedule:

Day shift Monday to Friday US shift
Application Question(s):

Expected hour rate
Experience:

Microsoft Access: 4 years (Required)
Work Location: In person