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 senior staff 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.
Maintain the database 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.
Under direction of the programming supervisor, work with the programming team 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 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.
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 using SAS, or similar tools, for data management and/or statistical analysis.
Proven experience developing and managing relational databases of significant size, including building table relationships and establishing documentation to ensure regular database updates.
Previous experience developing web applications with Python or similar tools.
Three to five years of experience 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.
This is a one-year term-limited, benefits-eligible position with the possibility of extension for subsequent years.
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 are performed in compliance with the Fair Credit Reporting Act.
Job openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.
The University of Michigan is an equal opportunity/affirmative action employer.
Internal Number: 188624
About University of Michigan - Ann Arbor
A great university is made so by its faculty and staff, and Michigan is recognized as one of the best universities to work for in the country. The Michigan culture is known for engaging faculty and staff in all facets of the university to create a workplace that is vibrant and stimulating.For two consecutive years, the Chronicle of Higher Education has placed U-M in its "Great Colleges to Work For" survey. In particular, the university earns high marks for strong relations between faculty and administrators, a collaborative system of governance, strong pay and benefits, and a healthy work/life balance.