| This role is accountable for planning, connecting, designing, scheduling, and deploying data warehouse systems, in collaboration with other data- and analytics-related roles. This is a senior IT role that would report to the Chief Information Officer and interact regularly with IT and other unit leaders and stakeholders. Information Technology Baseline: - University Business Model
- Understanding of the University’s organizational structure
- Understanding of University’s high-priority goals and imperatives
- Knowledge of the University’s vision and mission statements
- Basic knowledge of the University’s core business functions and related units of the University, including but not limited to academic programs, student affairs, athletics, marketing/philanthropy, and auxiliary services (housing, dining, facilities).
- Basic knowledge of core student- and employee-facing business processes, including but not limited to:
- Student: admissions, registration, enrollment, housing/dining
- Employee: hiring, on-boarding, employment policies and procedures
- Customer Service and Team Collaboration
- Knowledge of customer-facing (where customer = student, employee, or other key constituent) technology services, and how to direct customers to services
- High level of customer-centric service, exemplifying courteous, professional and engaged behavior in all interactions with students, employees, alumni, visitors and other constituencies
- Collegial and collaborative interactions with all IT staff and vendor/partners
- Technology Services Portfolio
- Material knowledge of the major components and systems that comprise the University technology portfolio (infrastructure and systems)
- Strong knowledge regarding data security, integrity, accuracy, and reporting
- Understanding of IT operational policies and procedures
- Communication Skills
- Excellent oral and written communication & technical writing skills
- Mastery of common collaboration and project management tools, particularly Microsoft 365 tools such as Teams and SharePoint.
- Continuous Improvement
- Motivated and interested in iterative improvements in quality, effectiveness and efficiency of all IT portfolio. Regularly submits ideas and proposals to assist in achieving University outcomes.
Capabilities and Skills: | Skill | Description | # of Years Required | | Data Warehouse | - Plan, create, coordinate, and deploy data warehouses.
- Preferably skilled in MS SQL, MS Power BI and other Microsoft cloud-based data solutions.
| 5+ | | | Data Integrations | - Develops, monitors, and maintains extract-transform-load (ETL) processes and integrations with various system databases including use of APIs as appropriate/available.
- Develop and document best practices for data loading and extraction.
| 5+ | | | Reporting and Analytics | - Develops, monitors, and maintains the data warehouse and related (marts, lakes) that support reporting and analytical visualization applications inclusive of operational and predictive reporting.
- Facilitate requirements gathering using expert listening skills and develop unique simple solutions to meet the immediate and long-term needs of business customers.
| 5+ | | | Data Architecture | - Develops, monitors, and maintains data architecture inclusive of data warehouses, marts, and lakes.
- Design and deploy data architecture, data modeling, and mapping solutions within structured data warehouse environment.
| 5+ | | | Data Analytics | - Expert in standard and best analytics and data management tools and practices.
- Able to convey information about tools and practices to other IT and University colleagues.
| 5+ | | | Master Data Management | - Expert in master data management (MDM) including ability to manage, centralize, organize, categorize, synchronize and enrich master data according to the business rules of the University.
- Experience in participating or leading MDM governance committees using expert listening skills and influencing practical solutions to achieve data health and consistency.
| 5+ | | Industry Participation & Knowledge | - Keep up to date with current and new industry trends, technologies related to data and analytics.
- Representing company at related consortia, conferences and networking events
| 5+ | |
