Senior Access

Remote

About Us

We empower enterprises globally through intelligent, creative, and insightful services for data integration, data analytics and data visualization.

Hoonartek is a leader in enterprise transformation, data engineering and an acknowledged world-class Ab Initio delivery partner.

Using centuries of cumulative experience, research and leadership, we help our clients eliminate the complexities & risk of legacy modernization and safely deliver big data hubs, operational data integration, business intelligence, risk & compliance solutions and traditional data warehouses & marts.

At Hoonartek, we work to ensure that our customers, partners and employees all benefit from our unstinting commitment to delivery, quality and value. Hoonartek is increasingly the choice for customers seeking a trusted partner of vision, value and integrity

How We Work?

Define, Design and Deliver (D3) is our in-house delivery philosophy. It's culled from agile and rapid methodologies and focused on 'just enough design'. We embrace this philosophy in everything we do, leading to numerous client success stories and indeed to our own success.

We embrace change, empowering and trusting our people and building long and valuable relationships with our employees, our customers and our partners. We work flexibly, even adopting traditional/waterfall methods where circumstances demand it. At Hoonartek, the focus is always on delivery and value.

Job Description

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 (SQL & Azure)

• 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).

Job Requirement

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.