Aetna Access/VBA Programmer in Bismarck, North Dakota

Req ID: 43643BR

Tele Work: Available for current Aetna employees who are currently working at home full-time.


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


Collaborate with Product Owner, Subject Matter Experts (SMEs) and developers to develop procedures, prioritize user stories, define projects, and complete acceptance test criteria in collaboration with product owners and development team. -Work closely with developers and testers to support the agile development process - Perform complex database manipulation. -Perform detailed analysis to ensure all aspects of the business requirement are understood.

Aetna is about more than just doing a job. This is our opportunity to re-shape healthcare for America and across the globe. We are developing solutions to improve the quality and affordability of healthcare. What we do will benefit generations to come.

We care about each other, our customers and our communities. We are inspired to make a difference, and we are committed to integrity and excellence.

Together we will empower people to live healthier lives.

Aetna is an equal opportunity & affirmative action employer. All qualified applicants will receive consideration for employment regardless of personal characteristics or status. We take affirmative action to recruit, select and develop women, people of color, veterans and individuals with disabilities.

We are a company built on excellence. We have a culture that values growth, achievement and diversity and a workplace where your voice can be heard.

Benefit eligibility may vary by position. Click here to review the benefits associated with this position.

Aetna takes our candidate's data privacy seriously. At no time will any Aetna recruiter or employee request any financial or personal information (Social Security Number, Credit card information for direct deposit, etc.) from you via e-mail. Any requests for information will be discussed prior and will be conducted through a secure website provided by the recruiter. Should you be asked for such information, please notify us immediately.

Job Function: Health Care