Skip to main content

A new day in healthcare. Together, CVS Health and Aetna help people on their path to better health.

Analytics & Programmer Consultant

Primary Location: Blue Bell, Pennsylvania
Additional Locations: AZ-Phoenix, CO-Denver, CT-Hartford, FL-Jacksonville, FL-Miami, FL-Orlando, FL-Plantation, FL-Tampa, KS-Wichita, MI-Detroit, MI-Grand Rapids, MO-Kansas City, OK-Oklahoma City, PA-Blue Bell, UT-Salt Lake City
This position is located in the National Care Management Quality Department and is responsible for the successful delivery of HEDIS, accreditation and regulatory analyses & reporting. The position will have a technical emphasis in the development of HEDIS improvement projects, requiring end-to-end support throughout the projects lifecycle. Leads the successful delivery of analyses and analytic solutions to meet business needs, interacting directly with internal and external clients and colleagues. May act as analytic team lead or mentor for complex projects involving multiple resources.

Fundamental Components:

Primary responsibility will be to pull and analyze complex data for trends, draw conclusions, and provide in-depth root cause analyses. Collaborate with Regional and National QM clinical teams to develop reporting tools and
production reports, including: create ad hoc data warehouse queries; implement strategies to pull data to meet work group objectives; and works to resolve systems and data integrity issues. These activities require advanced technical,
analytic and consultative skills, as well as an extensive knowledge of health care data and information systems.

Performs applied statistical research and custom analysis of integrated healthcare data, interprets results, and makes recommendations based on analytic findings to business areas.
Makes recommendations about data collection methods, metrics definition and evaluation methods.
Presents analytic reports to clients and stakeholders.
Defines and delivers analytical solutions in support of healthcare business initiatives that drive short and long term objectives.

Collaborates with internal and external partners and organizations in the design and execution of analytic studies to answer business and research questions.
Designs and conducts analyses and outcome studies using healthcare claims, pharmacy and lab data, employing appropriate research designs and statistical methods.
Develops, validates and executes algorithms, statistical models and reporting tools that answer applied research and business questions for internal and external clients. Develops and participates in presentations and consultations to existing and prospective constituents on information services, capabilities and performance results.

Stays informed about industry trends, research findings and evaluation methods.
Turns analysis into business/customer solutions.
Creates business applications to deliver clinical or analytic solutions to constituents Manages personal resources efficiently to achieve constituent satisfaction.
Responsible for project commitments to quality and on-time deliverables.

Ability to manage conflicting priorities and multiple projects concurrently
Willingness to understand and probe into technical details. Contributes to a motivated work environment by working effectively to achieve common goals. Creates and evaluates the data needs of assigned projects and assures the integrity of the data. Under general direction, independently executes analyses or reports to meet project needs. May mentor other analysts.

Background Experience:

5+ years of relevant programming or analytic experience. *Intermediate/Advanced
SSMS or Base SAS programming abilities in Hadoop and/or big data analytics environment.
Strong reporting skills using SSMS, SSRS and SSIS. *Demonstrated extensive and diverse knowledge of health care data, metrics, systems and standards; demonstrated subject matter expert in multiple subject areas.

Strong problem solving skills and critical thinking ability.
Strong collaboration and communication skills within and across teams.
Strong reporting skills using Excel, Access, Word and/or PowerPoint.
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.
Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business Objects, Crystal).
Experience in working in a data warehouse environment as well as the ability to work with large data sets from multiple data sources.

Demonstrated project management and/or team lead experience.
Health care analysis, health economics, epidemiology, or health services research experience.
Ability to communicate statistical and technical ideas and results to non-technical clients in written and verbal form.
Able to make sound decisions and recommendations to drive business solutions.

Additional Job Information:
position is an excellent opportunity to develop advanced SQL and SAS
programming abilities in Hadoop or big data analytics environment, including
use of statistical analysis techniques or business intelligence application
development. This will also provide opportunities in multiple Business Line
Platforms - Commercial, Medicare (SNP and DSNP) and Medicaid.

Required Skills:
General Business - Applying Reasoned Judgment, Technology - Selecting and Applying Technology Solutions, Technology - Developing Software Solutions

Desired Skills:
General Business - Consulting for Solutions, General Business - Ensuring Project Discipline, Technology - Justifying the Business Case

Functional Skills:
Information Management - Data acquisition, data management, programming and documentation, Information Management - Data Warehousing, Information Management - Informatics, Information Management - Query and Database Access Tools

Technology Experience:
Aetna Application - HEDIS, Aetna Application - QNXT, Development Language - SQL, Reporting Tool - SAS

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. Click here to review the benefits associated with this 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

Click To Review Our Benefits (PDF)


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, 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.

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.