Aetna Informatics Reporting Analyst in Phoenix, Arizona
Req ID: 66491BR
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
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
Database - DTS Data Transfer Service MS SQL Server, Database - Microsoft SQL Server, perienc - Technical_Focus
General Business - Consulting for Solutions, General Business - Turning Data into Information, Leadership - Collaborating for Results
General Business - Communicating for Impact, Leadership - Driving a Culture of Compliance, Technology - Leveraging Technology
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.