View All Jobs/Careers

Job Information

Aetna Informatics Reporting Analyst in Phoenix, Arizona

Req ID: 66491BR

Job Description

Position is responsible for analytical reporting of encounter data in the Medicaid business unit. In this role the candidate will develop reports using SQL programs; extracting and analyzing data from multiple sources with findings documented via reports, graphs etc

Fundamental Components included but are not limited to:

In support of the Medicaid Encounter Department, the candidate will be responsible for:

  • Design and efficiently coding reports using SAS/SQL programs

  • Extracting data from multiple sources, creating integrated analytic datasets for standard and ad hoc reports which will be used to address business and research questions.

  • Creating and evaluating the data needs for any assigned projects and will assure the integrity of the data.

  • Identifying trends, root cause and short / long term systematic solutions to resolve encounter data errors and prevent future instances.

  • Create stored procedures and/or macros used in daily reporting

  • Interacting with internal and external business partners

Qualifications Requirements and Preferences:

  • 3-5 years of relevant programming or analytic experience.

  • Healthcare or pharmaceutical industry experience is preferred.

  • Strong knowledge of health care claims, products, and systems.

  • Experience in working in a data warehouse environment as well as the ability to work with large data sets from multiple data sources.

  • Strong SQL and SAS programming skills (e.g., SAS Base, SAS STAT, SAS Macros)

  • Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business Objects, Crystal).

  • Experience in statistical analysis and database management.

  • Understanding of relational databases, data systems and data warehouses.

  • Demonstrated analytical and problem-solving skills.

  • Solid Understanding of complex databases and UNIX or mainframe environments.

  • Deep knowledge of healthcare industry, policy, research design, univariate and multivariate statistical analyses, predictive modeling, case-mix and risk adjustment methods and tools.

  • Demonstrated written and verbal communication skills.

  • Able to present information to various audiences.

  • Knowledge of other reporting platforms such as: Business Objects, Microsoft Access, web development technology, big data analytics, data mining, Visual Basic

Functional Skills:

Information Management - Business information analysis, Information Management - Query and Database Access Tools, Information Management - Statistical and data model designs, Information Technology - Data / info management & architecture, Project Management - Issue identification and analysis

Technology Experience:

Database - DTS Data Transfer Service MS SQL Server, Database - Microsoft SQL Server, perienc - Technical_Focus

Required Skills:

General Business - Consulting for Solutions, General Business - Turning Data into Information, Leadership - Collaborating for Results

Desired Skills:

General Business - Communicating for Impact, Leadership - Driving a Culture of Compliance, Technology - Leveraging Technology

Benefit Eligibility

Benefit eligibility may vary by position. Click here to review the benefits associated with this position.

Job Function: Healthcare

Aetna is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected Veterans status.