Data Engineer

Job Purpose

We are seeking a highly skilled Data Engineer with experience in data architecture, integration, and analytics. The primary objective of this role is to design, develop, and maintain data systems and pipelines that ensure the efficient processing, storage, and analysis of medium to large datasets. This role will collaborate with cross-functional teams to understand data requirements and implement solutions that enhance data accessibility and usability. This role requires a strong foundation in data engineering principles, problem-solving abilities, the capacity to work with various data formats and structures and ensures data integrity and security.


Essential Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL processes.
• Integrate data from various sources, including Salesforce Non Profit Cloud, external API's and raw flat files.
• Develop and maintain data models and data warehouses using Snowflake or similar platforms.
• Write efficient SQL queries for data extraction, transformation, and reporting.
• Create dashboards and visualizations using Tableau or similar BI tools.
• Collaborate with cross-functional teams to understand data requirements and deliver solutions.
• Ensure data quality, integrity, and security across systems.
• Document data processes and provide training to end-users.
• Stay current with industry trends and emerging technologies in data engineering.

Other duties:

• Contributes to the Trust's success by accepting new assignments, helping team members, learning new skills, and striving to improves team and organization results.

Qualifications

• Bachelor's degree in Computer Science, Data Engineering, or a related field.
• 5+ years of experience in data engineering or related roles.
• Proficiency in Snowflake, Python, SQL, and Tableau.
• Experience with Salesforce Non Profit Cloud or similar CRM platforms.
• Strong understanding of data modeling, ETL processes, and data warehousing.
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills.
• Ability to work independently and manage multiple tasks effectively.
• Relevant certifications (e.g., Snowflake, Tableau, Salesforce) are a plus.

Job Competencies

• Teamwork - Collaborates effectively with team members and stakeholders.
• Solution Oriented - Identifies problems and actively works to resolve them.
• Time Management - Manages multiple tasks and prioritizes effectively.
• Focus - Understands user needs and expectations.
• Clear and Effective Communication - Communicates technical concepts in business terms.
• Resilience - Adapts to change and remains flexible.

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.

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 Engineer


Reports to: Director, Program Analytics

FLSA Status: Exempt

Aligned Executive: President and Chief Executive Officer

Kipuka: Lili'uonamoku

Department: Information Technology