DATABASE ANALYST I
- Employer
- Duke University
- Location
- Durham, NC
View more
- Administrative Jobs
- Technology, Database Administration
- Employment Type
- Full Time
- Institution Type
- Four-Year Institution
Job Details
DATABASE ANALYST I
Basic Science Admin
Database Analyst - OBGE
Occupational Summary:
The Data Analyst will work within the Office of Biomedical Graduate Education (OBGE) in the School of Medicine at Duke University and report to the Director of OBGE. This position will oversee, coordinate, and monitor the design, development, modification, and implementation of information technology applications and databases; provide leadership, project management, design tools, and technical support for the management of the database environment; provide training and technical support for staff to achieve effective and efficient utilization of database resources; and arrange secure data warehousing. Data Analyst will be experienced with database structure and design, data procurement/management and analysis, and querying and manipulating data for use in data reporting and statistical analysis processes needed internally for OBGE/School of Medicine and externally by other Duke and non-Duke entities. This position will also be responsible for Abacus (student tracking/data collection app), working with the OBGE team and other stakeholders to develop databases and data management processes for course and program assessments, programming, outcomes research, curating, and analysis systems.
Work Performed:
Interface with Duke student/faculty/institutional data systems (PeopleSoft, DFac, SPS, Scholars@Duke, and related systems) to support the data needs for graduate and postdoctoral training proposals and programs across the institution: Develop queries that extract trainee, faculty, research staff, publication, and funding information from Duke systems (central and local) and external sources. Develop database/data collection/management strategies to securely store data and keep it current. Build custom queries from existing databases; extract and organize data from various data sources for use in training grant data tables, survey responses, and other reporting requirements. Provide data/develop secure reporting for departments as requested. 50%
Serve as project manager and main administrator for OBGEs Abacus application; serve as liaison with OIT, DHTS, ORI and software development engineers regarding troubleshooting, updates, changes, and project work flow; maintain list serve or other email communication for end-users; assist with analysis of data that may exist in non-integrated systems previously used by trainee programs. Manage data associated with Abacus and provide reporting and analysis as needed.
Work with Duke school, center/institute, and departmental resources to guide development of applications, databases, and other data-related systems, as needed.
Contribute to development of a graduate student/postdoc alumni outcomes database. Interface with Graduate School, the Office of Postdoctoral Services, and other entities working to systematize trainee outcomes tracking.
Develop visual representations of training and OBGE-related data for use in publications, communications, board presentations, etc.
Create/maintain existing documentation for new and/or existing process.
Required Skills:
Work requires demonstrated experience in PeopleSoft or other similar technical environments and in relational database concepts and use of SQL query tools for data mining, research, and ad hoc reporting. Must have excellent interpersonal skills and possess ability to work in a collaborative, dynamic team environment.
Preferred Skills:
Experience in higher education is a plus.
Excellent knowledge of relational database design and technologies and of database analysis.
Experience with complex data environments, including an understanding of the interaction among different enterprise systems.
Thorough knowledge of reporting methodologies in an SQL environment.
Experience with all aspects of unit testing, performance testing and user acceptance testing.
Experience with data visualization tools such as Tableau, pivot tables, or pivot charts.
Education/Training:
Work requires a bachelor's degree in a data science related field or the equivalent training and/or experience in statistics, data analysis, data management.
Requisition Number
401513469
Location
Durham
Duke Entity
MEDICAL CENTER
Job Code
2291 DATABASE ANALYST I
Job Family Level
12
Exempt/Non-Exempt
Exempt
Full Time / Part Time
FULL TIME
Regular / Temporary
Regular
Shift
First/Day
Minimum Qualifications
Duke University is an Affirmative Action/Equal Opportunity Employercommitted to providing employment opportunity without regard to anindividual's age, color, disability, gender, gender expression, genderidentity, genetic information, national origin, race, religion, sex,sexual orientation, or veteran status.
Duke aspires to create a community built on collaboration, innovation,creativity, and belonging. Our collective success depends on the robustexchange of ideas—an exchange that is best when the rich diversity ofour perspectives, backgrounds, and experiences flourishes. To achievethis exchange, it is essential that all members of the community feelsecure and welcome, that the contributions of all individuals arerespected, and that all voices are heard. All members of our communityhave a responsibility to uphold these values.
Essential Physical Job Functions:Certain jobs at Duke University and Duke University Health System mayinclude essential job functions that require specific physical and/ormental abilities. Additional information and provision for requests forreasonable accommodation will be provided by each hiring department.
Education
Work requires a bachelor's degree in mathematics, computer science, ora computer-related field or the equivalent coursework or technicaltraining.
Experience
Work requires 2 years of progressive programming or databaseadministration experience to include design, implementation, tuning,backup, recovery, modification and reorganization of relationaldatabases for a complex computer network.OR AN EQUIVALENT COMBINATION OF RELEVANT EDUCATION AND/OR EXPERIENCE
Auto req ID
106460BR
Duke University is an Affirmative Action/Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, genetic information, gender, gender expression, gender identity, national origin, race, religion, sexual orientation, or veteran status.
Essential Physical Job Functions: Certain jobs at Duke University and Duke University Health System may include essential job functions that require specific physical and/or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.
PI107055801
Organization
History
Duke University was created in 1924 by James Buchanan Duke as a memorial to his father, Washington Duke. The Dukes, a Durham family that built a worldwide financial empire in the manufacture of tobacco products and developed electricity production in the Carolinas, long had been interested in Trinity College. Trinity traced its roots to 1838 in nearby Randolph County when local Methodist and Quaker communities opened Union Institute. The school, then named Trinity College, moved to Durham in 1892, where Benjamin Newton Duke served as a primary benefactor and link with the Duke family until his death in 1929. In December 1924, the provisions of indenture by Benjamin’s brother, James B. Duke, created the family philanthropic foundation, The Duke Endowment, which provided for the expansion of Trinity College into Duke University.
As a result of the Duke gift, Trinity underwent both physical and academic expansion. The original Durham campus became known as East Campus when it was rebuilt in stately Georgian architecture. West Campus, Gothic in style and dominated by the soaring 210-foot tower of Duke Chapel, opened in 1930. East Campus served as home of the Woman's College of Duke University until 1972, when the men's and women's undergraduate colleges merged. Both men and women undergraduates now enroll in either the Trinity College of Arts & Sciences or the Pratt School of Engineering. In 1995, East Campus became the home for all first-year students.
Duke maintains a historic affiliation with the United Methodist Church.
Home of the Blue Devils, Duke University has about 13,000 undergraduate and graduate students and a world-class faculty helping to expand the frontiers of knowledge. The university has a strong commitment to applying knowledge in service to society, both near its North Carolina campus and around the world.
Mission Statement
"James B. Duke's founding Indenture of Duke University directed the members of the University to 'provide real leadership in the educational world' by choosing individuals of 'outstanding character, ability, and vision' to serve as its officers, trustees and faculty; by carefully selecting students of 'character, determination and application;' and by pursuing those areas of teaching and scholarship that would 'most help to develop our resources, increase our wisdom, and promote human happiness.'
“To these ends, the mission of Duke University is to provide a superior liberal education to undergraduate students, attending not only to their intellectual growth but also to their development as adults committed to high ethical standards and full participation as leaders in their communities; to prepare future members of the learned professions for lives of skilled and ethical service by providing excellent graduate and professional education; to advance the frontiers of knowledge and contribute boldly to the international community of scholarship; to promote an intellectual environment built on a commitment to free and open inquiry; to help those who suffer, cure disease, and promote health, through sophisticated medical research and thoughtful patient care; to provide wide ranging educational opportunities, on and beyond our campuses, for traditional students, active professionals and life-long learners using the power of information technologies; and to promote a deep appreciation for the range of human difference and potential, a sense of the obligations and rewards of citizenship, and a commitment to learning, freedom and truth.
“By pursuing these objectives with vision and integrity, Duke University seeks to engage the mind, elevate the spirit, and stimulate the best effort of all who are associated with the University; to contribute in diverse ways to the local community, the state, the nation and the world; and to attain and maintain a place of real leadership in all that we do.”
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert