Senior Data Analyst, FP&A & Budgeting – Honolulu

Hawaii Pacific University; Honolulu (HI); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Health insurance

Retirement plan (HPU 403(b))

Holiday leave

Tuition waiver

Wellness program

Job summary

Hawaii Pacific University seeks a Lead Data Analyst to support the Budget Office with analytics that improve financial visibility and decision-making. This onsite role in downtown Honolulu partners with stakeholders and vendors, leading dashboards, reports, data integrations, and analytical solutions used across financial planning and reporting.

You will report to the Assistant Vice President of Financial Planning, Analysis, and Budgeting, helping coordinate data definitions, governance, and

Qualifications

• Bachelor’s degree in a relevant field.
• Four years of professional data analysis or BI experience.
• Advanced proficiency in Excel, Power Query, and data modeling.
• Strong SQL and relational database skills.
• Ability to troubleshoot and identify root causes.

Responsibilities

• Oversee and enhance automated data processes supporting revenue and expense reporting.
• Develop and maintain reports, dashboards, visualizations, and KPIs.
• Analyze student account activity, receivables, and outstanding balances.
• Extract, cleanse, transform, and analyze large datasets from multiple sources.
• Maintain and enhance financial planning software for data integrity and system reliability.
• Integrate Banner ERP and other systems using ETL processes and automated workflows.
• Redesign enrollment and net tuition forecasting for program-level analysis.
• Develop, test, and implement system enhancements and new functionality.
• Collaborate with Institutional Research and data owners to document data definitions and governance rules.
• Participate in Banner Services and Data Governance committees to support accurate reporting.
• Monitor data quality through audits and reconciliations, resolving discrepancies.
• Coordinate testing, validation, and QA for software upgrades and data integrations.
• Document data definitions and governance standards for reporting and budgeting.
• Provide training and support to data analysts on systems and tools.

Skills

Data analysis

Stakeholder collaboration

Problem solving

Time management

Education

Bachelor's degree in a relevant field

Tools

SQL

Relational databases

Power BI

Power Query

ETL

Job description

Hawaii Pacific University seeks a Lead Data Analyst to support the Budget Office with analytics that improve financial visibility and decision-making. This onsite role in downtown Honolulu partners with stakeholders and vendors, leading dashboards, reports, data integrations, and analytical solutions used across financial planning and reporting.

You will report to the Assistant Vice President of Financial Planning, Analysis, and Budgeting, helping coordinate data definitions, governance, and