Job Description
Job Purpose
The IT Data & Analytics (Program Analytics) Intern supports the team at Liliʻuokalani Trust by assisting with data preparation, analysis, and reporting projects. This internship provides hands-on experience connecting data sources and transforming information into insights that support organizational strategy and performance.
Learning Objectives
By the end of the internship, the intern will:
• Gain practical experience connecting, querying, and preparing data for analysis.
• Strengthen analytical and problem-solving skills through real-world data projects.
• Develop foundational skills in dashboard creation and data visualization.
• Build confidence in communicating insights through clear summaries and presentations.
Essential Responsibilities
• Assist with connecting to and preparing datasets from databases, spreadsheets, or internal systems.
• Support basic data querying, cleaning, and validation under team guidance.
• Help create and update dashboards, reports, and KPI summaries.
• Conduct exploratory analysis to identify trends or patterns.
• Participate in team meetings and contribute to project discussions.
Other Duties
• Adheres to internship program guidelines and supports department needs as assigned. Completes a variety of tasks that provide broad exposure to departmental workflows. Actively builds new skills, strengthens existing abilities, and applies learning to real world projects and responsibilities.
Qualifications
• Currently enrolled in a Engineering, Business, IT, or related degree program.
• A "data detective" mindset—you enjoy finding the "why" behind the numbers.
• Basic comfort with Excel; exposure to SQL or Tableau is a plus but not required.
Work Schedule & Location
• Estimated timeframe: June–July 2026
• Weekly schedule: 35–40 hours per week
• Location: Onsite / Liliʻuonamoku 1100 Alakea St. Honolulu, HI 96813
Job Competencies
Learning Agility
• Builds skills through hands-on experience across data prep, analysis and communicating insights
Querying & Exploratory Analysis
• Supports basic data querying and exploratory analysis to identify trends/patterns
Dashboarding & Data Visualization
• Helps create/update dashboards, and reports; builds foundational visualization skills
Insight Communication
• Summarizes insights clearly; builds confidence communicating findings
Analytical Problem Solving
• Strengthens analytical thinking through real world data projects and exploratory tasks
Collaboration & Team Engagement
• Participates in team meetings and contributes to project discussions
Organization Competencies
• Alignment with Queen’s legacy: Understanding and appreciation of Queen Liliʻuokalani’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, and understands their implications in one’s work, relationship building, and connection to 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.
• Hōʻike i Nā Mana‘o Pono (Effective Communication): Communicates with those we serve and with colleagues in a manner that results in mutual understanding, harmony, and action.
• No‘ono‘o Loa (Critical Thinking and Problem Solving): Actively and skillfully understands, conceptualizes, applies, analyzes, synthesizes, and/or evaluates information and develops fact based analyses and recommendations.
• Ho‘okumu A‘e / ‘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 organizational objectives.
• Ho‘onui i ka ‘Ike (Capacity Building): Encourages personal growth by exhibiting trust and belief in the capacity of others.
Mental and Physical Demands
• Ability to lift 25lbs pounds. Requires frequent sitting, bending, standing…
Terms and Conditions of Employment
As a condition of employment, employee will be subject to LT’s policies and procedures.
Job Title: IT Data & Analytics Intern Reports to: Director, Program Analytics
FLSA Status: Non-Exempt Aligned Executive: President and Chief Executive Officer
Kipuka: Liliʻuonamoku Department: IT
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.
