Developer – MS Access & SQL

Toronto - Canada

Monthly Salary: CAD 10 - 10

Experience Required: 5years

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Skills Required: MS Access

Job Description:

MS Access JD Technical Skills 4 years of hands-on experience with MS Access including database design forms tables queries and reports.

Proficient in VBAVB with the ability to debug and code complex functions macros.

Experience with ActiveX controls COM SQL procedures DAO ADO and SQL Server databases.

Excel Integration skilled in creating and managing MS Excel macros and programmatically manipulating worksheet and cell properties us-ing VBA.

System Upgrades experience with MS Access upgrades and Windows Server configu-ration.

Domain Knowledge Understanding of Securities Derivatives PL settlement and PL reporting.

Responsibilities

Gather functional and application data requirements from cus-tomers.

Develop and provide data analysis solutions using Microsoft Access.

Support up-grades for MS Office and MS Access.

Communicate effectively with all stakeholders.

Inte-grate best practices in application development data visualization and process flows.

Utilize external databases like SQL to create comprehensive analysis solutions.

Generate various re-ports as required.

Develop and maintain process documentation.

MS ACCESS Database RE-SOURCE FOR Senior Data Engineer Must-have

Experience with SQL Server Back-End de-velopment including: SQL Scripts Stored-Procedures Dynamic Stored-Procedures

Experience development Python scripts and libraries

Experience with Agile development GitHub SSMS Dataiku

Experience working with databases such as SQL Server HDFS

Experience with DBMS Data Modelling ERD Data Pipelines and DQ rules Implementation

Experience to Imple-ment complex logic from Business Requirements using both SQL Stored Procedures and/or Python

Experience to produce Architecture Design and Technical documents for all Layers such as Front-End UI API End Points and Back-End Stored Procedures.

Nice-to-have

Experience ETL Work Flow and Python/SQL and Dataiku Recipes using Dataiku Platform

Experience designing front-end solu-tions with OpenShift API End-Points (APIGEE)

Experience with HR systems & workflow management tools such as Workday SAP ServiceNow

Experience developing Tableau Dashboard and reusable Work Books.

Good knowledge of API Endpoints development using Python Language.

Exp Required: 10

Required Skills:

Experience (Years): 8-10

Skills Required: MS AccessJob Description: MS Access JD Technical Skills 4 years of hands-on experience with MS Access including database design forms tables queries and reports.Proficient in VBAVB with the ability to debug and code complex functions macros.Experience with ActiveX controls COM SQL p...