Business Intelligence Solutions Engineer

Liliʻuokalani Trust • Honolulu, HI

4d • Onsite

About The Position

The Business Intelligence (BI) Solutions Engineer turns organizational data into clear, trustworthy insights that help Liliʻuokalani Trust (LT) make informed decisions, improve services, and strengthen impact for Native Hawaiian youth and families. This role sits between traditional data engineering and BI analysis: it designs and maintains data models and transformation pipelines, writes and optimizes SQL queries, integrates data from multiple systems, and translates business questions into actionable insights. The Solutions Engineer partners with leadership, program teams, IT, the data engineering team, and other stakeholders to understand needs, define requirements, and deliver analytical products that are accurate, accessible, and useful — in service of LT's mission to improve the wellbeing of Native Hawaiian youth. The role also contributes to LT's evolving use of automation and AI to efficiently deliver insights to decision-makers. The Solutions Engineer is expected to experiment responsibly with AI-assisted workflows, prototype practical solutions, and evaluate where new tools can improve analytical speed, quality, accessibility, and adoption — while maintaining strong human judgment, data privacy, governance, and accountability for final outputs.

Requirements

• Bachelor's degree in Business, Information Systems, Data Analytics, Computer Science, Economics, Statistics, Engineering, or a related field; equivalent relevant experience will be considered.
• 3+ years of experience in business intelligence, data analytics, reporting, data engineering, or a related role, preferably in a nonprofit, education, social services, or mission-driven environment.
• Strong SQL skills and experience querying relational databases or cloud data warehouses; Snowflake experience preferred.
• Hands-on experience with a modern BI or visualization tool; Tableau experience strongly preferred.
• Experience building or maintaining data pipelines or ETL/ELT processes; familiarity with a transformation tool (e.g., dbt) or orchestration tool (e.g., Airflow, Fivetran) is a plus.
• Experience combining data across multiple systems, such as CRM platforms, data warehouses, spreadsheets, or operational systems, into a reliable reporting source.
• Ability to document metric definitions, reporting logic, requirements, assumptions, and data limitations clearly.
• Interest in AI-assisted analytics, automation, natural-language BI, or agent-based tools, with the ability to evaluate outputs critically and responsibly.
• Strong analytical, problem-solving, and critical-thinking skills, with the ability to identify patterns, trends, risks, and opportunities in data.
• Strong knowledge of SQL; working knowledge of Python for querying and data preparation.
• Proficiency in Tableau Desktop/Server/Cloud for interactive visualization design highly preferred.
• Ability to translate vague or complex business questions into clear data requirements, scoped tasks, and useful analytical outputs.
• High attention to detail and commitment to accuracy, data quality, and continuous improvement.
• Ability to work independently with minimal supervision while collaborating effectively across departments.
• Growth mindset and curiosity toward emerging analytics, AI, automation, and data tools, with a willingness to experiment, learn, and share practical lessons with the team.
• Commitment to responsible data use, privacy, governance, and careful handling of sensitive information, particularly given the sensitivity of data related to Native Hawaiian youth and families.
• 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.
• Committed to creating and reinforcing an environment of continuous learning and improvement.
• Communicates with those we serve and each other in a consistent manner that results in mutual understanding, harmony, and action.
• Actively and skillfully understands, conceptualizes, applies, analyzes, synthesizes, and/or evaluates information and develops and supports fact-based analyses and recommendations.
• Identifies and integrates creative ideas into new or existing services and promotes effective problem-solving.
• Manages relationships to create optimal opportunities and move the organization forward.
• Works cooperatively and collaboratively with others throughout the organization in alignment with the organization's objectives.
• Encourages personal growth by exhibiting trust and a belief in the capacity of others.

Nice To Haves

• Snowflake experience preferred.
• Tableau experience strongly preferred.
• Familiarity with a transformation tool (e.g., dbt) or orchestration tool (e.g., Airflow, Fivetran) is a plus.
• Interest in connection to Native Hawaiian communities, place-based work strongly preferred.

Responsibilities

• Design, develop, and maintain dashboards, scorecards, and reports that communicate key performance indicators, business trends, and actionable insights.
• Write and optimize SQL queries against the data warehouse to answer ad hoc business questions and support recurring reporting needs.
• Manage the lifecycle of analytics products, including intake, requirements gathering, development, testing, documentation, adoption support, maintenance, and retirement when needed.
• Build and maintain data models and transformation pipelines that turn raw source data into reliable, analysis-ready datasets, partnering with the data engineering team on upstream infrastructure while owning the transformation and modeling layer that feeds BI products.
• Combine data from multiple systems, including data warehouses, CRM platforms, spreadsheets, and other operational sources, into reliable, analysis-ready datasets.
• Identify, investigate, and resolve data quality issues by understanding source systems, business logic, transformation rules, and data lineage.
• Support process automation and reporting improvements that reduce manual work, improve consistency, and strengthen trust in organizational data.
• Prototype and test AI-enabled tools, agents, or assistants that help teammates ask questions of data, generate insights, or streamline analytical workflows.
• Use AI-assisted tools to support tasks such as SQL drafting, analytical prototyping, documentation, summarization, anomaly detection, and recurring report generation.
• Evaluate AI experiments on real use cases, documenting what worked, what did not, risks identified, and whether the solution is appropriate to scale.
• Apply responsible AI practices — including awareness of model limitations, hallucination risk, data privacy, and governance requirements — and ensure human validation of all AI-assisted outputs before use in decision-making.
• Deliver actionable insights through data storytelling — translating technical findings into narratives that drive understanding and alignment.
• Present complex analyses to executive and non-technical audiences with clarity and confidence.
• As needed, use generative AI to draft initial narrative structures or executive summaries from analytical findings, refining and fact-checking outputs to ensure accuracy, tone, and alignment with priorities.
• Collaborate across departments to align reporting and analytics initiatives with organizational goals.
• Demonstrate a growth mindset by proactively seeking new tools, methods, and learning opportunities to enhance analytical capability.
• Stay current on emerging AI capabilities relevant to BI/analytics (e.g., natural-language querying, AI-assisted coding, automated insight generation) and proactively recommend adoption where it improves accuracy, speed, or accessibility of analytic products.
• Contributes to project teams or special initiatives.
• Collaborates with consultants or vendors as needed.
• Procures and manages datasets and analytic resources as needed for work products.
• Serves as a change agent to promote new ways of working and continuous improvement.
• Performs other duties as assigned.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level