Aetna Senior Reporting Analyst in Hartford, Connecticut06132

Req ID: 40882BR

POSITION SUMMARY

To create and deliver disruption reports for the sales team to support the RFP process. This is accomplished by formatting external data feeds and comparing them to standardize Aetna provider data

Fundamental Components:

Create disruption reports for sales team by formatting data from external sources and comparing them to standard Aetna provider data.

Documents and archives each request in compliance with Aetna policy.

Conducts reasonability check.

Provides input into presentation of information product to customer.

Creates queries using MS ACCESS for formatting data to run disruption analysis and to create custom summaries.

Communicates with sales teams to determine needs, discuss solutions, timing of delivery of disruption reports.

BACKGROUND/EXPERIENCE desired:

3+ years of data interpretation and analysis experience.

Working knowledge of Microsoft Excel is required

Strong organizational skills required

Working knowledge of MS ACCESS and ability to create queries, joining tables and exporting/importing data preferred

Working knowledge of Microsoft Office products (Word, PowerPoint, Outlook) & Internet Explorer preferred

Familiarity with databases and comfortable generating reports preferred

EDUCATION

The minimum level of education desired for candidates in this position is a High School diploma, G.E.D. or equivalent experience.

FUNCTIONAL EXPERIENCES

Functional - Products-Medical/All Aetna Standard Plans/1+ Years

Functional - Products-Dental/All Aetna Dental Products/1+ Years

TECHNOLOGY EXPERIENCES

Technical - Mainframe Tools and Software/TSO Edit/1+ Years/End User

Technical - Database/Crystal Analysis/1+ Years/End User

Technical - Reporting Tools/Base SAS/1+ Years/End User

Technical - Database/Microsoft Access/1+ Years/End User

REQUIRED SKILLS

General Business/Applying Reasoned Judgment/FOUNDATION

General Business/Communicating for Impact/ADVANCED

General Business/Turning Data into Information/ADVANCED

DESIRED SKILLS

General Business/Maximizing Work Practices/ADVANCED

Service/Working Across Boundaries/FOUNDATION

Technology/Leveraging Technology/FOUNDATION

Telework Specifications:

Option for part time telework / office based schedule will be considered after a certain period of employment. Must live near Hartford office.

ADDITIONAL JOB INFORMATION

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

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