Aetna Informatics Cnslt/Lead in New Albany, Ohio

Req ID: 51539BR


Leads the successful delivery of complex analyses and reporting solutions to meet business needs. Interacts directly with internal customers and colleagues in the development of reporting and analytic solutions. May act as a project lead or mentor for complex projects involving multiple resources and tasks.

Fundamental Components:

Collaborates with internal partners and organizations in the design and execution of reporting solutions and analytic studies to support business needs.

Develops, validates and executes complex queries, develops complex reports and performs complex data analysis that answers business questions for internal customers; interprets results, and makes recommendations to business areas based on findings.

Makes recommendations about data collection methods, metrics definitions and evaluation methods.

Turns data into actionable information through reporting solutions.

Troubleshoots technical details / issues.

Presents analysis and reports to internal customers and stakeholders.

May mentor other analysts.


5 or more years experience using advanced SQL and SAS programming abilities in data warehouse environment AND/OR advanced reporting tool development skills using Excel, Access, VBA and/or Tableau and/or Power BI.

Experience in working in a data warehouse environment and/or the ability to work with large data sets from multiple data sources.

Knowledge of analytic programming tools and methods and reporting platforms.

Understanding of relational databases, data systems and data warehouses.

Demonstrated project management experience.

Demonstrated extensive and diverse knowledge of health care data, metrics, systems and standards; demonstrated subject matter expertise in multiple subject areas.

Ability to communicate technical ideas and results to non-technical clients in written and verbal form.

Strong collaboration and communication skills within and across teams.

Strong problem solving skills and critical thinking ability.

Ability to manage conflicting priorities and multiple projects concurrently.


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


Functional - Information Management/Business information analysis/4-6 Years

Functional - Information Management/Data acquisition, data management, programming and documentation/4-6 Years


General Business/Consulting for Solutions/FOUNDATION

General Business/Turning Data into Information/ADVANCED

Technology/Leveraging Technology/ADVANCED


Leadership/Collaborating for Results/FOUNDATION

Technology/Promoting Emerging Technology/FOUNDATION

Telework Specifications:

Telework arrangements may be considered for selected candidates who currently telework.


The Clinical Operations Reporting team is staffing multiple positions to develop a team with a blend of skillsets, including data query specialists (with SAS/SQL experience) and report development specialists (with Tableau, Power BI, Excel/Access/VBA experience). The positions will be either PRF3 or PRF4, depending on the skills and experience of selected applicants. Please refer also to the PRF4 (Sr level) job posting.

The positions are not location-specific and can be staffed in a variety of locations.

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