Skip to main content

Senior Informatics Analyst

Primary Location: Hartford, CT
Additional Locations: CT-Hartford, IL-Chicago
Under general supervision, conducts analyses or produces reports in direct support of the Medicare Advantage Strategy and Performance Management team. This team manages the overall Individual Medicare Advantage strategy which has seen tremendous growth in the last few years. This role will be highly visible and will work on projects that support VP, Medicare Advantage and Executive Director, Performance Management. The team currently provides production and adhoc reporting utilizing SAS and Tableau to support the business as well as maintaining a SQL server database for reporting purposes.

Hartford, CT and Chicago, IL are the preferred locations, but the candidate can work in any Aetna location.

Fundamental Components:
  • Performs analyses of varied data to support the Medicare Advantage Individual business in regards to bid planning and competitive analysis.
  • Designs and codes efficiently using SAS/SQL programs.
  • Creates reports using Tableau.
  • Assists in maintaining data and infrastructure of the SQL server database environment owned by the team.
  • Extracts data from multiple sources and creates integrated analytic datasets and creates reports and studies to address business and research questions.
  • Develops, validates and executes algorithms to solve business problems.
  • Conducts periodic updates of analytical routines and department production systems.
  • Investigates and evaluates alternative solutions to meeting business needs.
  • Participates in presentations and consultations to constituents on information services, capabilities and performance results.
  • Documents methods, specifications and findings clearly; contributes to writing and presentation of results, findings and conclusions.
  • Creates and evaluates the data needs of assigned projects and assures the integrity of the data.
  • Manages personal resources efficiently to complete assigned projects accurately and on time.
  • Participates in the development of project plans and timelines.
  • Responsible for commitments to quality and on-time deliverables.
  • Motivated and is willing to understand and probe into technical details and data irregularities.
  • Contributes to a motivated work environment by working effectively to achieve common goals.

Background Experience:
  • Demonstrated written and verbal communication skills.
  • Able to present information to various audiences.
  • 3+ years of relevant programming or analytic experience.
  • Healthcare industry experience is preferred.
  • Knowledge of other reporting platforms such as: Business Objects, Microsoft Access, web development technology, big data analytics, data mining, Visual Basic.
  • Understanding of relational databases, data systems and data warehouses.
  • Experience in database management.
  • Knowledge of analytic programming tools and methods (SAS, SQL, OLAP).Deep knowledge of health care industry, policy, research design.
  • Experience working in a data warehouse environment as well as the ability to work with large data sets from multiple data sources.
  • Strong SQL, SAS programming skills (e.g., SAS Base, SAS STAT, SAS Macros), and Tableau visualizations.
  • Demonstrated analytical and problem-solving skills.
  • Bachelor's degree in Mathematics, Economics, Statistics, Computer Science, Actuarial Science, Social Science, Healthcare or related discipline.

Required Skills:
General Business - Applying Reasoned Judgment, General Business - Communicating for Impact, General Business - Demonstrating Business and Industry Acumen, General Business - Turning Data into Information

Functional Skills:
Information Management - Data acquisition, data management, programming and documentation, Information Management - Informatics, Information Technology - Data / info management & architecture

Technology Experience:
Database - Microsoft SQL Server, Reporting Tool - Base SAS, Reporting Tool - SAS MACRO

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.