Business Intelligence Analyst

Job Purpose

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.

Essential 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.

Qualifications

• 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.
• Experience with Python, R, SAS, or Excel for statistical or predictive analytics.

Job Competencies

• 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.
• Proficiency in Tableau Desktop/Server/Cloud for interactive visualization design is highly preferred.
• 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.

Organization Competencies

• 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.

Travel Requirements

In alignment with our organizational competencies of Alu Like i ka Hana (Teamwork) and Ho'omau i ka 'Imi Na'auao (Continuous Learning and Improvement), this position will require occasional travel across the island, inter-island, and out-of-state depending on the needs of the team and the organization. While travel may not always be a need, the ability to travel when required remains a crucial aspect of this position to successfully contribute to our concerted efforts to carry out our Queen's legacy. This description reflects management's assignment of essential functions; it does not proscribe or restrict the tasks that may be assigned. This job description is subject to change at any time

Mental and Physical Demands:

• Perform light physical work, including climbing, stooping, kneeling, crouching, reaching, and lifting weight of up to 25 pounds. Exposed to outdoor climate and diverse terrain.

Terms and Conditions of Employment

As a condition of employment, the employee will be subject to LT's policies and procedures.

Job Title: Business Intelligence Analyst

Reports to: Director Data Management and Analytics

FLSA Status: Exempt


Aligned Executive: Managing Director IT

Kipuka: Lili'uonamoku

Department: Information Technology

Lili'uokalani Trust is an Equal Opportunity Employer. We strive to recruit, train, and retain innovative talent from a diverse candidate pool. All employment decisions will be based on merit, competence, performance, and business needs. Applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity or expression, religion, ancestry, genetic information, citizenship, marital/civil union status, arrest and court record, domestic or sexual violence victim status, credit history, disability or veteran/military status or other applicable legally protected characteristics.