How to Apply
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.
Job Summary
The Office of Medical Student Education (OMSE) is seeking an Education Database Administrator to join our Evaluation & Assessment (E&A) Unit. This position will be key to ensuring our education program data are properly stored, documented, and accessible to support both operational needs and research across OMSE, particularly those related to assessment (e.g. online quizzes and exams), curriculum evaluation (e.g. course and teaching evaluations), learner recruitment and residency match outcomes, program quality improvement, and medical education scholarship. The Data Manager will be responsible for organizing, coordinating, and sharing data across the E&A unit portfolio, including data depicting medical student feedback and learner academic trajectory performance across the medical school curriculum. This position will work to automate various data pipelines as well as produce reports summarizing learner engagement, experience, and academic trajectory. This position will report to the Director of Evaluation & Assessment.
Why Join Michigan Medicine?
Michigan Medicine is one of the largest health care complexes in the world and has been the site of many groundbreaking medical and technological advancements since the opening of the U-M Medical School in 1850. Michigan Medicine is comprised of over 30,000 employees and our vision is to attract, inspire, and develop outstanding people in medicine, sciences, and healthcare to become one of the world?s most distinguished academic health systems. In some way, great or small, every person here helps to advance this world-class institution. Work at Michigan Medicine and become a victor for the greater good.
What Benefits can you Look Forward to?
- Excellent medical, dental and vision coverage effective on your very first day
- 2:1 Match on retirement savings
Responsibilities*
1. Manage data. Inspect, clean, and transform data. Run database queries and provide datasets to E&A team members, OMSE leadership, and unit partners.
2. Design and maintain large data sets. Merge files, restructure and recode variables, assign labels and values, check for errors, create codebooks, create and update data set documentation, and other related technical tasks.
3. Apply systems knowledge to inform business intelligence. Help project teams understand the range of data available to inform the design and development of educational experiences/projects, program evaluation, and scholarship.
4. Use and apply continuous quality improvement approaches to education data systems. Develop, streamline, error-proof, and automate processes for managing data and producing reports
5. Contribute to academic operations and unit scholarship. Prepare and present reports to OMSE teammates, faculty educators and innovators, and academic governance and accreditation committees.
6. Manage and review data access. Act as a consultant between E&A and various outside stakeholders, including research partners, making sense of partner data needs and facilitating secure access to data sets.
7. Support user experience. Provide support for end-users of software applications and learning experiences to explain data collection practices and specific data variables.
8. Institutional Committees and Service. Participate with UMMS Data Governance committees and contribute to development of standardized data definitions across the medical education continuum.
Required Qualifications*
- A bachelor's degree in computer science, data science, or a related field of study or a bachelor?s degree in another field of study with substantial experience in data management.
- Two-to-three years of related database design and implementation experience.
- Experience constructing queries within relational databases (e.g., Oracle, MS SQL Server, PostgreSQL, MySQL).
- Experience with database development environments and data integration/virtualization /ETL tools (e.g., SQL Developer, SQL Server Management Studio (SSMS), Informatica, Pentaho, Toad Data Point, Denodo).
- Experience with data reporting, analytics, business intelligence tools (e.g., Tableau, Power BI, Oracle BI, Looker, SAP Business Objects, SQL Server Reporting Services (SSRS)).
- Demonstrated ability to be self-directed, work independently with specific deadlines and responsibilities, and contribute as a member of an integrated, collaborative team.
- Demonstrated ability to be flexible and problem-solve within a complex organization.
- Ability to accurately and effectively communicate technical details with non-technical researchers and business leaders.
Desired Qualifications*
- Experience working in a multidisciplinary educational environment with multiple stakeholders (faculty, staff, students).
- Experience with decentralized databases/data warehouses.
- Experience building PeopleSoft queries.
- Experience with programming languages such as Python or R, artificial intelligence, machine learning techniques, and/or natural language processing.
- Experience with various statistical analysis techniques, such as analyses of variance, factor analysis, reliability analyses, statistical process control, linear and hierarchical modeling, etc.
Modes of Work
Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.
The Office of Medical Student Education operates in a hybrid work environment consisting of both in-person and remote work. This position will be classified as a flex position. Onboarding and training will primarily take place in-person. Thereafter, the selected staff member will work with the Director of Evaluation & Assessment in order to determine the most effective hybrid work schedule to support individual professional development, growth in position, and unit stakeholders.
Background Screening
Michigan Medicine conducts background screening and pre-employment drug testing on job candidates upon acceptance of a contingent job offer and may use a third party administrator to conduct background screenings. Background screenings are performed in compliance with the Fair Credit Report Act. Pre-employment drug testing applies to all selected candidates, including new or additional faculty and staff appointments, as well as transfers from other U-M campuses.
Application Deadline
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.
U-M EEO Statement
The University of Michigan is an equal employment opportunity employer.