Aetna Medicare Reporting Technical Analyst (49780BR) in Blue Bell, Pennsylvania
Req ID: 49780BR
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.
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.
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.
The highest level of education desired for candidates in this position is a Associate's degree or equivalent experience.
Information Management/Business information analysis/4-6 Years
Information Management/Query and Database Access Tools/1-3 Years
Database/Oracle/1-3 Years/Power User
Development Languages/SQL/4-6 Years/Power User
Reporting Tools/SAS/1-3 Years/Power User
Technology/Selecting and Applying Technology Solutions/ADVANCED
Turning Data into Information/MASTERY
General Business/Applying Reasoned Judgment/ADVANCED
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.
Job Function: Health Care