5173 ODS-EDW Database Analyst
TITLE ODS-EDW Database Analyst
CLASSIFICATION NUMBER 5173
IMMEDIATE SUPERVISOR Senior Database Analyst
MAJOR ADMINISTRATOR Coordinator of Management Information Systems
The Operational Data Store (ODS)/Enterprise Data Warehouse (EDW) Database Analyst is responsible for the ongoing provision of query and reporting services including training, communication, and documentation. The ODS/EDW Database Analyst guides the university’s use of the ODS and the EDW, works with the Database Analysts to develop and maintain both the data systems and the associated reporting mechanisms, meets with users at all levels of the institution to assess needs and design reporting systems, and provides training to both Computer Services staff and campus users covering available data, efficient query techniques, security considerations and reporting tool usage.
MINIMUM ACCEPTABLE QUALIFICATIONS
Education: A Bachelor’s degree or the equivalent is required; a Bachelor’s degree in a computer-related field is preferred.
Experience: Two years of experience in database design, administration, and database application programming is required. Functional knowledge of database management systems and SQL is required. Experience with database query tools and products, Oracle, PL/SQL, and the use of microcomputers in business application is required. Oracle certification is preferred. Experience with ODBC, web development, Microsoft Excel, and Microsoft Access is preferred. Work experience in higher education is preferred.
Skills: The ability to understand and manage complex software and database systems is required. The ability to maintain confidentiality in regard to information processed, stored, or accessed by the systems is required. The ability to manage multiple concurrent projects and to reason analytically is required. The ability to work with and train people possessing differing levels of technical knowledge is required. Effective verbal and written communication skills and proficiency in writing technical specifications are required. The ability to develop knowledge of, respect for, and skills to engage with those of other cultures or backgrounds is required.
Other: The twenty-four hour scope of University operations requires this position to be available evenings, nights, and weekends to respond to calls regarding questions or problems with the University’s computing systems.
ESSENTIAL DUTIES AND RESPONSIBILITIES
1. Supports the efforts of Systems Analysts and Programmer/Analysts in ODS/EDW database table design by providing guidance in logical and physical design, defining and/or updating database tables, and maintaining the data dictionary, metadata and associated tools.
2. Promotes the uniformity of the database-related programming effort by developing methods and procedures for database programming.
3. Promotes the professional development of Computer Services staff members and campus users by preparing and offering training and demonstrations regarding database-related design, development, and/or appropriate database querying tools.
4. Trains all levels of campus users to access information contained in the ODS and EDW using reporting systems and/or appropriate database querying tools.
5. Communicates effectively with campus users and Computer Services’ staff regarding ODS/EDW data, reporting systems, upgrades, etc. and maintains the web pages that document metadata, data element dictionaries, and general query/reporting information.
6. Organizes and leads the query developers’ user group and maintains the associated web site.
7. Promotes the use of the ODS/EDW to align resources with university goals and to assist in the monitoring and collection of key performance indicators.
8. Plans, executes and tests ODS and EDW upgrades.
9. Develops dashboards, reporting systems, and query repositories to provide access to information.
10. Assists Computer Services staff in reporting system development considerations regarding use of the database by designing and creating database tables to meet reporting needs.
11. Ensures the integrity of ODS/EDW data and query results by establishing, publishing, and enforcing database standards and security procedures for the university.
12. Establishes, maintains, and prevents private or highly sensitive information from being accessed inappropriately.
13. Resolves database-related information requests by conducting a thorough analysis of the needs and employing appropriate techniques and tools to resolve the problems.
14. Maximizes computer system integrity by communicating with users and Computer Services staff to determine and resolve system problems using the appropriate debugging techniques and utilizing the appropriate database vendor support channels.
15. Assists in the selection of database query and reporting tools and products, making recommendations for purchase, developing bid specifications, evaluating bid responses, and recommending the selection of products that meet the database needs of the university.
16. Contributes to a work environment that encourages knowledge of, respect for, and development of skills to engage with those of other cultures or backgrounds.
17. Remains competent and current through self-directed professional reading and researching available tools and products, developing professional contacts with colleagues, attending professional development courses, and attending training and/or courses as assigned by the Senior Database Analyst.
18. Contributes to the overall success of the Computer Services Department by performing other duties and responsibilities as assigned by the Senior Database Analyst.
The ODS/EDW Database Analyst may supervise programmers/analyst and student workers.
OFFICE OF HUMAN RESOURCES
REVISED MARCH 2013
JOB FAMILY 3
Factor 1: Educational/Experience Requirements of the Job
Level 7 - 1379 Points: A combination of education and experience equivalent to a Level 7 as indicated by the Equivalencies Chart, when permitted by the Minimum Acceptable Qualifications.
Factor 2: Supervisory Responsibility
Level 1 - 299 Points: Little or no supervisory responsibility for the work of others.
Factor 3: Skill, Complexity, and Technical Mastery
Level 6.5 - 2050 Points: Skill, complexity, and technical mastery is somewhat above requirements for a level at 1900, but somewhat below the skill, complexity, and technical mastery requirements at level 2200.
Factor 4: Budgetary Control
Level 2 - 386 Points: Individuals in jobs at this level actively document, monitor, and control expenditures. At this level incumbents may recommend minor expenditures but have no real authority over budgets.
Factor 5: Work Environment and Physical Demands
Level 1 - 25 Points: The work environment has only everyday discomforts associated with an office or commercial vehicle. The work area is adequately lighted, heated or cooled, and ventilated. Work is largely sedentary involving mostly sitting with occasional walking, standing, bending, or carrying of small items. No special physical demands are required of the work.
Factor 6: Work Impact and Effect
Level 5 - 3780 Points: Work products or services directly impact the entire university system and the well-being of large numbers of individuals. Typically the work is complex and may involve addressing conventional problems or situations with established methods or resolving critical problems or developing new processes or models to address specific problems. Improperly performed work and/or equipment or software failures produce errors and delays that affect the operations and/or reputations of the entire University. Improperly performed work and/or equipment or software failures may be remedied in the short to medium term, but at very substantial cost of time and resources. The scope of improperly performed work and/or equipment or software failure is system-wide and the nature of the activity requires that emergency repairs be performed.