More jobs:
Job Description & How to Apply Below
Location Toronto - Hybrid (4 Days WFO)
Duration 6 Months
Pay Range C $53 INC
Required Skills MS-Access
VBA
SQL
Python scripting
Job Overview We are seeking a skilled MS Access Frontend Developer to design, develop, and maintain database applications using Client Access. The ideal candidate will have strong expertise in VBA programming, SQL querying, and Python scripting to create efficient, user-friendly frontend solutions that integrate seamlessly with backend databases.
Key Responsibilities Design and develop MS Access frontend applications with intuitive user interfaces (forms, reports, and navigation).
Write and optimize VBA code to automate business processes, data validation, and application logic.
Develop complex SQL queries, stored procedures, and views to retrieve, manipulate, and manage data.
Integrate MS Access applications with external data sources (SQL Server, Excel, APIs, etc.).
Troubleshoot and resolve application bugs, performance issues, and user-reported problems.
Collaborate with business analysts and stakeholders to gather requirements and deliver solutions.
Document application architecture, code, and user guides for maintenance and training purposes.
Ensure data integrity, security, and compliance with organizational standards.
Create and maintain Python scripts for data processing, automation, and integration tasks.
Qualifications MS Access proficiency in designing forms, reports, queries, and macros.
VBA (Visual Basic for Applications) strong programming skills for automation and business logic implementation.
SQL advanced knowledge of SQL querying, database design, normalization, and optimization.
Python experience with Python for data manipulation, scripting, and integration.
Strong understanding of relational database concepts and data modeling.
Experience with MS SQL Server or other relational databases is a plus.
Ability to troubleshoot and debug complex issues in Access applications.
Excellent problem-solving, analytical, and communication skills.
Familiarity with API integration and web services (REST, SOAP).
Understanding of version control systems (Git) and Dev Ops tools.
Experience in finance, healthcare, or enterprise environments is a plus.
#J-18808-Ljbffr
Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
Search for further Jobs Here:
×