Data Warehousing Director jobs in Champaign, IL

Associate Director/Director of Data Management, Visualization & Analysis

Performance Management

Office of the Vice Chancellor for Institutional Advancement

University of Illinois Urbana-Champaign
Location: Urbana-Champaign or remote

The Office of the Vice Chancellor for Institutional Advancement (OVCIA) at the University of Illinois Urbana-Champaign seeks a full-time Associate Director/Director of Data Management, Visualization & Analysis to join the Performance Management team. The role will focus on analyzing, reporting, and visualizing advancement data for our flagship campus advancement operation. The position will also work collaboratively with campus partners and the University of Illinois Foundation (UIF) to harvest and steward key datasets.

The University of Illinois is a world leader in research, teaching, and public engagement. Distinguished by the breadth of our programs, academic excellence and an internationally renowned faculty, Illinois serves our state, our nation, and our world by creating knowledge, preparing students for lives of impact, and addressing societal needs through the transfer and application of knowledge.

On June 30, 2022, the University successfully completed its fourth comprehensive campaign. The $2.25 billion “With Illinois” campaign was the most ambitious philanthropic initiative in its history. The $2.6 billion raised will support Illinois students, faculty, research, and infrastructure and continue to elevate the values that make Illinois distinctive: a sense of boundless aspiration, collaborative research, and global perspective.
OVCIA is charged with building relationships with our constituents and generating diverse resources that facilitate Illinois’ academic, research, economic and public services excellence. Advancement brings together professionals in marketing, communications, alumni relations, and development to lead these efforts across the Urbana-Champaign campus.

OVCIA is charged with building relationships with our constituents and generating diverse resources that facilitate Illinois’ academic, research, economic and public services excellence. Advancement brings together professionals in marketing, communications, alumni relations, and development to lead these efforts across the Urbana-Champaign campus.

Organizational Relationship

Reporting to the Senior Director of Performance Management Operations, the Associate Director/Director of Data Management, Visualization & Analysis will play a critical role in improving advancement productivity by analyzing, reporting and visualizing advancement data across functions of the advancement operation, with particular focus on frontline fundraising drivers and outcomes.

The ideal candidate should possess a high degree of independence and self-motivation. Leading with curiosity and taking a collaborative approach is a must as the position will partner with colleagues in the Office of Performance Management, at the University of Illinois Foundation and across advancement units.

Duties & Responsibilities for the Associate Director

Data Visualization and Analysis

• Mine and analyze data from advancement and university data sources to drive optimization and improvement of development activities and business strategies.
• Develop visualizations to aid Performance Management initiatives, support leadership decision-making and drive operational decision-making.
• Deliver statistical trend analysis, including performance, forecasting and projection reports.
• Design visualizations that can be used to communicate data and findings to non-technical audiences with the goal of improving business decisions and actions.

  Data Harvest and Management

• In partnership with the Senior Director, evaluate existing advancement and alumni/prospect data and implement changes that improve data quality for use in analysis, forecasting, and advancement business decisions with strong emphasis on pipeline data.
• Collaborate with advancement staff and academic partners to identify existing datasets with an advancement business purpose that are not yet captured in the alumni database.
• Work in partnership with the University of Illinois Foundation on data integration while adhering to appropriate data integrity, privacy, and ethics standards.

  Team Participation and Professional Development

  • In partnership with the Senior Director, cultivate strong relationships across Illinois advancement, seeking to understand functional roles and perspectives.
  
  • Present information on analytics opportunities and share best practices.
  • Take direction from Senior Director to lead assigned projects, driving progress and outcomes.
  • Share expertise with internal and external colleagues; Stay current with industry trends.

Minimum Qualifications

Bachelor's degree in business administration, management, or a field related to the position. Three (3) years of professional business, financial, and/or managerial work experience in data analysis. Demonstrated experience with data visualization software such as Tableau, Power BI, or similar tools. Demonstrated experience translating business needs into technical solutions, and experience in graphic/infographic design or data storytelling.

Preferred Qualifications
Experience in higher education advancement or related field.
Working knowledge of SQL, Python, Banner or demonstrated aptitude for learning coding languages.
Familiarity with TED, the alumni database used at the University of Illinois at Urbana-Champaign and the enterprise data warehouse used on the Urbana campus.

Knowledge, Skills and Abilities

• Demonstrated success in building internal relationships and partnering to achieve outcomes.
• Demonstrated Intermediate to Advanced skills in the Microsoft Office products Excel, Outlook, PowerPoint and Word.
• Ability to translate business needs into technical solutions
• Demonstrated ability to quickly comprehend, explain and operationalize complex data sets and analyses, to appropriately manage and communicate sensitive information, and to foster a collaborative work environment.
• Ability to communicate effectively, verbally and in writing, with a willingness to present across multiple layers of Advancement.
• Skilled in data visualization tools and knowledgeable about industry trends.
• Superior oral, written and presentation communication skills.
• Proven ability to continually prioritize multiple projects and assignments based on various factors, including size, scope and audience.

Duties & Responsibilities for the Director

Data Visualization and Analysis

• Mine and analyze data from advancement and university data sources to drive optimization and improvement of development activities and business strategies.
• Understand the breadth of available data in the context of advancement needs.
• Develop visualizations to aid Performance Management initiatives, support leadership decision-making and drive operational decision-making.
• Deliver statistical trend analysis, including performance, forecasting and projection reports.
• Design visualizations that can be used to communicate data and findings to non-technical audiences with the goal of improving business decisions and actions.
• Provide insights that inform advancement business decisions.

  Data Harvest and Management

• Evaluate existing advancement and alumni/prospect data, make recommendations for enhancement, and implement changes that improve data quality for use in analysis, forecasting, and advancement business decisions with strong emphasis on pipeline data.
• Drive data literacy improvement initiatives benefitting advancement stakeholders.
• Collaborate with advancement staff and academic partners to identify existing datasets with an advancement business purpose that are not yet captured in the alumni database.
• Work in partnership with the University of Illinois Foundation on data integration while adhering to appropriate data integrity, privacy, and ethics standards.

  Team Participation and Professional Development

• Cultivate strong relationships across Performance Management and Illinois advancement, seeking to understand functional roles and perspectives while identifying opportunities for collaboration.
• Present information on analytics opportunities, share best practices and provide training for colleagues.
• Serve as project lead on assigned projects, driving progress and outcomes.
• Share expertise with internal and external colleagues; Stay current with industry trends.

  Qualifications for the Director
  
  Minimum Qualifications

  Bachelor's degree in business administration, management, or a field related to the
  position. Five (5) years of professional business, financial, and/or managerial work
  experience in data analysis. Demonstrated experience with data visualization software
  such as Tableau, Power BI, or similar tools. Demonstrated experience translating business
  needs into technical solutions, and experience in graphic/infographic design or data
  storytelling.

  Preferred Qualifications

  Experience in higher education advancement or related field.
  Working knowledge of SQL, Python, Banner or demonstrated aptitude for learning coding languages.
  Familiarity with TED, the alumni database used at the University of Illinois at Urbana-Champaign and the enterprise data warehouse used on the Urbana campus.

• Knowledge, Skills and Abilities
• Demonstrated success in building internal relationships and partnering to achieve outcomes.
• Demonstrated Intermediate to Advanced skills in the Microsoft Office products Excel, Outlook, PowerPoint and Word.
• Ability to translate business needs into technical solutions
• Demonstrated ability to quickly comprehend, explain and operationalize complex data sets and analyses, to appropriately manage and communicate sensitive information, and to foster a collaborative work environment.
• Ability to communicate effectively, verbally and in writing, with a willingness to present across multiple layers of Advancement.
• Skilled in data visualization tools and knowledgeable about industry trends.
• Superior oral, written and presentation communication skills.
• Proven ability to continually prioritize multiple projects and assignments based on various factors, including size, scope and audience.

Impact in Your First Year
At Advancement at Illinois, we value our employees and provide resources to help you continually learn and grow. We foster a strong, collaborative community of people who are driven by their ability to make a difference.

Within 3 months, you’ll:

• Become familiar with the strategic vision and priorities of the OVCIA and Performance Management.
• Become familiar with the overarching structure of Advancement at Illinois and the alignment between central Advancement services, the University of Illinois Foundatn, and the University of Illinois Alumni Association.
• Attend training, professional development, and networking activities for newcomers within Advancement
• Understand Illinois' fundraising fundamentals and how they are operationalized in our CRM system and realized in the advancement data.
• Begin visualizing existing analyses and datasets for various advancement stakeholder groups.
  
  Within 6 months, you’ll:
• Cultivate relationships with campus partners and UIF colleagues, seeking to understand their functional roles and perspectives while identifying opportunities for collaboration.
• Familiarize yourself with the data structures in the CRM data warehouse and assist with coding projects.
• Complete multiple data visualizations serving diverse audiences across advancement and our partners.
• Identify existing datasets with an advancement business purpose that are not captured in the alumni database.
  
  By the end of the first year, you’ll:
• Be fully integrated into Performance Management, with the ability to recommend ways your skillset can contribute to overall departmental efforts to improve advancement performance.
• Have confidence in independently serving as a bridge between data and decision-making by leading projects that translate business needs into technical solutions.
• Collaborate with UIF on data integration while adhering to appropriate data integrity, privacy, and ethics standards.
• Partner with Talent Management and your supervisor for individual coaching, professional development, and goal-setting opportunities.
• Build a robust network of colleagues across campus and university advancement. Cooperatively set annual goals with your supervisor and portfolio management team

  Appointment Information
  This is a 100% full-time Civil Service 5010 - Business/Administrative Associate position, appointed on a 12-month basis. The expected start date is as soon as possible after close date. Salary is competitive and commensurate with qualifications and experience, while also considering internal equity. Salary range for the Associate Director title starts at $75,000 and the Director title starts at $85,000.

  Please note: Immigration sponsorship is not available for this position
  
  For more information on Civil Service classifications, please visit the SUCSS web site at https://www.sucss.illinois.gov/pages/classspec/default.aspx.

  Application Procedures & Deadline Information
  Applications must be received by 6:00 pm (CST) on February 21, 2023. Apply for this position using the Apply Now button at the top or bottom of this posting. In order to be considered as a transfer candidate, you must apply for this position. Applications not submitted through https://jobs.illinois.edu will not be considered. For further information about this specific position, please contact Katie Walker at walker74@illinois.edu. For questions regarding the application process, please contact 217-333-2137.

  The University of Illinois System is an equal opportunity employer, including but not limited to disability and/or veteran status, and complies with all applicable state and federal employment mandates. Please visit Required Employment Notices and Posters to view our non-discrimination statement and find additional information about required background checks, sexual harassment/misconduct disclosures, COVID-19 vaccination requirement, and employment eligibility review through E-Verify.

  Applicants with disabilities are encouraged to apply and may request a reasonable accommodation under the Americans with Disabilities Act (2008) to complete the application and/or interview process. Requests may be submitted through the reasonable accommodations portal, or by contacting the Accessibility & Accommodations Division of the Office for Access and Equity at 217-333-0885, or by emailing accessibility@illinois.edu.

  Requisition ID: 1013431
  Job Category: Administrative
  Apply at: https://jobs.illinois.edu