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.
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.
LICENSES AND CERTIFICATIONS
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
Leadership/Developing and Executing Strategy/FOUNDATION
Leadership/Driving Strategic and Organizational Agility/ADVANCED
Leadership/Fostering a Global Perspective/FOUNDATION
ADDITIONAL JOB INFORMATION
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