Senior Technical Data Analyst II

Bank of Hawaii; Honolulu (HI); On-site; USD 120,000 - 160,000; Full time

Job summary

Bank of Hawaii is seeking a senior data analytics resource to translate business needs into practical data and reporting solutions that support informed decisions across the organization.

You will design reusable data datasets, data marts, and reporting structures, apply advanced SQL, and provide leadership to analysts while ensuring data quality and governance. Flexibility in hours and strong communication are valued.

Qualifications

• Minimum 7 years of related data analytics, business intelligence, or data solution development experience.
• Proficiency with advanced SQL, analytical dataset design, dashboard/reporting development, and translating business requirements into scalable data and reporting solutions.
• Demonstrated proficiency with Microsoft applications (Outlook, Word, Excel, Access, PowerPoint) or similar software; knowledge of Bank software and systems is a plus.
• Advanced knowledge in data management and data warehousing.
• Strong written and verbal communication and presentation skills across all management levels.
• Ability to lead teams, manage projects, and adapt to flexible hours including holidays, weekends and evenings.

Responsibilities

• Partners with business stakeholders and technology teams to translate objectives into scalable analytics, reporting solutions, and actionable recommendations.
• Designs and develops reusable analytical datasets and data marts to support multiple use cases and improve data consistency.
• Applies SQL and data design expertise to improve data accessibility, quality, and governance for reporting and analysis.
• Provides technical leadership and coaching to analysts, promoting reusable design principles and scalable analytics.
• Develops performance tracking, dashboards, and management reporting to align with evolving business priorities.

Skills

Advanced SQL

Data analytics

Dashboard design

Cross-functional collaboration

Communication skills

Education

Bachelor’s degree or equivalent

Tools

Microsoft Office

Job description

Description

Under the direction of the Manager, this position serves as a senior analytical resource responsible for translating business needs into practical data and reporting solutions that support informed decision-making across the organization. The role combines business partnership, advanced analysis, and strong technical judgment to improve the quality, consistency, and usability of data assets while helping strengthen the team’s overall analytics capabilities.

Responsibilities

• Partners with business stakeholders, analysts, and technology teams to understand business objectives, data requirements, and decision-making needs, translating complex questions into clear analytical approaches, scalable reporting solutions, and actionable recommendations.


• Designs and develops reusable analytical datasets, analytical data marts, and reporting structures that support multiple use cases across the organization, improve data consistency, and reduce reliance on one-off or request-specific data preparation.


• Applies advanced SQL and analytical dataset design expertise to improve data accessibility, performance, quality, and usability for reporting, dashboarding, and analysis; identifies and resolves data quality issues while supporting sound data governance practices.


• Provides technical leadership and coaching to analysts by teaching solution design principles for reusability, scalability, and modern reporting; supports code reviews and promotes standards that strengthen the team’s capabilities in scalable analytics, data preparation, and reporting enablement.


• Develops, maintains, and continuously improves performance tracking, dashboards, management reporting, and related analytical processes to ensure metrics remain accurate, timely, scalable, and aligned with evolving business priorities; performs other related responsibilities and duties as assigned.

Qualifications

• Bachelor’s degree from an accredited institution or equivalent work experience.




• Level is dependent on years of experience and size/complexity of prior positions held.



• Minimum 7 years of related data analytics, business intelligence, or data solution development experience, including proficiency with advanced SQL, analytical dataset design, dashboard/reporting development, and translating business requirements into scalable data and reporting solutions.



• Demonstrated proficiency and expertise with personal computers and Microsoft applications (Outlook, Word, Excel, Access, and PowerPoint) or similar software. Knowledge of or ability to use Bank software and systems.



• Advanced knowledge and skill proficiency in data management and data warehousing.


• Intermediate knowledge and skill proficiency in business acumen, critical thinking, cross-functional collaboration, customer experience, data analytics, data mining, data structures, and IT technical acumen.



• Demonstrated written and verbal communication and presentation skills to all levels of management. Possess strong analytical,organizational andproblem-solving skills toidentify opportunities and risks and make recommendations. Proficient in presentation development,report generation and database design and management. Strong business sense and ability to align change managementprocess to business needs in a complex environment. Must demonstrate strong project management and implementation skills. Proactive, curious, self-starter who requires minimal supervision with the ability to lead team members, build strong relationships, and work across multiple departments and divisions. Demonstrated drive to learn, research, and resolve issues independently or with others. Able to work flexible hours including holidays, weekends and evenings as necessary.

As a Bank of Hawaii employee, you ensure (or assist with ensuring) compliance with applicable laws, regulations, regulatory requirements and Bank policies and procedures, including but not limited to those related to Fair Banking, Anti-Money Laundering laws and regulations, Bank Secrecy Act and USA PATRIOT Act.
Delivering exceptional customer experiences is at the heart of what we do at Bank of Hawaii. We listen, understand and deliver what our customers need to help them build a better tomorrow.
We are