Skip to main content

Financial Reporting & Analysis Consultant

Primary Location: Hartford, CT
Additional Locations: CT-Hartford
Our team leads Aetna’s Federal Medical Loss Ratio financial reporting that encompasses gathering, analyzing, and validating large data sets from various financial sources across the enterprise. We’re looking for this role to assist with enhancing data management and analysis, documentation as well as supporting other team projects.

Fundamental Components:
  • Gather and analyze data necessary for the MLR (Medical Loss Ratio) filing processes, including: preparing data reconciliations and using internally developed tools to research and analyze data.
  • Automate, maintain and develop internal reports and other analysis tools in support of the filing review process by leveraging coding and data management background.
  • Assist in managing projects to meet filing deadlines and internal goals.
  • Support audit requests by gathering detailed data, and process and control documents from supporting files.
  • Ability to engage immediately and willingness to lead high profile projects with minimal supervision.

Background Experience:
  • Education or Experience with Relational Databases (SQL Server, MS Access, IBM, or etc.) required.
  • Education or Experience with object-oriented programming (C, Java, VBA, or etc.) required.
  • Bachelor's Degree or Associates w/ Experience required.
  • Computer Science, Actuarial, Data Analysis college majors desired.
  • Financial background/acumen/Insurance Business Knowledge desired.
  • Thrives in fast paced environments, self-motivated

Additional Job Information:
The candidate should possess strong technical and interpersonal skills and be willing to join a fast-paced, high-profile team in the MLR reporting department. The candidate will be responsible for learning and improving Aetna’s MLR reporting activities through automation and tool development while working in conjunction with individuals in accounting, actuarial, legal/compliance, and tax departments among many others.

Required Skills:
General Business - Communicating for Impact, General Business - Turning Data into Information, Technology - Leveraging Technology

Desired Skills:
General Business - Ensuring Project Discipline, Leadership - Collaborating for Results, Leadership - Driving a Culture of Compliance

Functional Skills:
Actuarial - Modeling & tool development, Finance - Financial reporting and analysis, Information Management - Data acquisition, data management, programming and documentation

Technology Experience:
Database - Microsoft Access, Database - SQL Server, Desktop Tool - Microsoft PowerPoint, Desktop Tool - TE Microsoft Excel

Potential Telework Position:

Percent of Travel Required:
0 - 10%

EEO Statement:
Aetna is an Equal Opportunity, Affirmative Action Employer

Benefit Eligibility:
Benefit eligibility may vary by position.

Candidate Privacy Information:
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.


Jobs for you

Recently Viewed Jobs

You do not have any recently viewed jobs

Your Saved Jobs

You do not have any saved jobs

Sign up for Job Alerts

Join our Talent Community

At Aetna, a CVS Health Company, we are pioneering a total approach to health and wellness and we need talented candidates like you to join our team. Become a member of our talent community to be the first to know about career initiatives that match your skills and interests as they become available, in addition to details on upcoming events, networking opportunities, and news about Aetna, a CVS Health Company.

Join Our Talent Community

Sign up to receive information about job openings that are tailored to your skills and interests. Plus, get the latest career news from Aetna, a CVS Health Company.