Access / VBA Programmer

Aetna   •  

Bismarck, ND

Industry: Managed Care & Health Insurance


5 - 7 years

Posted 346 days ago


Resource serves as a centralized expert within accounts receivable. This resource would be a primary point of contact to be used for requirements, documentation, process flows, new client implementations, database creation and support, as well as identify efficiency and strategic opportunities while collaborating with other business teams.

Fundamental Components:

Performs analysis and translates business needs to create high-quality Business Requirements and Functional Specifications documentation within specified time frames to solve complex problems (multiple interfaces with other systems within a business unit) considering all impacted components from an end-to-end perspective.

Competent to work with minimal supervision in a technical capacity on most phases of the system analysis. Guides and advises less-experienced Business Analysts and system users. Develops Functional test plans and User Acceptance test plans and scenarios.

Coordinates Functional and User Acceptance Testing by developing and executing the testing strategy, scheduling resources and facilities, and tracking test performance.

Conducts impact analysis of technology changes on business processes and existing technology. Conducts interviews, fact-finding, and independent research to design creative, progressive IT solutions for business problems.

Facilitates collaborative system and data design sessions with the user community and development resources. Develops and maintains access databases. Develops system workflow diagrams. Facilitates the design and mapping of data conversion strategies.

Develops Product Overviews, FAQs, Tool Glossaries, and system user documentation to support implementation activities. Applies specific functional and/or business expertise to perform assigned tasks and develop specific project deliverables.

Completes project activities on time and within budget, and proactively identifies and communicates issues that may jeopardize milestones or project budget to the Project Manager.


Extensive experience in developing system requirements, complex access databases (VBA programming), documentation, process flows and supporting new client implementations. Proven track record of collaboration with other business teams.


The highest level of education desired for candidates in this position is a Bachelor's degree or equivalent experience.


Project Management/Lean Six Sigma is desired
Information technology/Microsoft Office-Access Database VBA is desired
Information technology/Access Users Group (All Chapters) is desired


Functional - Project Management/Cross-functional project management/1-3 Years
Functional - Project Management/Intra-department project management/1-3 Years
Functional - Information Technology/Project management/1-3 Years
Functional - Information Technology/Testing/1-3 Years


Technical - Database/Microsoft Access/4-6 Years/Power User
Technical - Desktop Tools/TE Microsoft Excel/4-6 Years/Power User
Technical - Reporting Tools/SAS/1-3 Years/End User
Technical - System Management/Technical Troubleshooting/1-3 Years/Power User


General Business/Maximizing Work Practices/ADVANCED
General Business/Turning Data into Information/ADVANCED
Technology/Leveraging Technology/FOUNDATION


Leadership/Developing and Executing Strategy/FOUNDATION
Leadership/Driving Strategic and Organizational Agility/ADVANCED
Leadership/Fostering a Global Perspective/FOUNDATION