Aetna Medicare Reporting Technical Analyst (49780BR) in Blue Bell, Pennsylvania

Req ID: 49780BR

POSITION SUMMARY

To define, develop and provide information, analysis and reporting solutions on Medicare Advantage/Prescription Drug Plan membership to drive the decision-making process and support business operations for internal and external customers. Assists team with CMS Submission of Medicare enrollments, creating complex queries/automated reporting solutions, and business developed applications.

Fundamental Components:

Creates complex reporting projects to support Medicare members enrolled in Medicare Advantage/Prescription Drug plans reporting will involve enrollment/eligibility, disenrollment, custom reporting, submission status for transactions, Low Income Subsidy (LIS) and Late Enrollment Penalty (LEP) member status / processing, etc.

Utilizes strong technical expertise in Oracle, SAS, SQL Server and SSIS packages along with Medicare business to create complex automated technical reporting solutions

Assists with configuration and automation of updates of Medicare members using scripting solutions

Collaborates with resources in peer organizations to meet high priority department objectives.

BACKGROUND/EXPERIENCE desired:

3-5 years of data interpretation and analysis experience, preferably with Medicare Enrollment/Healthcare data.

Experience in one of these Technical areas: Oracle, complex SQL writing, SAS, MS Access, VBA/VB.Net, SQL Server SSIS packages

Excellent verbal and written communication skills.

Demonstrated ability to effectively work on multiple projects simultaneously.

EDUCATION

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

FUNCTIONAL EXPERIENCES

Information Management/Business information analysis/4-6 Years

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

TECHNOLOGY EXPERIENCES

Database/Oracle/1-3 Years/Power User

Development Languages/SQL/4-6 Years/Power User

Reporting Tools/SAS/1-3 Years/Power User

REQUIRED SKILLS

Technology/Selecting and Applying Technology Solutions/ADVANCED

Turning Data into Information/MASTERY

General Business/Applying Reasoned Judgment/ADVANCED

DESIRED SKILLS

General Business/Consulting for Solutions/ADVANCED

Leadership/Developing and Executing Strategy/FOUNDATION

General Business/Communicating for Impact/MASTERY

ADDITIONAL JOB INFORMATION

Working on the Medicare team is a fast paced and challenging position with opportunity to work on major CMS and Aetna initiatives including migration, audits and technical process improvements. 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 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.

#LI-MR1

Job Function: Health Care