Lead Data Analyst

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 is seeking a Lead Data Analyst to support the Budget Office with analytics that improve financial visibility and decision-making. In this on-site role in downtown Honolulu, you will serve as a key analytics resource, partner with internal stakeholders, and help coordinate external data analytics vendors while leading the 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.

What you’ll do

• Oversee and enhance automated data processes that support revenue and expense reporting, enabling detailed analysis of performance by department, program, and business unit.
• Develop and maintain reports, interactive dashboards, visualizations, and KPIs that support operational and strategic decisions.
• Assist in analyzing student account activity, receivables, and outstanding balances.
• Extract, cleanse, transform, and analyze large and complex datasets from multiple sources to support management decision-making and strategic planning.
• Maintain and enhance financial planning and reporting software to ensure data integrity, system reliability, and alignment with business requirements.
• Maintain financial planning software integrations with Banner ERP and other institutional systems using ETL processes and automated workflows.
• Redesign, maintain, and continuously improve enrollment and net tuition forecasting for analysis by academic program, student type, and key drivers.
• Develop, test, and implement system enhancements, process improvements, and new functionality as business needs evolve.
• Partner with Institutional Research and other data owners to document and reconcile shared data definitions, reporting populations, program mappings, and business rules.
• Serve on the Banner Services and Data Governance Committees and collaborate with Business Office, Institutional Research, Information Technology Services, and other stakeholders to support accurate student billing, financial reporting, and budgeting.
• Monitor data quality and integrity through audits, reconciliations, and quality assurance, identifying root causes and resolving discrepancies promptly.
• Coordinate system testing, validation, and quality assurance for software upgrades, enhancements, implementations, and data integrations.
• Continuously improve documentation of data definitions, business rules, system mappings, and data governance standards used for financial reporting, budgeting, and analysis.
• Provide guidance, training, and ongoing support to data analysts on systems, data structures, reporting tools, and governance standards, including centralized knowledge and onboarding materials.
• Review and provide feedback on dashboards, analyses, and solutions created by other analysts to ensure accuracy and adherence to University standards.
• Act as an effective team member by completing assigned duties and taking on additional assignments as needed, including assistance during seasonal peaks.
• Maintain confidentiality and security of student education records and other sensitive University information in accordance with FERPA.

Required qualifications

• Bachelor’s degree in Business Analytics, Data Science, Computer Science, Information Systems, or a related field.
• Minimum of four years of professional experience in data analysis, business intelligence, or a related role.
• Advanced proficiency in Microsoft Excel, including Power Query and data modeling techniques.
• Strong technical skills writing SQL queries and working with relational database systems.
• Ability to troubleshoot and analyze programming code to identify root causes and implement solutions.

Preferred qualifications

• Experience in financial planning and analysis (FP&A), accounting, budgeting, or financial reporting.
• Experience with Ellucian Banner or a comparable higher education ERP system.
• Experience with Vena Solutions, including ETL configuration, data integration, and template design.
• Familiarity with higher education data, reporting, and business processes.
• Ability to translate business requirements into technical solutions and actionable insights.

Technologies you’ll use

SQL, Microsoft Excel, Power Query, Power BI, Ellucian Banner, Banner ERP, Vena Solutions, ETL, FERPA

Benefits

• Comprehensive health insurance, life and disability insurance, plus an employee assistance program and wellness program.
• Eligible employees may enroll in the HPU 403(b) retirement plan upon hire.
• 15 holidays annually, plus winter break days off between Christmas and New Year’s.
• Eligible employees receive vacation, sick, and other types of paid leave.
• Full time employees and spouse/dependent children pursuing higher education degrees at HPU may apply for a tuition waiver.
• Discounts for products and services, including airlines, rental car, hotels, theme parks, attractions, gift cards, restaurants, and more.

Location and eligibility

• This is an onsite role at the Waterfront Plaza campus and offices in downtown Honolulu.
• Candidates must be legally authorized to work in the United States; visa sponsorship and relocation allowance are not available.
• Must meet training and background check qualifications and comply with the Protection of Minors policy.
• Able to work extended hours if needed, with advance communication to your supervisor if unable to attend work.
• Requires strong time and stress management skills.