Business Intelligence Analyst II, Finance & Administration
Core
Acquire, transform, analyze, and report financial and operational data to support financial reporting, planning, reconciliations, and decision-making for a university's Development and Alumni Relations team.
Role type
Business Intelligence Analyst (Finance)
Builds
Power BI dashboards, Python automation scripts, and financial data models
Domain
Higher Education Finance
Deliverable
dashboards & analysis
Required skills
Data acquisition, data transformation, data validation, financial reporting, budget-to-actual analysis, forecast analysis, fund balance analysis, personnel cost analysis, data modeling, DAX, Power Query, Python scripting, Excel
Preferred skills
Financial planning and analysis, accounting, higher education finance
Technologies
Power BI, Python, Microsoft Excel, Epic
Responsibilities
Maintain and enhance Python scripts for recurring reporting and reconciliations; Develop and maintain Power BI data models, transformations, and dashboards; Establish data-quality and governance standards; Reconcile outputs to authoritative financial records; Identify and resolve technical problems in data workflows.
Seniority
Mid-level, hands-on IC
