ANALYST PROGRAMMER II
ANALYST PROGRAMMER II
Population Health Sciences
OCCUPATIONAL SUMMARY: Develop, update, and maintain SAS programs to meet the data management, reporting, data characterization, validation and quality assessment and other statistical programming needs of the Duke Department of Population Health Sciences. The DPHS Analyst Programmer II has an understanding of electronic health data, health insurance claims data, clinical registry data, healthcare coding algorithms, distributed research networks, research data standards and reporting, data visualization, as well as familiarity with application of good clinical data management practices. The DPHS Analyst Programmer II designs and maintains programs, datasets, software tools and reports, including visualization, of large medical claims and electronic health record databases. Close collaboration with other disciplines and departments within and across Duke and external organizations is necessary. Demonstrates strong attention to detail, excellent communications skills, as well as talent, motivation and commitment for working with complex data and computing environments in support of the DPHS DataShare and research initiatives.
- Design, code, test, debug, execute and document SAS programs for surveillance, data characterization, validation and quality assessment, analysis dataset creation, data analysis, data conversion/transfer, graphic production and project reporting (50%)
- Programming, testing, debugging and documentation for transforming large Medicare claims datasets into a common data model (ETL) within the CMS Virtual Research Data Center (VRDC) for the FDA's Sentinel drug and medical device surveillance initiative. Design and execute internal quality checks, run Sentinel Security Operations Center (SOC) QA packages and document and communicate detailed responses to error reports. Maintain all required SOC documentation for ETL specifications and tracking, QA and SAS programs.
- Respond to scheduled and ad hoc requests from the Sentinel SOC to execute query programs and deliver results for surveillance, data characterization, validation, and quality assessment.
- Assist in analyzing statistical programming needs in project proposals and guide project personnel in formulating appropriate data requirements; recommend optimum approach and develop SAS programs for approved projects.
- Consult on and provide direct technical support for research projects of high complexity and often requiring solutions not previously utilized by project team or work group.
- Process and load electronic health data and maintain large, observational databases in the DPHS DataShare to support a wide array of internal department, across Duke and external research studies (15%)
- Perform complex, integrated computer programming and software development for clinical data applications (including maintenance of existing systems and research/development for future enhancements) (10%)
- Develop and maintain a working knowledge of statistical principles and analyses considerations taken into account during planning of health services research.
- Develop software tools to support DPHS DataShare and research infrastructure and ongoing research studies (10%)
- Develop tools for organizing and searching healthcare coding algorithms for diseases, outcomes, procedures and drugs.
- Maintain and apply a strong working knowledge of healthcare coding algorithms, clinical research informatics and healthcare analytics techniques.
- Collaborate with staff, faculty and sponsors on study objectives, analysis and database planning (10%)
- Work with all members of the project team on a regular basis to meet project deliverables.
- Provide technical instruction and training to other analyst programmers and users (preparing training materials as necessary) (5%)
- Prepare training materials and give presentations to statisticians and other users; interface with and serve as liaison to clients regarding special requests and operational issues as they arise.
- Perform other related duties incidental to the work described herein.
The above statements describe the general nature and level of work being performed by individuals assigned to this classification. This is not intended to be an exhaustive list of all responsibilities and duties required of personnel so classified.
REQUIRED QUALIFICATIONS AT THIS LEVEL
Education/Training: Work requires Bachelor's degree in mathematics or computer science or a computer-related field or equivalent coursework or technical training. Strong Base SAS, SAS/Macro, and SAS/Graph skills required.
Experience: Work requires two years of progressive SAS programming experience in a clinical environment. Experience in health services research environment, especially distributed data network strongly preferred. Experience working with observational data and with large healthcare datasets including EHR, Medicare, or other healthcare claims datasets preferred. OR AN EQUIVALENT COMBINATION OF RELEVANT EDUCATION AND/OR EXPERIENCE
Skills: Oracle, Microsoft Access, SQL, R, scripting languages (eg, Python, Visual Basic), Web development and Unix skills preferred.
1040 ANALYST PROGRAMMER II
Job Family Level
Full Time / Part Time
Regular / Temporary
Duke University is an Affirmative Action/Equal Opportunity Employercommitted to providing employment opportunity without regard to anindividual's age, color, disability, gender, gender expression, genderidentity, genetic information, national origin, race, religion, sex,sexual orientation, or veteran status.
Duke aspires to create a community built on collaboration, innovation,creativity, and belonging. Our collective success depends on the robustexchange of ideas—an exchange that is best when the rich diversity ofour perspectives, backgrounds, and experiences flourishes. To achievethis exchange, it is essential that all members of the community feelsecure and welcome, that the contributions of all individuals arerespected, and that all voices are heard. All members of our communityhave a responsibility to uphold these values.
Essential Physical Job Functions:Certain jobs at Duke University and Duke University Health System mayinclude essential job functions that require specific physical and/ormental abilities. Additional information and provision for requests forreasonable accommodation will be provided by each hiring department.
Work requires a Bachelor's degree in mathematics or computer scienceor a computer-related field or equivalent coursework or technicaltraining.
Work requires two years applications programming experience with someresponsibility for systems design and supervision or projectcoordination.OR AN EQUIVALENT COMBINATION OF RELEVANT EDUCATION AND/OR EXPERIENCE
Auto req ID
Duke University is an Affirmative Action/Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, genetic information, gender, gender expression, gender identity, national origin, race, religion, sexual orientation, or veteran status.
Essential Physical Job Functions: Certain jobs at Duke University and Duke University Health System may include essential job functions that require specific physical and/or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.