"Education Database Administrator Intermediate"

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.

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.

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.

Preferred 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.

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.

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 employment opportunity employer.