UNM Logo

Position Classification Description

Position Class Code / Title: A5041 / Database Des & Analysis Mgr
Recruitment Tier: Tier 1
FLSA: Exempt
Grade: 13

This is a description of a Staff Position Classification. It is not an announcement of a position opening. To view descriptions of current openings, please go to UNMJobs and Search Postings to view positions that are currently accepting applications.

The following statements are intended to describe, in broad terms, the general functions and responsibility levels characteristic of positions assigned to this classification. They should not be viewed as an exhaustive list of the specific duties and prerequisites applicable to individual positions that have been so classified.

Summary

Provides data analysis and functional expertise to internal and external constituencies in the design and maintenance of relational database systems to support multiple databases. Each database system may have a different scope of work, utilize different computer languages, serve widely different users, and have varying functionality. Manages and coordinates the development, provision, and interpretation of data sets and data systems required to meet the operating and/or programmatic objectives of an integrated, self-contained organizational unit. Coordinates with IT programming and systems teams to specify system design to satisfy reporting, security, and support needs.

Duties and Responsibilities

  1. Defines, develops, and drives strategies, plans, policies and procedures to ensure that the data systems remain operational and meet business operational needs.
  2. Works with stakeholders such as funding agencies, partner programs, IT staff, and vendors to develop and design data models.
  3. Identifies business needs and issues to effectively translate them to actionable requirements consistent with the tasks described in the contracted Scopes of Work.
  4. Consults with and advises clientele on the use and interpretation of data; collaborates as appropriate with clientele in the structuring and development of data requirements.
  5. Addresses a variety of data integration issues including migration of data between disparate databases, reporting integration, maintenance, conversion, capacity planning issues and new data reporting applications for various databases.
  6. Reviews requests for services, makes improvement recommendations and partners with IT staff and other stakeholders to clarify objectives, determine feasibility and jointly determine business implications.
  7. Ensures that any new data system meets functional end user requirements, compliance and interface specifications, and that proper documentation is maintained. Defines functional data requirements and documents all business processes.
  8. Designs and implements integrated analytical studies in support of specified operational programs; analyzes and communicates the results utilizing advanced statistical and data analysis techniques.
  9. Develops effective test scenarios, and uses cases with a consideration to cross-functional and process stream impact. Analyzes the formal test results in order to discover and support resolution of defects, bugs, errors, configuration issues and interoperability flaws.
  10. Collaborates and coordinates with IT application and system administrator to complete functions specific to application setup, configuration and maintenance.
  11. Maintains the availability and integrity of databases through multiple access schemes.
  12. Facilitates the sharing of common data by ensuring that each data set has proper key and index management and ensures the data dictionary is maintained.
  13. Maintains currency of knowledge with respect to the relevant state-of-the-art technology, equipment and/or systems.
  14. May supervise and/or lead staff and/or student employees, as assigned.
  15. May evaluate and recommend the testing and evaluation of new procedures, software, and hardware to allow for continuous adaptation of the program to meet ongoing needs.
  16. Performs miscellaneous job-related duties as assigned.

Minimum Job Requirements

  • High school diploma or GED; at least 7 years of experience directly related to the duties and responsibilities specified.
  • Completed degree(s) from an accredited institution that are above the minimum education requirement may be substituted for experience on a year for year basis.

Knowledge, Skills and Abilities Required

  • Ability to interpret data models and to develop database structures including knowledge of database construction, management, and retrieval methods.
  • Ability to analyze operational data requirements and to create and develop databases specific to requirements.
  • Ability to provide technical guidance and leadership to professional personnel in data management, data integrity and database design.
  • Ability to develop and manipulate large, complex data sets and to design and implement systems necessary to collect, maintain and analyze data.
  • Ability to resolve data input, storage and/or retrieval problems and to work with IT staff to design solutions and modifications.
  • Ability to coordinate implementation, test and troubleshoot database changes and modifications.
  • Knowledge of current technological developments/trends in area of expertise.
  • Ability to provide a range of training and/or support activities for users.
  • Ability to communicate effectively both orally and in writing.
  • Ability to supervise and train assigned staff.

Distinguishing Characteristics

    Position requires: a) provide technical expertise in the design, implementation and maintenance of the relational database systems for multiple databases; b) coordinate the analysis and interpretation of user needs and develop user requirements, manage database changes, and test of applications software; c) create and maintain documents such as end-user manuals and handbooks; d) analyze, interpret, and manipulate data; e) communicate and train staff on information resources and data.

Working Conditions and Physical Effort

  • No or very limited exposure to physical risk.
  • No or very limited physical effort required.
  • Work may be performed in a typical interior/office work environment.

The University of New Mexico provides all training required by OSHA to ensure employee safety.

Revised Date: 03/20/2017