Universal Technologies
Microsoft Access User Interface and Database Designer
Universal Technologies, Albany, New York, us, 12237
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.
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.