Data Analyst

Role overview

Essential functions

• Design, develop, maintain, and enhance interactive dashboards and data visualizations.
• Analyze complex datasets to identify trends, patterns, anomalies, and opportunities; communicate actionable findings.
• Acquire, integrate, and prepare data from multiple sources for reporting and analysis.
• Perform data validation and quality assurance, investigate discrepancies, and collaborate to resolve data issues.
• Maintain KPI calculations, business rules, and consistent reporting methodologies.
• Automate data preparation, validation, and recurring reports where possible.
• Work with Administration and Finance stakeholders to understand requirements and develop analytical solutions.
• Prepare ad hoc analyses, reports, presentations, and summaries for managers and leadership.
• Document data sources, calculations, business rules, reporting processes, and data issues and resolutions.
• Test and validate data sources, models, system enhancements, and reporting solutions.
• Support other related duties, special projects, and initiatives as assigned.

Minimum qualifications

• Bachelor’s degree in finance or accounting and at least two years of business or financial analyst experience.
• Experience with data visualization tools and enhancing and optimizing Power BI dashboards for budgeting and financial reporting.
• Technical expertise in data models, database design and development, data mining, and segmentation techniques.
• Strong proficiency in SQL, Excel (Pivot Tables, VLOOKUP, Power Query), Python, or R.
• Knowledge of data governance, compliance, and reporting best practices.
• Strong analytical and problem-solving skills, attention to detail, and accuracy; able to query, write reports, and present findings.

Preferred qualifications

• Master’s degree in business analytics or a related field preferred.

Schedule

• Full-time schedule, Monday through Friday, 8:30 a.m. to 5:00 p.m.
• Schedule flexibility may be required for implementations, campus events, and project deadlines.

Work arrangement and conditions

• Hybrid work arrangement; the description states that the position has the opportunity for a hybrid schedule.
• Work is performed in a standard office or indoor university environment with minimal physical exertion.
• Position is subject to final budgetary and administrative approval.