Manager, Data Engineering and Analytics

University of Illinois Foundation•Champaign, IL

1d•Hybrid

About The Position

The University of Illinois Foundation (Foundation) is the official fundraising and private gift-receiving organization of the University of Illinois (University). It works closely with alumni and friends, faculty and staff, corporations and foundations, as well as campus development professionals to create fundraising programs and opportunities that benefit the University. This position will manage a team of data analysts, analytic developers and data engineers responsible for building, supporting and maintaining enterprise data solutions and reporting solutions that support fundraising, advancement operations, and leadership decision-making. The role oversees the development and support of the organization’s data warehouse and working closely with other teams throughout the organization to enhance technical platforms and automations for data delivery throughout the University of Illinois advancement community.

Requirements

Bachelor's degree required (Information Systems, Computer Science, or related field preferred), with 5+ years of experience developing data products and analytics solutions from data warehouse environments, and 3+ years managing technical staff including developers, data engineers, and analysts.
Proven ability to design and build interactive dashboards using Power BI or Tableau, alongside experience developing semantic models and self-service analytics platforms.
Solid understanding of data modeling principles including relational and dimensional modeling (star/snowflake schemas), with the ability to design data tables and data marts.
Strong communicator with excellent interpersonal and organizational skills, capable of managing multiple priorities, deadlines, and stakeholder expectations in a fast-paced, collaborative environment.

Nice To Haves

Master's degree preferred in a research/analytical field, with hands-on experience supporting enterprise-wide reporting platforms built on centralized data warehouses and modern architectures including dimensional modeling, star schemas, data vault, semantic models, and data lakehouse patterns.
Advanced SQL and T-SQL proficiency, including stored procedures and functions, with working experience on cloud data platforms such as Microsoft Fabric or Azure.
Familiarity with advancement operations and CRM platforms such as Blackbaud, spanning fundraising, donor engagement, and alumni relations business processes.
Knowledge of DevOps/DataOps practices including CI/CD pipelines, version control, and automated deployments.

Responsibilities

Manages a team of professionals, setting strategic priorities, directing, and prioritizing the team’s work.
Delegates and reviews team members’ work to ensure it meets scope, requirements, and deadlines.
Hires, trains, develops, and recognizes team members’ performance.
Direct the team's migration from legacy on-premises infrastructure to a modern cloud analytics platform using Microsoft Fabric.
Implement and maintain structured SDLC and delivery practices, including request intake, prioritization, and release management.
Partner with advancement leadership, analytics users, and IT to align data capabilities with organizational strategy and enterprise reporting needs.
Collaborate cross-functionally with technical teams to design, implement, and support enterprise data warehouse, analytics, and reporting solutions.
Apply strong SQL expertise to develop queries, analyze datasets, and support data warehouse and reporting environments.
Oversee the design, development, and maintenance of the data warehouse reporting and data delivery layer, including curated datasets that enable ad-hoc analysis and reporting.