Assistant Director, Data Engineering

Join Our Team and Make a Difference in Higher Education!

At the System Administration office at the University of Colorado, we are dedicated to building a workplace where everyone feels valued, supported, and empowered to thrive. Our office is committed to fostering a culture where employees find community, a sense of belonging, and the opportunity to contribute meaningfully to our mission and purpose. By joining our team, you'll have a direct impact on shaping the future of higher education. In addition to the Office of the Board of Regents, the University of Colorado's system administration includes 19 units that provide essential services to CU's campuses in Aurora, Boulder, Colorado Springs, and Denver, as well as the Office of the President. While not a part of any one campus, we are proud to serve in the centralized office for the University system. Together, we ensure CU continues to deliver outstanding education, groundbreaking research, and valuable service to our communities. We believe in creating an environment where the unique experiences and perspectives of everyone are embraced, enriching the work we do and the strategic outcomes we pursue. If you're passionate about making a difference, contributing to a dynamic team, and supporting a mission that matters, we encourage you to apply and be part of our journey. Learn more about CU System Administration.

Position Summary: - University Information Services (UIS) provides technical services and enterprise applications to the University of Colorado campuses and the Office of the President. UIS is committed to excellence in customer service and technical expertise. Through the development of enterprise applications, UIS supports the University as a whole with systems used by students, faculty, human resources employees, finance employees, and others.

This position exists to serve as a manager for the field of Data Engineering, including the data warehouse. This position will be responsible for developing and defining Data warehouse, data marts, data hubs across several lines of business, in partnership with AD of Business Intelligence, UIS Enterprise Architect, UIS Data Architect, Data and BI team and the Integrations team. This position will lead a team of analysts, and ETL developers and administrators and will be responsible for setting direction, establishing priorities, and having technical depth to partner with the ETL Technical Lead to guide the team through the selection and creation of tools, templates and in the implementation of solutions. In addition, this position will be called upon to lead many projects/initiatives in the areas of responsibility, working closely with the UIS Project Management Office. This position will be a key member of the UIS Design Review team representing the data areas. This position will also collaborate with the campuses and lead the data queue and priorities and overall Data communications and relations.

This position works with the Assistant Vice President for Information Technology Service Delivery to handle a department-specific area of a department or team. This position provides oversight and recommendations on strategy and has responsibility over fiscal and personnel actions. This position reports to the Assistant Vice President of IT Service Delivery and is exempt from the State of Colorado Classified Staff system.

This role is eligible to work remotely within Colorado, and will be expected onsite on occasion.

Duties and Responsibilities

Supervise the Data team which includes, but is not limited to:

• Recruit and hire employees
• Assign and prioritize work and schedules
• Train and serve as a mentor to employees regarding daily activities
• Evaluate employee work performance and provide guidance
• Respond to employee questions or concerns and raise up as needed
• Supervise, set direction, and establish priorities for the Data team

Manages team of data architects responsible for data transformations used as source schemas for Salesforce integrations and ODIN interfaces.

Provide technical leadership of a common approach to data warehousing/Marts/Hubs/non confirming data stores across all UIS services, as the product manager currently for DataStage, Snowflake, data warehouse (CIW), and other associated technologies.

Research and articulate new technologies and standard processes

Anticipate and resolve issues related to data delivery.

Serve as an advisor to work teams across UIS and Campus IT and power users in the areas of focus

Provide leadership in recommending the overall direction and processes for data delivery.

Project management for data work initiatives

Lead process and continuous improvements of data delivery work.

Proactively connect with campus partners and build relationships to set expectations and understand customer needs and prioritizations

Advise and coordinate with system staff to ensure strong relationships internal to UIS

Supervise strategic planning and roadmaps for Data Services, related services, and products

Partner closely with UIS Business Relationship Managers and UIS Product Managers to understand campus and system business needs and priorities

Provide leadership, facilitation, and administration support in the overall direction of UIS policies and procedures

Use diplomacy and build consensus with CU departments, offices, and campuses to further communications and build/maintain relationships

Work with AVP to develop and supervise the annual budget.

Accountable for content updates to data websites for communication to all customers

Provide support to the Integration team on Integrations build on CIW

Work closely with Data Governance program to document product within the Data and BI area

Partner with the Data Governance program to ensure data definitions, standards, and data quality practices are incorporated into Data solutions.

Collaborate with AD of Business Intelligence and Data Architect on various services and product related items.

Applications/Tools

• Used:
• Cherwell
• Oracle Databases
• SharePoint
• Zoom
• Cognos
• Collibra
• TeamDynamix
• Tableau
• Excel
• Toad
• Managed:
• Snowflake
• SAS
• Perl
• DataStage

Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights

Minimum Qualifications:

• Bachelor's degree from an accredited institution of higher education, or equivalent professional experience (professional experience may be substituted for the educational requirement on a year-for-year basis)
• Six (6) years' experience including the following:
• Data Platforms and Analytics toolkits (e.g., IBM Cognos, Oracle, Tableau, DataStage)
• Scripting or programming languages (e.g., Perl, Python, Java, etc.)
• Managing projects, services, or processes
• Working with a diverse group of administrators through projects and operations
• Full-time or equivalent experience as a senior developer and/or architect in BI area
• Two (2) years' experience in a managerial or supervisory role, which includes managing personnel, developing/mentoring direct reports, and completing performance reviews to ensure continuous improvement, high performance, and employee retention

Preferred Qualifications:

• Bachelor's or post-baccalaureate degree from an accredited institution of higher education in the field of computer science, information systems or a related field
• Eight (8) years' professional experience, as indicated above Experience managing a team that includes technical positions
• Experience working in a higher education environment
• Three (3) years' experience in a managerial or supervisory role, as indicated above

Knowledge, Skills, and Abilities:

• Knowledge of SQL, ODBC, and database concepts in Oracle, Snowflake or other database technology
• Solid understanding of BI products like Cognos, Tableau, etc.
• Solid understanding of data warehouse technologies and methodologies
• Solid ability to explain sophisticated problems and discuss trade-offs of potential solutions
• Understanding of change control processes
• Knowledge of basic key infrastructure areas such as Networking, VIPs, SAN, NTFS, SSL, Virtualization, etc.
• Willingness to travel to customer locations: Aurora, Denver, Boulder, and Colorado Springs
• Exceptional verbal and written communication skills; must be adept at managing multiple competing projects/priorities