ResearchFox Consulting logo

Senior Access & SQL Data Engineer/Specialist

10 years

0 Lacs

india

Posted:1 day ago| Platform: Linkedin logo

Apply

Skills Required

sql data ai strategy migrate algorithms server azure vba code reliability sharepoint reports macros database versioning backup restore regression testing documentation usability content design indexes reconciliation rollback etl adf analytics power management vault security joins api tuning odbc analysis indexing strategies migration checks engineering packaging communication devops git powershell dax governance programming python

Work Mode

Remote

Job Type

Full Time

Job Description

Title: Senior Access & SQL Data Engineer/Specialist



Team:AI Strategy & Transformation team

Location:

Experience:


Role Overview

We are looking for highly versatile, pragmatic individual to join our AI Strategy & Transformation team as a hands-on engineer who pairs deep Microsoft Access/VBA expertise with strong SQL data engineering. You’ll take day-to-day ownership of a mission-critical Access application, help migrate data and algorithms to SQL Server and Azure Synapse, and supporting other initiatives within that environment.

migrate core data stores and selected algorithms from SharePoint/Access to SQL Server

Responsibilities (Access database)

  • Own day-to-day operations of the Access app (front end + back end): forms, queries, reports, macros, and advanced VBA (class modules, error handling, logging).
  • Diagnose/optimize existing code; refactor for performance and maintainability; reduce technical debt.
  • Manage linked tables (within a SQL database in our Azure environment), implement pass-through queries, and tune for performance.
  • Establish disciplined SDLC for Access: versioning (ACCDE builds), backup/restore, regression testing, change logs, documentation, and release checklists.
  • Improve usability of forms and workflows for content managers.


Responsibilities (

  • Design and implement SQL Server / Azure SQL schemas, indexes, views, stored procedures, and UDFs to replace/augment Access data stores and calculations.
  • Plan and execute migrations of capabilities into SQL Server with reconciliation, validation, and rollback strategies.
  • Build/operate ELT/ETL with Azure Synapse and/or ADF; parameterize/orchestrate, monitor, and alert.
  • Collaborate with analysts/data scientists to deliver high-quality, well-documented datasets for analytics/BI (e.g., Power BI).
  • Contribute to secure data practices (RBAC, secrets management/Key Vault, row-level security where applicable).


Skills/Qualifications (must-have)

  • Microsoft Access expert: complex queries (joins, crosstabs), multi-form architectures, advanced VBA (API/ADO/DAO, performance tuning, robust error handling), pass-through queries, ODBC optimization.
  • SQL expert: strong T-SQL, execution-plan analysis, indexing strategies, window functions, set-based design, stored procedures/UDFs.
  • Data migration experience (SharePoint/Access → SQL Server/Azure SQL) with parity checks and rollback.
  • Engineering discipline: backups, release packaging, documentation, and change control for a business-critical system.
  • Communication: extremely clear written and spoken English in a must.
  • Data capable: strong data/numeracy is very important in order to understand and work with the complex data and algorithms in our environment.



Skills/Qualifications (nice-to-have)

  • Azure Synapse, Azure SQL Database/MI, Azure Data Factory; Azure DevOps/Git; PowerShell for automation.
  • Power BI exposure (datasets/models/DAX basics).
  • Data quality frameworks, metadata/cataloguing (e.g., Purview).
  • Experience with Data Governance (Quality, Lineage, Data dictionary, and Security).
  • Proficiency in programming languages such as Python for data engineering tasks.



  • How You Work

    :
  • Highly organized, self-starting, extremely methodical and conscientious, and able to manage complex projects.
  • Experience supporting and working with cross-functional teams in a dynamic environment.



More Jobs at ResearchFox Consulting

User Experience Researcher

India

10.0 - 10.0 yrs
|

Salary: Not disclosed

Jr. Project Manager/PMO

Bengaluru, Karnataka, India

Experience: Not specified

|

Salary: Not disclosed

Sales Ops Head

bengaluru, karnataka, india

15.0 - 15.0 yrs
|

Salary: Not disclosed

Senior Access & SQL Data Engineer/Specialist

india

10.0 - 10.0 yrs
|

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Google Play App Store
coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
ResearchFox Consulting logo
ResearchFox Consulting

RecommendedJobs for You

ResearchFox Consulting logo

Senior Access & SQL Data Engineer/Specialist

ResearchFox Consulting

india

ResearchFox Consulting logo

Senior Access & SQL Data Engineer/Specialist

ResearchFox Consulting

india