HRTMS Job Description Management | Data Analyst - Data and Business Intelligence J o b D e s c r i p t i o n |
Job Information: | Title: | Data Analyst - Data and Business Intelligence | Classification Title: | 5031 - Information Technology Technical Associate | Job Location or Region: | Urbana-Champaign - 133 | Job Description Reason: | Vacancy | Appointment Type: | Permanent | Position Number: | UD0536 | Position Class Code: | 5031G-IT TECH ASSOC (LU) | Employee Group: | C - Civil Service Web/Dpt Tm Entry | COA: | 1 - Urbana | Organization Code: | 336000 | Organization Name: | Intercollegiate Athletics | College/Administrative Unit: | NU-Div Intercollegiate Athletics | HR Information: | Full Time Equivalent (FTE): | 1 | Is this position Security Sensitive? | | Is this a Protection of Minors position? | | Purchasing Authority of $5,000 or more? | | Supervisory Authority of 20 or more? | | Organizational Relationship: | Chancellor, Director of Athletics Executive Senior Associate Athletic Director/CFO Associate Athletics Director, IT Services Data Analyst - Data and Business Intelligence | PRIMARY POSITION FUNCTION/SUMMARY | | | This position is responsible for developing scalable solutions to transform large, complex datasets from varied sources into insightful models and data visualizations. | | | | | | | | |
Duties and Responsibilities | Duties are listed in order of greatest importance. Other responsibilities may be assigned. | | | % TIME | • | Generate Actionable Insights • Develop and maintain reports, dashboards, and visualizations using advanced tools such as Power BI and Python, ensuring the effective communication of key performance metrics to stakeholders within the athletics department. • Train, optimize, and deploy predictive models for accurate expense and revenue forecasting, leveraging advanced statistical and machine learning techniques. | 50% | • | Develop Data Strategies • Identify opportunities for process improvement and automation to enhance efficiency in data analysis and reporting within the university athletics department. • Collaborate with cross-functional teams, including financial operations, human resources, revenue operations and sports performance, to align data strategies to organizational goals. | 25% | • | Collect and Analyze Data • Enhance the automation of data workflows in Microsoft Azure, leveraging cloud and data modeling expertise to enhance the agility and scalability of analytics processes. • Handle large datasets sourced from diverse systems and databases, independently running ad hoc analyses to generate valuable insights that inform strategic decision-making. | 25% | | | | | |
QUALIFICATIONS: | To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. | Minimum Qualifications: | | Specialty Factors: | • High school diploma or equivalent. • Two (2) years of work experience in IT‐related functions such as hardware/software support, programming, network design, network engineering, IT systems integration, or closely related field. College coursework which includes Information Technology (IT), IT Management, Programming, IT systems, or a closely related discipline may be substituted as follows: 30 semester hours equals one (1) year, Associate’s Degree (60 semester hours) equals eighteen (18) months, 90 semester hours equals two (2) years, Bachelor’s Degree (120 semester hours) equals three (3) years). • Demonstrated experience in communicating data analytics within college athletics. | Preferred Qualifications: | Experience Prior experience working within an athletic organization or a similar field. Demonstrated experience in automating data workflows, particularly in cloud environments such as Microsoft Azure. Proven track record of developing and maintaining reports, dashboards, and visualizations that effectively communicate key performance metrics. Experience in predictive modeling and advanced statistical techniques, with a focus on expense and revenue forecasting. Skills Advanced expertise in data visualization & reporting, with a strong knowledge of tools such as Power BI, Power Apps, and Azure. Strong programming skills in SQL, with experience in both relational and cloud databases, and proficiency in Python/R for data manipulation and analysis. Excellent written and verbal interpersonal communication and presentation skills, with an effective storytelling ability to communicate complex data insights to all levels of an organization. | | | | |
Knowledge, Skills and Abilities: | KSAs | Maintain knowledge of, and compliance with, specific NCAA, Big Ten Conference, and institution rules that relate to this position is required. | Championship Mindset and Expectations: • Displays professionalism and integrity. Understands and displays professionalism that builds and maintains trust between student-athletes and fellow DIA staff; • Prioritizes and contributes to the life changing student-athlete experience; • Adheres to University, DIA, Big Ten, and NCAA rules and regulations; • Commitment to the Athletics Department and University’s mission and values; • Flexible to various scheduling to include nights, weekend work and some holidays; and • Maintain professional competency and skills required for professional practice. |
PHYSICAL DEMANDS/WORKING CONDITIONS | Providing this information helps ensure that the essential functions of the position are fully documented for the benefit of employees, applicants, and the university. | | | |
Working Environment | While performing the duties of this job, the associate is required to work within the selected working environments. | Working Condition | N/A | Rarely | Occasionally | Frequently | Constantly | | | | | | | | | | | |
Physical Demands/Working Conditions Comments: | Ability to sit for long periods of time and look at a screen. | | Manager Approval | Manager Approver | Rogers, Nick | Date Approved/Finalized | 3/25/2024 | | | | | |
|