Microsoft Access User Interface and Database Designer

UNIVERSAL Technologies is seeking a Microsoft Access User Interface and Database Designer for a hybrid role in Albany, NY. While the role is currently remote, candidates should be prepared to work onsite in Albany if a hybrid arrangement is required in the future. This is a short-term project. LinkedIn account is required.
Position:
The MS Access User Interface and Database Designer will be responsible for developing and maintaining user-friendly Microsoft Access interfaces and back-end databases to support internal team operations. The ideal candidate will have extensive experience with Visual Basic for Applications (VBA) programming, ensuring data integrity, and providing technical support for the use of the MS Access system. This role requires close collaboration with internal stakeholders to ensure that the technological solutions meet business needs.
WHO WE ARE:

UNIVERSAL Technologies, LLC is a Women-Owned (M/WBE) IT solutions and consulting company focused on delivering enterprise systems that significantly improve our clients' IT performance. We work across the IT spectrum, including Development, Business/Systems/Data Analysis, Project Management, Cyber Security, Network Engineering, and High-Level System Architecture.
The pride in the services we provide and the accessibility and flexibility we offer to employees are what make Universal Technologies stand out! We aim to propel your IT career to the next level and excite our employees with new and challenging projects.
WHAT WE OFFER:
Our W2 employees can expect the following benefits:

• Competitive pay
• Health/Dental Insurance
• Group Life Insurance
• 401K
• HSA/FSA
• Pre-Tax Transportation Program
• Generous Paid Time Off/Holiday Policy

Education and Experience:

• A minimum of a bachelor's degree in data science, computer science, or a related discipline.
• At least 3 years of related experience, including the creation and maintenance of Microsoft Access user interfaces and back-end databases.
• An equivalent combination of advanced education, training, and experience will be considered.

Key Responsibilities:

• Develop and implement a user-friendly Microsoft Access user interface and back-end database for internal team use.
• Maintain and update the user interface and back-end database based on team requirements and enhancements to improve user experience.
• Effectively document MS Access database processes and architecture.
• Ensure data integrity by performing database back-ups and monitoring.
• Perform database quality verification checks to ensure proper functioning of MS Access database.
• Provide technical assistance and support related to the database usage to end users.
• Stay up to date with Microsoft Access best practices and industry trends.

Required Qualifications:

• Extensive proven experience creating and maintaining Microsoft Access user interfaces and back-end databases.
• Strong knowledge of Access forms, reports, queries, VBA programming, and advanced Excel skills.
• Experience utilizing VBA in the creation and maintenance of Microsoft Access user interfaces for databases.
• Experience writing ad hoc advanced queries in SQL.
• Experience integrating Microsoft Access with other Microsoft Office Applications (e.g., Excel, Outlook).
• Strong business analytic and professional communication skills.
• Strong critical thinking, problem-solving, and analytical skills.
• Proficiency with translating complex analytic ideas into actionable insights for varied levels of audience.
• Ability to work independently and collaboratively in a team environment.

Preferred Qualifications:

• Understanding of data management in relation to intaking and storing data via the user interface and ensuring data is available for analysis.
• Ability to work in a remote capacity, as well as in the office setting.
• Experience in a healthcare or healthcare-related field.
• Experience developing reports based on collected data.
• Experience with automation of emails and notifications utilizing Microsoft Access and other products (Word, Outlook, Excel, Adobe Acrobat).

UNIVERSAL Technologies is an Equal Opportunity Employer.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.