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 chronic and end stage renal disease (ESRD) and other databases using SAS and/or ORACLE as the primary platform. Work with senior staff to complete the monthly, quarterly, and yearly updates of the KECC databases.
Maintain the databases by completing the following: 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, and work with the programming supervisor and research analysts to determine data reporting requirements.
Work with senior programmers to assist in the design of new systems or modifications to existing systems and assess alternative solutions. Analyze and explore new data sources to assess their appropriateness. Create analytical files involving the integration of data from many sources.
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.
Provide data and technical support to analysts by assisting with the creation and finalization of the project deliverables, such as data and measure reports in PDF, Excel, Microsoft Word and other various documentation formats. Provide additional support by uploading, downloading, and processing data. May contribute to research papers and manuscripts for publication and presentation at conferences and workshops.
Bachelor's degree in computer science, statistics, economics, health policy, social science, or a related field or equivalent experience.
Three to five years of experience with systems analysis/programming activities.
SAS experience required in Windows or Linux/Unix environment.
Excellent communication skills, both oral and written. Attention to detail. The ability to work as part of a team and/or individually, while meeting deadlines in a multi-tasking environment.
Experience with analysis of Medicare data for End-Stage Renal Disease patients. Data management experience with large databases.
Proven experience developing and managing large relational databases from multiple data sources, including building table relationships and establishing documentation to ensure regular database updates.
Programming documentation, testing, validation, and reporting experience in a production-oriented environment.
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.
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.