DATABASE ANALYST I

DATABASE ANALYST I

Work Arrangement : Requisition Number : 246608 Regular or Temporary : Regular Location :

Durham, NC, US, 27710

Personnel Area : CENTRAL ADMIN MANAGEMENT CTR Date : Jul 9, 2024

Occupational Summary

The Computerized Maintenance Management System(CMMS) Analyst will provide a wide variety of analytical, strategic and operational support to the Utilities Maintenance Department and other teams within the Facilities Management Department (FMD) primarily focusing on the (CMMS).

The CMMS program is instrumental in notifying and prioritizing Operations & Maintenance preventative and corrective maintenance for the Department.

The CMMS Analyst will report to the CMMS Administrator and will assist with various other CMMS administrative functions.

Work Performed :

• Responsible for the management and coordination of equipment / asset management, reporting metrics and development of training programs and materials. 15%
• The individual will work closely with all shops, planners & managers and have in-depth understanding of materials management for the Department. 5%
• This position will be responsible for maintaining and optimizing the current PM program including taking the lead on PM development while working with a wide range of stakeholders to ensure an efficient PM program is in place. 15%
• Define and document standard workflow processes for creating and maintaining asset information, setting up and modifying PM schedules, tasks and routes.

Oversee the implementation and perform regular optimization review of the work flows. 10%

• Participate in establishing and maintaining reports, KPIs, and inboxes in the CMMS to provide easy-to-access status updates on key information for shops, storerooms, and managers. 10%
• Update and maintain existing metric reports utilizing SQL programming and have a thorough knowledge of the layout and operation of the CMMS database. 5%
• Work with management and others in increasing the user experience of the CMMS including but not limited to creating / altering customizable objects like User Defined Fields and User Defined Screens, reports, and other system enhancements. 10%
• Work with EAM Administrator in understanding the back end of the system and provide backup Administration duties as required. 10%
• Participate in developing and presenting a training program for new employees and refresher training for staff and managers including the mobile interface. 10%
• Generate reports to analyze work orders, shop labor, materials and costs to evaluate maintenance costs and recurring maintenance issues to assist in decision making on renewal funding or potential maintenance strategy changes. 5%
• Work with FMD IT and Duke OIT to help plan and test upgrades and modifications to CMMS. 5%

Required Qualifications at this Level :

Education & Experience

Work requires an Associate's degree in Engineering, Architecture,

Business or related field. (4) Four years of facilities management experience preferred.

Alternately, equivalent knowledge and experience in facilities maintenance and operations, or construction and renovation in facilities management combined with relevant education may qualify.

Knowledge, Skills and Abilities :

Good knowledge of building systems and general facilities maintenance practices.

Proficient with CMMS including report, grid, and SQL business rule development. Experience in HxGN CMMS preferred.

Computer software skills using MS Office including Word, Excel, PowerPoint, and Outlook.

Excellent oral and written communication skills; ability to communicate effectively to a wide range of audiences, including senior University management, faculty, staff from other departments, students, and others.

Ability to create and maintain positive customer and stakeholder relationships.

Minimum Qualifications

Education

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

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.

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 secure and 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 essentialjob 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.

Nearest Major Market : Durham

Nearest Secondary Market : Raleigh