Aetna Sr. Reporting Ops. Analysts / VBA Developer in Chantilly, Virginia

Req ID: 52399BR


As a member of a leading Healthcare Organization, you will use skills to analyze and provide insights to support business decision-making and to improve and automate processes and tasks as well as streamline performance monitoring. This involves extracting, collecting, analyzing and interpreting data to address business questions and to help automate processes to obtain such data. The goal is to improve our capability to measure, analyze and monitor processes to improve performance. Your strong analytical, programming, organizational and communication skills will help you work effectively in our fast pace environment alongside a team of talented individuals.

We are currently seeking a highly motivated Senior Reporting /Operation Analysis / VB Developer to join our fast-paced team in the Virginia/Chantilly office or in our North Carolina/High Point office to take the role of Sr. Analyst and VBA/dashboard and automation developer.

This position will be responsible for collecting, providing and analyzing data as well as improving processes and tasks using Excel, Excel Macros, VBA, VB.Net, Crystal Reports (XI), SQL and other platforms used to collect, transform, process and automate data.

Fundamental Components:

Creating automated processes using VBA, VB.NET and enhancing existing processes and tasks.

Designing graphs, dashboards and visual management tools using excel, VBA, VB.Net and Xcelsius.

Update and maintain files and datasets using VBA, VB.Net, Macros, XML.

Studying business requirements, developing code, implementing functions and testing automation.

Creating and maintaining files, user and technical documents.

Performing extensive data analysis and evaluations.

Presenting analyses to Sr. Management both verbally and in writing.


  • 5+ years of Business Analytic and Excel/VBA programming experience.

  • Strong problem solving, analytical, and project management skills.

  • Demonstrated extensive and diverse knowledge of Excel Macros, VBA, VB.Net, XML, SAP Dashboard development or other platforms.

  • Able to make sound decisions and recommendations to drive business solutions, good business acumen.

  • Must have very strong communication skills; ability to communicate findings and results of analyses in written and verbal form.

  • Excellent business acumen skills

  • Strong collaboration skills with the ability to work effectively with all levels of management and staff.

  • Strong problem solving skills and critical thinking ability.

  • Advanced Excel Macros, VBA, VB.Net, XML programming abilities in data analytics environment, including use of analysis techniques or business intelligence applications.

  • Knowledge of analytic programming tools and methods (SAP, SQL, OLAP, Business Objects, Crystal).

  • Strong reporting skills using Excel, Access, Word and/or PowerPoint.

  • Strong understanding of workflows, processes and key performance indicators.

  • Ability to evaluate/recommend the use of other reporting platforms to solve constituent needs: Business Objects, Microsoft Access and Visual Basic.

  • Proficient experience with Data Mining, Data Queries and Dash Board Reporting.

  • Tableau experience is preferred.

  • Xcelius Dashboard deliver experience is preferred.


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


    Leadership/Driving a Culture of Compliance/FOUNDATION

    Technology/Leveraging Technology/FOUNDATION

    Technology/Promoting Emerging Technology/FOUNDATION


  • This is an office based position for either Chantilly, VA or High Point, NC. There is no relocation package.

  • This is a full-time position.

    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 candidates'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