New

Institutional Research Database Administrator

University of the Pacific

United States, California, Stockton

3601 Pacific Avenue (Show on map)

Apr 26, 2025

Posting Details

Position Information

Job Title	Institutional Research Database Administrator
Union Level
Department	Planning and Institutional Research
Campus	Stockton
Posting Number	201304005P
Full or Part Time	Full Time
Number of Months	12
Work Schedule	Work is performed during standard hours. Additional hours may be required to meet business needs or deadlines. Travel to conferences or training as needed.
Position End Date
Open Date	04/25/2025
Close Date
Open Until Filled	Yes
Special Instructions to Applicants	For Applicants Seeking Job Opportunities within the University Internal: Internal applicants will be considered within the first five (5) business days of the posting period. External: External applicants will be considered on the sixth (6) business day of the posting period.
Sponsorship	This position is not eligible for a visa sponsorship now or in the future.

Position Summary Information

Primary Purpose	The Institutional Research Database Administrator performs ETL processes from a variety of data systems (e.g., Banner, National Student Clearinghouse) and loads the data into the Institutional Research (IR) office's Microsoft SQL Server. The Institutional Research Database Administrator performs the ETL processes to condition, organize, and secure these analytical datasets that support statistical analysis, trend reporting, and benchmarking comparisons for the IR office. The role also includes overseeing data access and security for the SQL Server and related online reports. Additionally, the Institutional Research Database Administrator oversees all aspects of the university's course evaluation system, including data extractions, user support/access roles, and data security.
Essential Functions	Serve as a database administrator for the IR Microsoft SQL server and Power BI gateway. Develop and maintain ETL processes that organize and condition data within the SQL server for reporting. Develop and maintain MS SSMS jobs that support recurring reporting. Design and maintain reporting tools and online dashboards. Ensures appropriate access to data as well as the security of the SQL server. Support data audits and other efforts to ensure data integrity. Document processes for data extraction, transformation, and organization. Maintains and enhances multiple databases for reporting, including, but not limited to, admissions, enrollment, yield, retention, courses, grades, evaluations of courses, financial aid, tuition revenue projections, degrees, housing, and faculty. Conduct summary analyses and generate reports to support decision-making. Responsible for the university-wide course evaluation system, including extractions, user support, maintenance, security, and troubleshooting. Performs other related duties as assigned. University of the Pacific recognizes that diversity, equity, and inclusion is foundational to the success of our valued students and employees. We prioritize policy and decision-making that demonstrates awareness of, and responsiveness to, the ways socio-cultural forces related to race, gender, ability, sexuality, socio-economic status, etc. impede or propel students, faculty, and staff.
Minimum Qualifications	Two (2) years of post-secondary education. Two (2) years of experience managing large-scale databases, including organizing data through ETL processes to support organizational reporting, supported by postsecondary education or training beyond a high school diploma.
Preferred Qualifications	Bachelor's degree in Computer Science or a related field. Proficiency in a programming language such as Microsoft SQL. Experience using a reporting tool (e.g., Power BI, Crystal Reports) to develop and share reports with end users. Experience managing Microsoft SQL Server environments, including organizing data to support institutional reporting needs. Proficiency with Microsoft Power BI for building and sharing data visualizations and reports. Experience and sensitivity in working with people of diverse backgrounds and cultures. Demonstrated experience in advancing social justice, equity, and inclusion in a university setting. Ability to engage and integrate culturally responsive practices and knowledge in their work.
Physical Requirements	The physical demands described here are representative but not definitive of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Requires extended periods of sitting and repetitive hand/wrist motion while using a computer keyboard and phone. Occasional standing, walking, climbing stairs, bending, stooping, and reaching. Occasional lifting up to twenty-five (25) pounds. Work Environment/Work Week/Travel: Work is performed during standard hours. Additional hours may be required to meet business needs or deadlines. Travel to conferences or training as needed. Valid driver's license required. Incumbent must also be able to meet the University's fleet rules and be eligible to drive for University business. The University and its insurance carrier reserves the right to exclude applicants based on their driving record.
Hiring Range	$68,640.00 - $80,000.00 per year. We consider factors such as, but not limited to, scope and responsibilities of the position, candidate's qualifications, internal equity, as well as market and organizational considerations when extending an offer.
Background Check Statement	All applicants who receive a conditional offer of employment are required to execute a release and authorization for a background screening. AB 810 Misconduct Disclosure Requirement: University of the Pacific complies with California Assembly Bill 810, requiring candidates accepting conditional job offers to disclose any final administrative or judicial findings, ongoing proceedings, allegations, resignations under investigation, or appeals related to sexual harassment or misconduct within the past seven years.
AA/EEO Policy Statement	University of the Pacific is an affirmative action and equal opportunity employer dedicated to workforce diversity. In compliance with applicable law and its own policy, Pacific is committed to recruiting and retaining a diverse faculty and staff and does not discriminate in its hiring of faculty and staff, or in the provision of its employment benefits to its faculty and staff on the basis of race, color, religion, national origin, ancestry, age, genetic information, sex/gender, marital status, military and veteran status, sexual orientation, medical condition, pregnancy, gender identity, gender expression, or mental or physical disability.