Business Intelligence Analyst

Liliuokalani Trust•Honolulu, HI

About The Position

The Business Intelligence (BI) Analyst provides strategic and operational insights that drive organizational decision-making and performance improvement at Liliʻuokalani Trust (LT). The BI Analyst partners with leadership to identify information needs, perform requirements analysis, and translate business questions into analytical solutions. The BI Analyst demonstrates strong analytical thinking, storytelling ability, and a growth mindset—using data to influence strategy, identify opportunities, and support continuous improvement. The position designs, develops, and maintains dashboards and reports, manages reporting systems, conducts decision and industry analyses, and ensures that data-driven insights are accessible, accurate, and actionable. Success in this role will be measured by: Accuracy, timeliness, and adoption of analytic products; Effectiveness of requirements analysis and alignment of data solutions with business needs; Utilization of analytic products in strategic planning processes; Clarity and impact of data storytelling in presentations; and Ability to identify patterns, trends, and opportunities through data to strengthen the organization and improve outcomes.

Requirements

Bachelor’s degree in Business, Engineering, Data Analytics, Economics, Statistics, or related fields.
Minimum of three years of experience in business intelligence, analytics, or reporting roles, including experience using Tableau or similar reporting visualization tools.
Minimum of three years of experience working with Relational Database Management System (RDBMS) like Snowflake(preferred), MS SQL, or Google BigQuery.
Proven ability to take initiative and build strong, productive relationships within cross-functional teams.
Understanding of financial modeling, KPI frameworks, and performance management systems.
Able to work with minimal supervision and cross-functionally to deliver outcomes, while maintaining a high degree of accountability.
Able to gather and synthesize information, analyze decision options, and make recommendations for leadership.
Able to self-manage and engage in new problems proactively, with a sense of urgency and attention to detail.
Proficient at working with senior leadership across an organization to manage the process and set expectations accordingly.
Convey and receive information and ideas clearly. Provide and seek constructive feedback from all levels of teammates, including the executive team. Demonstrate strong written, oral, and listening skills.
Strong knowledge of SQL or Python for querying and data preparation.
Solid understanding of data models, structures, and architecture.
Demonstrated experience with report management and lifecycle maintenance.
Proven ability to conduct requirements gathering, document specifications, and deliver analytical solutions that meet stakeholder needs.
Excellent storytelling, communication, and presentation skills.
Strong analytical, problem-solving, and critical thinking skills. Knowledge of decision analysis techniques and ability to perform scenario-based modeling.
Alignment with Queen’s legacy: Understanding and appreciation of Queen Liliuokalani’s story, her legacy and the Hawaiian Culture is foundational to staff’s commitment to working with our Hawaiian children, families and communities. Demonstrates respect for and appreciation of Hawaiian values history, and culture, understanding its implication in one’s work, in fostering meaningful relationships, and in embracing the community served.
Ho`omau i ka `imi Na`auao (Continuous Learning and Improvement): Committed to creating and reinforcing an environment of continuous learning and improvement.
Ho`ike i na Mana`o Pono (Effective Communication): Communicates with those we serve and each other in a consistent manner that results in mutual understanding, harmony, and action.
No'ono'o loi (Critical Thinking and Problem Solving): Actively and skillfully understands, conceptualizes, applies, analyzes, synthesizes, and/or evaluates information and develops and supports fact-based analyses and recommendations
Ho'o kumu a'e or `Imi hakuhia (Innovation): Identifies and integrates creative ideas into new or existing services and promotes effective problem-solving.
Pilina Ho`ohana a me ka Hana Hilina`i (Building Relationships and Creating Trust): Manages relationships to create optimal opportunities and move the organization forward.
Alu Like I ka Hana (Teamwork): Works cooperatively and collaboratively with others throughout the organization in alignment with the organization's objectives.
Ho`onui I ka `Ike (Capacity Building): Encourages personal growth by exhibiting trust and a belief in the capacity of others.

Nice To Haves

Experience with Python, R, SAS, or Excel for statistical or predictive analytics.
Proficiency in Tableau Desktop/Server/Cloud for interactive visualization design is highly preferred.

Responsibilities

Data Visualization and Reporting
Design, develop, and maintain dashboards, scorecards, and reports that effectively communicate key performance indicators (KPIs) and business trends.
Create reports with forward-looking analysis of the external landscape and implications for LT.
Manage the end-to-end lifecycle of reports to ensure consistency and reliability.
Apply data visualization best practices to create clear, accurate, and engaging visual reports.
Requirements and Decision Analysis
Conduct requirements analysis to gather and document business and technical needs for data projects.
Translate business objectives into measurable metrics, calculations, and useful visualizations.
Utilize decision analysis techniques (e.g., scenario modeling, sensitivity testing, cost-benefit analysis) to evaluate strategic options and guide decision-making.
Collaborate with cross-functional stakeholders to ensure analytics solutions address critical business questions.
Community/Industry Research and Analysis
Conduct benchmarking and analysis to identify trends, performance gaps, and growth opportunities.
Synthesize external and internal data sources to provide leadership with insights into organizational positioning and emerging risks.
Present insights with dashboards and concise executive reports to inform strategic planning and business development initiatives.
Business Insights and Storytelling
Deliver actionable insights through data storytelling—translating technical findings into narratives that drive understanding and alignment.
Present complex analyses to executive, managerial, and non-technical audiences with clarity and confidence.
Provide consultation to leadership teams on how to interpret data and apply insights into operational and strategic decisions.
Data Management and Governance
Partner with IT and data engineering teams to ensure data accuracy, quality, and accessibility.
Maintain metadata documentation, including data definitions, sources, and transformation logic.
Support compliance with data governance, privacy, and ethical data practices.
Contribute on data process improvements and automation initiatives to increase efficiency and reliability.
Collaboration and Continuous Improvement
Collaborate across departments to align data reporting and analytics initiatives with organizational goals.
Demonstrate a growth mindset by proactively seeking new tools, methods, and learning opportunities to enhance analytical capability.
Participate in cross-functional projects, committees, or strategic initiatives that require data-driven insights.
Other duties:
May contribute to project teams or special initiatives.
Collaborates with consultants or vendors as needed.
Procures and manages datasets and analytic insights as needed for their work products as needed.
Serves as a change agent to promote new ways of working and continuous improvement.
Performs other duties as assigned.