Aetna Sr Actuarial Consultant/SAS Programmer in Blue Bell, Pennsylvania

Req ID: 36279BR


This position supports the data requirements of Medicare Bids and data reporting requirements of Medicare Actuarial (Individual and Group). We are looking for a motivated individual who enjoys handling data and improving or streamlining manual processes using computer programming.

Fundamental Components:

This position is for a data specialist dedicated to Part C Medicare Advantage Data. The position is technical in nature involving SAS programming, as well as connectivity to SQL and MS Office products.

-Design and code efficiently using SAS -Manage enrollment and experience datasets used in cohort studies and analyses; assist with data refreshes and the creation of monthly reports -Extract data from multiple sources and consolidate in SAS data warehouse; create Microsoft Access databases for use in Medicare bids -Manage generic datasets from central systems, as well as non-system special cases. -Communicate results to Individual and Group Medicare Advantage pricing teams -Research, troubleshoot, and work with experienced analysts on data quality and reconciliation issues. -Assist with annual financial audits of Medicare data, and occasionally with actuarial audits


Bachelors degree in mathematics, computer programming, actuarial science, risk management and insurance, or healthcare administration

2 - 3 years experience of SAS programming in the insurance industry

1 - 2 years experience in actuarial modeling

Access experience is also desired


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


Functional - Information Management/Query and Database Access Tools/1-3 Years


Technical - Desktop Tools//1-3 Years/Power User

Technical - Database/Microsoft Access/1-3 Years/Power User

Technical - Development Experience/Client/Server/1-3 Years/End User


General Business/Turning Data into Information/ADVANCED

Technology/Developing Competitive Technology and Architecture/ADVANCED


General Business/Maximizing Work Practices/ADVANCED

Leadership/Driving Change/FOUNDATION

Telework Specifications:

Option for telework will be evaluated after 3 months of employment.


This is an excellent opportunity for candidates who desire experience in the exciting, growing field of Government-sponsored healthcare products.

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.

Job Function: Actuarial