Aetna Informatics Analyst- SQL in Phoenix, Arizona
Req ID: 65621BR
Under general supervision, conducts analyses or produces reports of varied healthcare data to assess health and economic outcomes of Aetna products and programs.
Fundamental Components included but are not limited to:
Performs analyses of varied healthcare data to evaluate programs and product solutions using healthcare medical, pharmacy, lab, survey and utilization data.
Designs and codes efficiently using SQL programs.
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 and predictive models to solve business problems.
Executes univariate and multivariate statistical analyses and interprets results in the context of the business problem or question.
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.
Qualifications Requirements and Preferences:
Demonstrated written and verbal communication skills.
Able to present information to various audiences.
3+ years of relevant programming or analytic experience.
Healthcare or pharmaceutical 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 statistical analysis and database management.
Knowledge of analytic programming tools and methods (SQL, Business Objects, Crystal).
Deep knowledge of health care industry, policy, research design, univariate and multivariate statistical analyses, predictive modeling, case-mix and risk adjustment methods and tools.
Experience in working in a data warehouse environment as well as the ability to work with large data sets from multiple data sources.
Strong knowledge of health care claims, products, and systems.
Solid Understanding of complex databases and UNIX or mainframe environments.
Demonstrated analytical and problem-solving skills.
Bachelor's degree in Mathematics, Economics, Statistics, Computer Science, Actuarial Science, Social Science, Healthcare or related discipline.
Claim - Reporting & special services, General Management - Data analysis & interpretation, General Management - Data tools: building & utilization, Information Technology - Data / info management & architecture
Database - SQL Server, EDI - EDI, Subject Discipline - Business Process Management
General Business - Turning Data into Information, Service - Providing Solutions to Constituent Needs, Technology - Selecting and Applying Technology Solutions
General Business - Communicating for Impact, General Business - Demonstrating Business and Industry Acumen, Service - Working Across Boundaries
Additional Job Information:
Fast paced environment
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.