Data & Reporting Analyst

Hawaiian Humane Society; East Honolulu (HI); On-site; USD 65,000 - 85,000; Full time

Job summary

Hawaiian Humane Society in Hawaii seeks a data-focused professional to compile, analyze, and report organizational statistics for senior leadership. You will source data from PetPoint, Clinic HQ, and other systems, write SQL queries, develop reports, and maintain data integrity across platforms.

You will handle grant data, ensure confidentiality, train staff on data practices, and collaborate across departments on process improvements while supporting a dynamic animal welfare organization.

Qualifications

• Proficient in Microsoft Office Suite and database platforms, with the ability to quickly learn new software and systems.
• Knowledgeable in modern office procedures, equipment operation, and professional communication etiquette.
• Familiarity with Lean Six Sigma or other process improvement methodologies preferred.
• Microsoft SQL Server: Proficient in SQL Server database development (design, queries, stored procedures) and server administration.
• Proficient in SQL Server Reporting Services and Visual Studio for report design.
• Microsoft Windows Server: Proficient in basic server operations, task scheduling and file management.
• Education/Training: Associate's degree/Bachelor's degree in Math, Computer Science, Statistics, or equivalent portfolio/experience.
• Experience: 3 years of data entry, statistical and analytical experience.

Responsibilities

• Care for internal stakeholders and ensure data accuracy and accessibility.
• Compile, analyze, and report organizational statistics for senior leadership.
• Source data from PetPoint, Clinic HQ, and other systems; verify accuracy.
• Write and run SQL queries; develop reports and trend analyses.
• Document analytical methods and train staff on data collection practices.
• Ensure data confidentiality and governance across systems.
• Support grant reporting with data for applications and funder deliverables.
• Maintain records in PetPoint, Clinic HQ, SQL and other systems.
• Manage a reporting calendar and distribution lists across departments.
• Collaborate across departments on data needs and process improvements.

Skills

Microsoft Office

Data analysis

Statistical skills

Communication skills

Education

Associate's degree/Bachelor's degree in Math, Computer Science, Statistics, or equivalent portfolio/experience

Tools

SQL Server

SSRS

Visual Studio

SQL Server Management Studio

PetPoint

Job description

ESSENTIAL DUTIES/FUNCTIONS:

• People Care. Ensuring internal and external patrons (employees, volunteers, Hawaiian Humane partners and community members) and their needs are a primary focus. Communication and contact must be clear, understandable, cooperative, professional and respectful in all circumstances and will occur face to face, telephone, and electronic mail. Employees are expected to actively support a positive team environment, directly address conflict with the goal of problem solving, and appropriately express concerns. This position interacts with and collaborates with employees and volunteers at all levels of the organization.
• Customer Care.Deliver high-level customer service to Hawaiian Humane internal customers and community members. Communicate with a diverse group of people in a consistently compassionate, informative, respectful, and professional manner. Manage emotionally difficult situations with strong communication skills and empathy.
• Statistical Reporting & Data Analysis. Compiles, analyzes, and reports organizational statistics for Senior Leadership and supports ad hoc reporting needs across the organization. Sources data from PetPoint, Clinic HQ, and other systems; verifies accuracy; and investigates variances and anomalies. Produces reports, graphs, trend analyses, and Excel trackers, including data mapping for the annual Legislative session. Writes and runs SQL queries leading to report development. Documents analytical methods, trains others on data collection practices, and provides data-driven recommendations for process improvement.
• Data Confidentiality & Governance. Handles organizational data with the highest degree of discretion and integrity. Maintains confidentiality of sensitive operational, financial, and programmatic information and ensures data is accessed, stored, and shared in accordance with organizational policies and applicable regulations.
• Grant Reporting Support. Collaborates with the grant writer and relevant departments to pull, compile, and format statistical data required for grant applications, reports, and funder deliverables. Ensures accuracy and timeliness of data provided in support of the organization's fundraising and compliance obligations.
• Database Management & Data Entry. Maintains accurate and up-to-date records in PetPoint, Clinic HQ, SQL and other organizational systems. Performs routine and ad hoc data entry as needed to ensure data integrity across platforms, supports and trains staff in proper data entry practices and system utilization.
• Reporting Calendar & Distribution Management. Maintains a reporting calendar to ensure timely preparation and delivery of recurring reports. Manages distribution lists and ensures the appropriate reports reach the correct stakeholders on schedule.
• Interdepartmental Communication & Collaboration. Serves as a key resource across departments for data needs, and process improvement initiatives. Builds and maintains effective working relationships with staff at all levels, proactively communicating findings, timelines, and data-related updates to support informed decision-making organization-wide.

OTHER DUTIES/FUNCTIONS

• Operations Support. Work with other departments within the organization to resolve issues of mutual concern and improve operations.
• Other Duties as Assigned. May include organization-wide support as needed, including but not limited to participation in events, public speaking, fundraising, covering other operational departments, and assisting with Hawaiian Humane's role as a first responder to disasters.

JOB CONDITIONS:

• Work Environment: Indoors in an air-conditioned office.
• Equipment Use: PC (Google, Word, Excel, Adobe, Canva, PetPoint or Animal Shelter Management systems, SQL Server Management Studio, Microsoft Visual Studio), copy machine, scanner, fax machine, telephone, and other office equipment.
• Work Hours: Regular 40-hour work week, Monday - Friday typical schedule, with other hours based on operational requirements and other needs.

MENTAL, PHYSICAL AND COMMUNICATION DEMANDS:

• Strong organizational, written, and verbal communication skills.
• Ability to handle sensitive information with discretion, the highest degree of integrity, and maintain professionalism in appearance, conduct, and workspace.
• Ability to multitask, prioritize, and work accurately in a fast-paced environment.
• Ability to work independently and collaborate effectively across all levels of the organization.
• Ability to lift up to 30 lbs. with reasonable accommodation.
• Proficiency in Microsoft Office and ability to learn new systems quickly.
• Must exercise compassion, patience, professionalism, flexibility and tact when dealing with a broad range of employees, volunteers and the public including difficult, emotional or angry people.
• Must be detail oriented with problem solving skills.
• Must be committed to developing a deep knowledge of progressive animal welfare issues.
• Must agree with and be committed to Hawaiian Humane goals, objectives and programs.

QUALIFICATION REQUIREMENTS:

• Skills/Knowledge: Proficient in Microsoft Office Suite and database platforms, with the ability to quickly learn new software and systems. Knowledgeable in modern office procedures, equipment operation, and professional communication etiquette. Familiarity with Lean Six Sigma or other process improvement methodologies preferred.
• Microsoft SQL Server: Proficient in SQL Server database development (database design, writing queries and stored procedures, etc.) and Server Administration. Proficient in SQL Server Reporting Services and Visual Studio for report design.
• Microsoft Windows Server: Proficient in basic server operations, task scheduling and file management.
• Education/Training: Associate's degree/Bachelor's degree in Math, Computer Science, Statistics, or equivalent portfolio/experience.
• Experience: 3 years of data entry, statistical and analytical experience.

Employment Type:
Full Time

Compensation:
$65,000.00 to$85,000.00/ Year