Education Database Administrator

About This Role

This role involves managing, inspecting, cleaning, and transforming education program data to ensure proper storage, documentation, and accessibility. The position supports operational needs and research across the Office of Medical Student Education, contributing to assessment, curriculum evaluation, and program quality improvement.

Responsibilities

• Manage, inspect, clean, and transform data, run database queries, and provide datasets to E&A team members, OMSE leadership, and unit partners.
• Design and maintain large data sets, including merging files, restructuring and recoding variables, assigning labels and values, checking for errors, and creating codebooks and documentation.
• Apply systems knowledge to inform business intelligence, helping project teams understand available data for designing educational experiences, program evaluation, and scholarship.
• Develop, streamline, error-proof, and automate processes for managing data and producing reports using continuous quality improvement approaches.
• Prepare and present reports to OMSE teammates, faculty educators, innovators, and academic governance and accreditation committees.
• Act as a consultant between E&A and outside stakeholders, facilitating secure access to data sets and making sense of partner data needs.
• Provide support for end-users of software applications and learning experiences to explain data collection practices and specific data variables.
• Participate with UMMS Data Governance committees and contribute to the development of standardized data definitions across the medical education continuum.

Requirements

• Bachelor's degree in computer science, data science, or related field, or bachelor's with substantial data management experience
• 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

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.

Nice to Have

• 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

Skills

* Required skills

Benefits