Data Modeling Analyst jobs in Honolulu, HI

Are you known for exceeding expectations? Do you embrace the Spirit of Hawai‘i? Then please keep reading because we’re looking for people like you at Hawaiian Host Group.

Who are we? Hawaiian Host Group (HHG) is a leading Hawai‘i-based consumer goods company with a portfolio of brands that includes Hawaiian Host, Mauna Loa, MacFarms, KOHO, and Kapua Orchards. Sold in over 23 countries, HHG produces a suite of products ranging from flavored macadamia nuts to artisan chocolates, and macadamia milk-based ice cream. Our dedicated team of Hosts of Hawai‘i is spread across our headquarters in Honolulu and offices in Hilo, Kona, Los Angeles, and Tokyo. HHG has 3 manufacturing plants in Hawai'i, as well as the state's largest single macadamia farm.   

We are an excited team of people that all have one vision in common: sharing the Spirit of Hawai‘i with the world. Expect camaraderie, product tastings, and other (virtual and in-person) events that make our culture unique. And more importantly, know that your work contributes to our purpose; to make the Islands’ future flourish. We do this through our Takitani foundation that grants scholarships to deserving local students, our solar farm on the Big Island, and other social & environmental initiatives.

That’s enough about us for now, we’d love to learn more about you. Read the job description below and let us know if you’re interested. We can’t wait to meet you!

Under the direction of the Director of Technology, the Data Analyst is responsible for day-to-day operational support, including but not limited to Electronic Data Interchange (EDI) management, developing, and maintaining the company’s information processing systems by researching, designing, and testing data management software to ensure it meets business requirements and industry standards. The Data Analyst will work with the stakeholders to automate data gathering, report generation and analytics. This may include working with department managers to customize reports and dashboards based on their business needs.

• EDI Program and Data Management
• Lead and oversee the implementation, maintenance, and optimization of the Electronic Data Interchange (EDI) program.
• Collaborate with cross-functional teams to ensure seamless integration of EDI processes with existing systems and applications.
• Stay updated on industry trends and advancements in EDI technology to drive continuous improvement.
• Manage and maintain electronic data repositories, ensuring data integrity and security.
• Develop and implement data management policies and procedures.
• Collaborate with data analysts to extract valuable insights from structured and unstructured data.
• Data Processing and Analytics
• Collaborate with senior management, business analysts and other stakeholders in the development of data products such as reports and dashboards.
• Design, develop and test ETL processes that make data easily consumable by end users and other systems per business requirements.
• Load/extract data from multiple data sources both on-premise and externally from the cloud.
• Use statistical methods to analyze data and generate useful business reports and dashboards.
• Identify and recommend new ways to save money by streamlining business processes through workflow automation and data integration.
• Use data to create models that depict trends in the customer base and the consumer population as a whole.
• Work with customers to outline the specific data needs for each business method analysis project.
• Plans and schedule project deliverables, goals, milestones.
• Ability to work independently and collaboratively in the development, testing, and implementation life cycles.
• Architecture and Data Maintenance
• Provide insight into the changing database storage and utilization requirements for the company and offer suggestions for solutions.
• Analyze database implementation methods to make sure they are in line with company policies and any external regulations that may apply.
• Document complex technical design/requirements for integrations and data warehousing.
• Help maintain the integrity and security of the company database.
• Customer Service and Troubleshooting
• Ability to communicate orally with customers, vendors, management, and coworkers is crucial. Regular use of phone and email for communication is essential. Hearing and vision correctable to within normal ranges are essential for normal conversations, receiving ordinary information, and preparing or inspecting documents.
• Serve as the primary point of escalation for all Tier 2 support from our Tier 1 vendor.
• Provide operational support for the IT department via the Help Desk ticketing system.

• Analyzes products and makes recommendations to IT Team.
• Updates job knowledge by participating in one or more of the following: educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
• Create and maintain documentation of IT processes and procedures.
• Travel to other sites Honolulu, Hilo, Kona, and Los Angeles.
• Perform other duties as assigned.
• Regular attendance is required for this position.

• Must have at least 1-2 years of experience with managing or administering EDI processes and/or systems.
• Must have at least 1-3 years of experience as a Data Technician, Database Developer, or ETL Analysis.
• Must have a bachelor’s degree (preferably in Information Systems, Computer Science, Mathematics, Statistics or related field from an accredited university or college); or at least five (5) years of relevant work experience.
• Experience with Microsoft technologies, including Dynamics, SQL Server, SSIS, SSAS, SSRS, Power BI, and Azure cloud services, preferred.
• Familiarity working with. Net Framework, JavaScript, and HTML.
• Advanced experience in developing custom data models, algorithms, data integration, data cataloging, and metadata management.
• Advanced analytical and problem-solving skills.
• Skills in database query language and semantic modeling are preferred.
• Skills in data analytics, reports, visualizations, and dashboards are preferred.
• Highly skilled in processes related to project life cycles, software development life cycles, requirements gathering, testing methodologies, and source control.
• Be dependable and have a good respect for diversity.
• Excellent communication, team building, and interpersonal skills with a customer-focused approach.
• Embrace values of building trust, staying agile, and focusing on innovation.

• The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions.
• While performing the duties of this job, the employee is frequently required to stand; walk; sit; use hands to finger; handle, or feel objects, tools, or controls; reach with hands and arms; lift, carry and/or move up to 50 lbs.; climb stairs; and talk or hear. The employee must occasionally stoop and kneel. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus.

• The position requires talking to co-workers and outside trade persons/vendors; written communication to co-workers and outside persons/vendors; responding to written or verbal requests of co-workers and vendors; reading; composing written language; receiving verbal instructions.

• Work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• 1) While performing the duties of this job, the employee is in a warehouse environment, but occasionally exposed to weather conditions when it is necessary to drive.
• 2) The noise level in the work environment is light to moderate.

Hawaiian Host Group is an Equal Opportunity/Affirmative Action Employer.