Data Analyst​/Database Administrator

Title: Institutional Research Data Analyst/Database Administrator

Department: Institutional Research

Pay Grade: Commensurate with Experience

Revision Date: 9-16-26

Location: Academic Technical Center

Approved by: President

Position Summary:

The Institutional Research Data Analyst/Database Administrator is directly responsible for the Administrative Information Systems under the supervision of the Executive Vice President/COO/ALO. The Administrator plays a major role in making sure that the technologies provide users with flexibility in the management, access, retrieval, sharing and configuration of the data, systems analysis, and ensures the consistency and integrity of data.

This professional staff position requires working knowledge of departmental functions with user areas being supported by the AIS and maintain SQL functions, responsibility in coordinating the computer programming and operations staff in daily application execution and development.

Specific Responsibilities:

1. Assume all decision-making responsibilities in the absence of the Director of IR.

2. Develop database solutions that satisfy the users need for high-speed access, multiple views of the same information, accuracy and security, and the sharing of information.

3. Set administrative information systems task completion priorities.

4. Oversee and produce reports/files for the data reporting to all internal users and external agencies.

5. Design and implement new application programs, processes, reports, or various file extracts for administrative use.

6. Determine best methodology to complete client projects, with limited assistance.

7. Conduct performance tuning of queries, reports and interfaces.

8. Acquire knowledge of the data to provide data conversions, data mapping, data manipulation, and data mining.

9. Understand key business processes and make recommendations for change based on system functionality.

10. Identify risks and data issues.

11. Provide database day-to-day maintenance, support, and troubleshooting.

12. Talk with appropriate administrators to determine informational needs, data flows and systems definitions.

13. Develop proper documentation procedures to assist the operations staff’s application program execution.

14. Provide data base security techniques that users can only be allowed access to specific data elements that are relevant to that user’s needs.

15. Provide programming and systems analyst support for all Administrative Information systems.

16. Manage ad-hoc reporting requests and write queries to deliver the required data.

17. Develop and maintain stored procedures.

18. Database scripting.

19. Assist with software updates released by the Administrative System software provider. This will ensure that the college is current with all changes made to the application software.

20. Provide day-to-day advice to users on data structures and terminology.

21. Provide training and support to users as needed to effectively deploy and support applications and database functions.

22. Provide help in creating new tables within the database system for users as needed.

23. Help create and maintain user‑specific views within database system in relation to institutional dashboards.

24. Stay up to date on required internal and external reporting responsibilities.

25. Maintaining and creating interfaces between the various databases to connect them to Jenzabar One.

26. Perform other duties and activities as assigned.

Physical Requirements:

Note:

Please rank the below tasks as F for Frequent (6+ hours daily), M for Moderate (4-6 hours daily), O for Occasional (2-4 hours daily) or R for Rarely(