DATABASE ANALYST I

Duke University:

Duke University was created in 1924 through an indenture of trust by James Buchanan Duke. Today, Duke is regarded as one of America’s leading research universities. Located in Durham, North Carolina, Duke is positioned in the heart of the Research Triangle, which is ranked annually as one of the best places in the country to work and live. Duke has more than 15,000 students who study and conduct research in its 10 undergraduate, graduate and professional schools. With about 40,000 employees, Duke is the third largest private employer in North Carolina, and it now has international programs in more than 150 countries.

POSITION SUMMARY: 

Reporting to the Senior Business Systems Analyst, the database analyst is responsible for creating or maintaining queries in PeopleSoft to extract data for use in data pipelines and reporting requests. The role will assist in the coordination and monitoring of the design, development, modification and implementation of student record systems within the University.

DUTIES & WORK PERFORMED: 

Student Information Systems (PeopleSoft, Perceptive Content and related systems): 55%

Assist in the implementation of new or existing workflow/webservices processes for school administrative offices, (e.g., Academic Affairs, Finance, Graduate Student Affairs, Admissions, Dean’s Office, and Liberal Studies).

Participate in planning with SISS, Registrar, OIT personnel, and other offices as needed to ensure smooth operation of graduate student PeopleSoft modules and assist in troubleshooting of issues.

Serve as a technical resource to TGS staff, graduate programs, and other SISS data-related personnel working in administrative offices.

Assist with PeopleSoft upgrades, including training of staff, revision of existing queries and reports, testing changes and enhancements, etc.

Data Queries and Reports: 35%
Create and modify parameter-driven reports in an enterprise reporting platform to extract data related to admissions, enrollment, student records and financial reporting.

Provide consultation and training sessions to report users.

Other Duties: 10%

Ensure that external and internal regulations and policies governing data management are met including regulations concerning security, auditability and privacy.

Serve as backup for the Graduate School network administrator in maintaining computer hardware and office equipment.

Perform other related duties incidental to the work described herein.

Education

Work requires a bachelor's degree in mathematics, computer science, or a computer related field or the equivalent coursework or technical training.

Experience

Work requires 2 years of progressive programming or database OR AN EQUIVALENT COMBINATION OF RELEVANT EDUCATION AND/OR EXPERIENCE administration experience to include design, implementation, tuning, backup, recovery, modification and reorganization of relational databases for a complex computer network.

Job Code: 00002291 DATABASE ANALYST I
Job Level: 12

Duke is an Affirmative Action/Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, gender, gender expression, gender identity, 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 robust exchange of ideas—an exchange that is best when the rich diversity of our perspectives, backgrounds, and experiences flourishes. To achieve this exchange, it is essential that all members of the community feel secureand welcome, that the contributions of all individuals are respected, and that all voices are heard. All members of our community have a responsibility to uphold these values.

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.