Visual Basic Applications Analyst II

Job Summary

We are looking for a highly skilled and experienced MS Access VBA Developer with strong expertise in Microsoft Access application development, VBA scripting, SQL Server integration, and Power BI reporting solutions. The ideal candidate should have hands-on experience in developing enterprise-level database applications, creating dashboards and KPI reports, automating data workflows, and supporting production/database operations.

The candidate should be capable of working independently, handling cross-functional technical support activities, and delivering scalable reporting and database solutions.

Key Responsibilities

• Develop, maintain, and enhance applications using Microsoft Access and VBA.
• Design and write complex queries in MS Access.
• Create and maintain VBA modules, reusable functions, and automation scripts.
• Develop and customize Access Forms, Reports, and Macros.
• Integrate MS Access applications with SQL Server using ODBC connectivity.
• Execute SQL Server Stored Procedures from Access applications.
• Implement robust exception handling, debugging, and logging mechanisms in VBA.
• Develop interactive dashboards, KPI reports, and analytical reports using Power BI.
• Work with Power BI Desktop, DAX, Power Query Editor, and data modeling.
• Create and maintain ETL workflows using SSIS packages.
• Execute SSIS packages through SQL jobs and VBA code automation.
• Support database operations, production deployment activities, and issue resolution.
• Work with BAT files and Windows Task Scheduler for automation processes.
• Collaborate with business users and cross-functional teams to gather requirements and deliver technical solutions.
• Ensure database performance optimization, data integrity, and application reliability.
• Maintain technical documentation and deployment procedures.

Required Skills

MS Access & VBA

• 4+ years of hands-on experience in MS Access VBA development.
• Strong expertise in VBA scripting and automation.
• Experience in designing and writing complex Access queries.
• Experience creating Forms, Reports, Modules, Macros, and Functions.
• Strong knowledge of error handling and debugging techniques in VBA.

SQL Server & Database Skills

• Experience with ODBC SQL Server connections.
• Hands-on experience executing SQL Server Stored Procedures.
• Good knowledge of MS SQL Server and T-SQL.
• Understanding of relational database concepts and performance optimization.

Power BI

• Strong experience in Power BI Dashboard and Report development.
• Experience creating KPI dashboards and analytical reports.
• Hands-on experience with:
• Power BI Desktop
• DAX
• Power Query Editor
• Data Modeling

Additional / Preferred Skills

SSIS (Added Advantage)

• Knowledge of SSIS package development and execution.
• Experience executing SSIS packages via SQL jobs and VBA code.
• Understanding of ETL processes and data integration workflows.

Automation & Scheduling

• Knowledge of BAT file scripting.
• Experience with Windows Task Scheduler automation.

Collaboration & Tools

• Knowledge of SharePoint and MS Forms.
• Familiarity with JIRA ticketing system.

Cloud & Infrastructure

• Basic knowledge of AWS services.
• Knowledge of FTP/SFTP file transfer processes.

Candidate Profile

• Strong analytical and problem-solving skills.
• Ability to work independently and manage multiple tasks.
• Flexible to support production deployments and database operations.
• Ability to provide cross-functional technical support as required.
• Good communication and stakeholder management skills.

Educational Qualification

• Bachelor's Degree in Computer Science, Information Technology, or related field.