A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interest in the position and outline skills and experience that directly relate to this position.
Development and maintenance of the KECC databases using SAS and/or ORACLE as the primary platform.
Work with others to complete the monthly, quarterly, and yearly updates of the KECC ESRD database, which is a comprehensive historical database of more than 3 million ESRD patients drawn primarily from Medicare data.
Analyze multiple input data sources for changes in format or content as part of the database production process. Plan and carry out modifications to the database and related software to accommodate these changes.
Prepare sets of standard analysis files including Medicare claims and other data sources.
Work with the programming Leads, Supervisor, and research analysts to determine data reporting requirements.
Design new systems or modifications to existing systems and assess alternative solutions.
Analyze and explore new data sources to assess their appropriateness for meeting these needs.
Prepare detailed system documentation, including data dictionary tools (in MS-Access or similar software), and researchers guides.
Prepare and carry out detailed testing plans to verify the proper operation of the systems and to validate the data in the databases. Opportunities to participate in all phases of the research process through publication.
Bachelor's degree in computer science, statistics, economics, health policy, social science, or a related field or equivalent experience.
Five to seven years of experience using SAS for data management and statistical analysis.
Proven experience developing and managing relational databases of significant size, including building table relationships and establishing documentation to ensure regular database updates.
Five to Seven years of building databases from multiple data sources.
Experience with Medicare or other insurer claims databases.
Statistical training or experience, including survival analysis.
Experience in technical and research writing.
ORGANIZATION: The Kidney Epidemiology and Cost Center (KECC) carries out research in epidemiology, public policy, economics, outcomes research relating to End-Stage Renal Disease (ESRD), chronic kidney disease, and organ transplantation (http://www.kecc.sph.umich.edu/). KECC maintains a comprehensive historical database of over 3 million ESRD patients drawn primarily from Medicare data.
KECC’s computer system includes multiple servers, a gigabit LAN, almost 4 terabytes of disk storage, and a wide variety of peripheral devices. SAS and Oracle are the primary data management and analysis systems used by KECC. About 60 faculty and staff members work all or part of their time at KECC.
We are seeking an experienced and dynamic staff (leader/member) with a commitment to contributing to a diverse, equitable and inclusive environment for all members of our community.
The University of Michigan conducts background checks on all job candidates upon acceptance of a contingent offer and may use a third party administrator to conduct background checks. Background checks will be performed in compliance with the Fair Credit Reporting Act.
The University of Michigan is an equal opportunity/affirmative action employer.