·
Develop Microsoft Access
Databases, including tables, queries, forms and reports, using standard IT
processes, with data normalization and referential integrity
·
Use Visual Basic in Microsoft
Applications, including Excel, Access, Word, Power-BI and PowerPoint
·
Use Advanced Excel capabilities,
including pivot tables, lookups and complex formulas and graphing to streamline
business processes
·
Develop test plans and software
documentation to support new releases and code modifications
·
Confer with internal customers to
gain understanding of needs
·
Assist other staff with
development activities
·
Participate in code reviews to
ensure best practices and established standards are in use
Skills and Experience Required:
·
2-5 years of applications
programming experience in the Information Systems industry, developing Access
databases using VBA
·
SAS, SQL and Advanced Excel
skills, able to create complex formulas and programming
·
VBA, SAS macros, and database
management
·
Advanced Excel skills, able to
create complex formulas and programming
·
Able to debug/code difficult
functions/macros using VBA
·
Ability to normalize complex data/define
referential integrity in Access
·
Ability to programmatically
manipulate worksheet and cell properties using VBA