Data Warehouse Manager

Note for Current UM Employees

Current employees must apply internally via ConnectU > connectu.olemiss.edu

The University of Mississippi

"The University of Mississippi — fondly referred to as Ole Miss — stands as a premier public research institution with a proud legacy of academic distinction. We are devoted to nurturing a vibrant, inclusive community where every member — student, faculty, and staff — can achieve their fullest potential.”

Department Summary

The UM Office of Academic Computing works to advance the University of Mississippi's teaching and discovery missions through technology. A unit of the broader UM Office of Information Technology, Academic Computing is a customer-focused organization comprising user support services, instructional technology, high performance computing, and data reporting and analytics. Individual initiative is highly prized and well supported across all levels of the Academic Computing team.

Role Specifications

Below you will find classification and compensation information.  For additional details behind the University of Mississippi classification system please visit Human Resource Compensation Page

Family - Information Technology

Sub-Family - IT Infrastructure & Technical Services

Career Track / Level - M2

Grade - 12

Role Summary

Supports all activities related to the administration of databases in a client/server environment. 

Overview
The University Data Warehouse Manager will bear principal responsibility for building and managing the data warehouse infrastructure, ensuring the availability, accuracy, and security of data. The incumbent will work to support the university's strategic goals by providing data-driven insights and facilitating informed decision-making processes.

Key Responsibilities
Data Warehouse Design and Maintenance
•    Oversee the design, implementation, and maintenance of the university's data warehouse systems.
•    Ensure data integrity, accuracy, and accessibility by establishing robust data governance practices.
•    Collaborate with IT and other departments to optimize database performance and storage solutions.
Data Integration and ETL Processes
•    Manage data integration from multiple sources, ensuring seamless ETL (Extract, Transform, Load) processes.
•    Develop and maintain ETL workflows to ensure timely and efficient data processing.
•    Monitor and troubleshoot ETL processes, addressing any issues that arise promptly.
Data Analysis and Reporting
•    Provide data analysis and reporting solutions to support academic and administrative functions.
•    Generate and distribute regular reports on key performance indicators (KPIs) and other metrics.
•    Collaborate with stakeholders to develop custom reports and dashboards tailored to their needs.
Security and Compliance
•    Ensure data security and privacy by implementing appropriate security measures and protocols.
•    Maintain compliance with relevant regulations and standards, such as FERPA and GDPR.
•    Conduct regular security audits and assessments to identify and mitigate potential risks.

Summary
This successful candidate will be UM's first Data Warehouse Manager and will recruit and hire his or her own team of employees, and play a crucial role in designing and building a new data warehouse as well as the technical support, data governance, and analytics systems surrounding it.  

Examples of Work Performed

• Hiring, professional development, and daily supervision of professional staff members. 
• Meeting with key vendors to explore, procure, and deploy new technology solutions. 
• Meeting with UM decision makers to learn of their business-driven data needs. 
• Design of data products to met customer needs. 
• Building and maintaining data feeds from production IT systems (Banner, Workday) into the data warehouse.

Essential Functions

These essential functions include, but are not limited to, the following.  Additional essential functions may be identified and included by the hiring department.

1. Supports projects with long-range requirements for client/server database administration in conjunction with other managers in the information systems function. 
2. Confers with and advises others on administrative policies and procedures, technical problems, priorities and methods as they relate to unit data. 
3. Manages  the day-to-day activities of unit or program staff and resolves personnel issues.

Minimum Education/Experience

Education: Bachelor's Degree

Experience: (3) Three Years Experience Including Supervisory Experience 

Please include a resume and cover letter expressing your interest in this specific role. 

Preferred Skills and Qualifications
Technical Expertise
•    Strong proficiency in database management systems (DBMS) and data warehousing technologies.
•    Proficiency in data analysis and visualization tools, such as SQL, Power BI, Tableau, or similar.
Analytical and Problem-Solving Skills
•    Exceptional analytical skills with the ability to interpret complex data and provide actionable insights.
•    Strong problem-solving abilities, with a proactive approach to identifying and resolving issues.
•    Attention to detail and a commitment to data accuracy and quality.
Communication and Interpersonal Skills
•    Excellent written and verbal communication skills, with the ability to present complex information clearly and concisely.
•    Strong interpersonal skills, with the ability to build and maintain effective working relationships with diverse stakeholders.
•    Experience leading and mentoring teams, with a collaborative and inclusive leadership style.

EEO Statement

The University of Mississippi provides equal opportunity in any employment practice, education program, or education activity to all qualified persons. The University complies with all applicable laws regarding equal opportunity and affirmative action and does not unlawfully discriminate against any employee or applicant for employment based upon race, color, gender, sex, pregnancy, sexual orientation, gender identity or expression, religion, citizenship, national origin, age, disability, veteran status, or genetic information.

Minimum Physical Requirements

Physical Requirements:  These physical requirements are not exhaustive, and additional job-related physical requirements may be added to these by individual agencies on an as needed basis. 

Corrective devices may be used to meet physical requirements.

Physical Exertion:  The incumbent may be required to lift up to approximately 10 pounds.

Vision:  Requirements of this job include close vision. Speaking/Hearing: Ability to give and receive information through speaking and listening.

Motor Coordination:  While performing the duties of this job, the incumbent is frequently required to talk and hear; and use hands to finger, handle, or feel. The incumbent is periodically required to sit. The incumbent is occasionally required to stand; walk; and reach with hands and arms

Interview Requirements: Any candidate who is called for an interview must notify the Department of Equal Opportunity/Regulatory Compliance in writing of any reasonable accommodation needed prior to the date of the interview.

Background Check Statement

The University of Mississippi is committed to providing a safe campus community. UM conducts background investigations for applicants being considered for employment. Background investigations include a criminal history record check, and when appropriate, a financial (credit) report or driving history check.