The SAS Programmer/Analyst II will collaborate in a number of epidemiological and health services research projects in the Department of Population Medicine. The SAS Programmer/Analyst II will be a member of the Research Support Data Center (RSDC), and will be in charge of data specifications, technical design, data management, programming and statistical analysis, and results reporting for several simultaneous research projects. This person will utilize a variety of technical tools and software to develop programs and utility applications, and manipulate and analyze data in a variety of Unix and PC environments. S/he will provide analytic expertise to investigators and study teams, and share knowledge with other members of RSDC.
Duties and Responsibilities:
Responsible for data management and analysis tasks on multiple epidemiological research projects for internal and external customers. Depending on the nature of the project, may work with a project team that includes many levels of staff, or may work independently with the investigator. Supports all aspects of the project, including work plan development, project design, developing SAS programs, data problem identification and resolution and results reporting.
Develop, design, clean, manage, and analyze data from all corporate systems using Unix and PC software. In addition to utilizing corporate databases, will also utilize data developed from surveys, chart reviews, PC databases, and the electronic systems of DPM’s eternal research partners.
Develop working knowledge of and facility in accessing data structure and contents of all Harvard Pilgrim Health Care (HPHC) and other data sources including: clinical information systems, automated medical records, hospital claims, outpatient claims, pharmacy, enrollment and benefits data.
Develop working knowledge of technical and software tools required to access, utilize and analyze data from all HPHC and other applicable systems environments. Assimilate and learn new technical tools, software and data systems to accommodate continuous changes in technical environment.
Independently document project tasks and specifications. Responsible for managing project work according to work plan, and for successful completion of project goals within project timeline using effective time-management skills. Identify and recommend alternative data/methods to meet project needs in most efficient way.
Utilize knowledge of epidemiologic and health services research concepts and methods in daily work.
Participate in systems development projects (such as the corporate data warehouse or DPM shared tools library) through systems and data analysis, application development, system testing and debugging, as needed.
Bachelor’s degree in related field (i.e. computer programming, public health, statistics)
5-7 years of practical experience programming or conducting analyses in a health care environment or related field, or an equivalent combination of education and experience.
Excellent computer skills, including database management and proficiency in statistical software (proficient knowledge of SAS and SQL required).
Prior experience retrieving, manipulating and analyzing data on UNIX computer systems. Working knowledge of TERADATA and SQL
Knowledge of personal computer applications (word-processing, spreadsheet, database management, graphics)
Demonstrated ability to learn new technical tools and software applications, and work with variety of data and data sources
Ability to utilize basic project planning skills, concepts and tools, including relevant software.
Demonstrated ability to work on projects with multiple investigators simultaneously.
Knowledge of study design, research methodology, statistical analysis, and data management.
Excellent interpersonal, oral, and written communication skills.
Demonstrated ability to work both independently and as part of a team.