Aetna HDMS Informatica / SAS Programmer Lead in Beachwood, Ohio

Req ID: 53906BR


About HDMS: Health Data & Management Solutions, Inc. (HDMS), a subsidiary of Aetna, is a software development company on the cutting edge of health IT data solutions. Offering data warehouse, management and analysis tools for the healthcare industry, HDMS strives to improve and enhance its product suite for health plans, employers and providers through constant innovation. HDMS' web-based products and services provide flexible, high-value reporting tools that empower users to maximize the value of their health care data and support benefit decisions.

The Informatics Consultant Lead role is responsible for data operations accounts for large employer clients. .

Fundamental Components:

  • Responsible for the technical aspects of the system development and implementation process.

  • Design, build, test, document and maintain SAS based solutions on Linux/Windows for multiple clients.

  • Responsible for monthly and quarterly database updates and new client implementations with competing deadlines. This role will also support special projects such as platform and server migrations, efficiency initiatives, etc.

  • Ensure project delivery deadlines are met. Provide ongoing support for application system.

  • Develop and maintain complex routine macros.

  • Coordinate with other internal development teams as needed to complete projects.

  • Maintain standard programs and utilities to process healthcare claims data and prepare the data for analytical reporting.

  • Work with internal Client Service Managers and directly with clients to determine DART (a web-based, analytical healthcare reporting tool) reporting needs and address data quality issues.

  • Strong communication, speaking, writing and organizational skills are required. Ability to explain analytical scenarios and questions to team members and external parties in non-technical, non-analytical roles.


  • 3+ years of experience utilizing statistical software: SAS on LINUX Platform using textpad editor, SAS/BASE. SAS/MACRO. Languages: SAS, PL/SQL, Operating Systems: Windows, LINUX; ETL Tools: Informatica Power Center. MS Office: Excel, Word, Powerpoint, and use of Source control software such as Vault. Experience with Informatica IDQ, IBM BigIntegrate, DataStage, and BigQuality is considered a plus.

  • 3+ years of systems analysis and application program development experience in health care/health insurance domains. Solid understanding of Medical Claims, Pharmacy Claims, Disability Claims, Benefits Enrollment, Disease Management and Health Risk Assessment Data.


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

    Preferred areas of studies; Data Science, Computer Science or Mathematics.


    General Business/Maximizing Work Practices/MASTERY

    Leadership/Driving a Culture of Compliance/FOUNDATION


  • This is an office based position in either Chicago, IL or Beachwood, IL

    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 candidates'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

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.