Data Analyst

AlohaCare; Honolulu (HI); On-site; USD 50,000 - 64,000; Full time

Benefits offered by this job

Low-cost health insurance

Dental | Vision coverage

Paid time-off

401k employer contribution

Referral bonus

Pre-tax transportation/parking

Job summary

AlohaCare is seeking a Data Analyst to extract data from databases using SQL, analyze it with a range of tools, and deliver clear reports that support data-driven decisions. The role involves designing queries, developing BI reports (Power BI or QlikView), conducting ad hoc analyses, and collaborating with managers to meet reporting requirements in a fast-paced healthcare environment.

You will partner with colleagues across departments to identify data needs, build reliable data pipelines, and

Qualifications

• Bachelor’s degree in a related field or equivalent experience.
• 1 year of professional experience in data analysis or related role.
• Proficient in SQL and Excel; familiarity with statistical tools.
• Knowledge of relational databases and structures.
• Strong communication and teamwork skills.

Responsibilities

• Identify data requirements with managers and stakeholders.
• Design SQL queries, extract data, and analyze results.
• Prepare reports and present findings to stakeholders.
• Develop BI reports in Power BI or QlikView.
• Support routine reporting and health plan performance tracking.
• Support automated report development and documentation.

Skills

SQL

Excel

Data analysis

Power BI

Education

Bachelor's degree in relevant field

Tools

Power BI

QlikView

R

SAS

SPSS

Job description

Are you ready for new challenges and new opportunities?

Join our team!

Current job opportunities are posted here as they become available.

Subscribe to our RSS feeds to receive instant updates as new positions become available.

AlohaCare’s leadership empowers and engages its employees by recognizing outstanding job performance and collaboration. We share organization-wide updates during quarterly All Staff meetings. We encourage participation in volunteer and educational opportunities. We put a high value on honesty, respect, and trust-building. We encourage open-door, two-way, and frequent communication.

AlohaCare’s comprehensive benefits package includes low-cost medical, dental, drug and vision insurance, paid time-off, 401k employer contribution, referral bonus and pretax transportation and parking program.

The Data Analyst is responsible for extracting data from databases using SQL and analyzing the data using various analytical tools and methodologies. Conducts ad hoc analyses, prepares reports and presents information. The Data Analyst helps to enable adoption of analytic tools and data-driven decision making.

Primary Duties and Responsibilities:

• Identifies data requirements by partnering with managers and other stakeholders.
• Designs and develops SQL queries, extracts data from databases and analyzes the data using a variety of analytical techniques.
• Prepares accurate reports and presents findings.
• Develops business intelligence reports in Power BI or QlikView.
• Assists in the development of routine reports to satisfy contractual reporting requirements, track and trend health plan performance, effect and facilitate ongoing performance monitoring of program(s).
• Performs utilization analysis utilizing data from different sources and reports results.
• Creates and maintains supporting project documentation (SQL, data request, data sets) and ensures distribution of documentation to appropriate staff as required.
• Provides data and analytical support for department and organizational initiatives.
• Assists with standardized and automated report development.
• Provides training to AlohaCare staff on use of available statistical and analytical tools (e.g. Excel, R, reporting tools) as appropriate.
• Responsible for maintaining AlohaCare’s confidential information in accordance with AlohaCare policies, and state and federal laws, rules and regulations regarding confidentiality. Employees have access to AlohaCare data based on the data classification assigned to this job title.

Requirements:

• Bachelor’s degree with emphasis in computer science, information systems, mathematics, statistics, public health, health sciences, data analysis, accounting or related field or equivalent combination of education and experience.
• Minimum of 1 year of professional training or work experience, which demonstrates the ability to perform the duties required for the position.
• Prior experience using SQL, Excel, other statistical/analytical tools and understanding logic operators and conditional statements.
• Knowledge of relational databases and structures.
• Achieves results, builds trust, communicate effectively, customer and quality focused.
• Able to work independently with minimal supervision.
• Able to effectively work in a fast-paced and changing environment, manage multiple projects and priorities across multiple teams/projects and in a matrixed environment.
• Possesses excellent time management and organizational skills; is dependable, enthusiastic, self-starting, and self-motivated. Uses time effectively, reacts professionally under pressure.
• Advanced skills using Microsoft Programs: Word, Excel, PowerPoint and Outlook.
• Power BI or other business intelligence experience.
• Experience with computer systems and software programs such as R/SAS/SPSS or equivalent statistical package.
• Health care industry experience within managed care, hospital, medical office or equivalent preferred.
• Knowledge of health research methodology, biostatistics, and medical terminology.
• May require prolonged sitting- up to 4 hours.
• Requires prolonged operation of a computer workstation, including the ability to type for extended periods of time on a keyboard during the scheduled workday.
• ?

Salary Range: $50,000 - $64,000 annually

AlohaCare is committed to providing equal employment opportunity to all applicants in accordance with sound practices and federal and state laws. Our policy prohibits discrimination and harassment because of race, color, religion, sex (including gender identity or expression), pregnancy, age, national origin, ancestry, marital status, arrest and court record), disability, genetic information, sexual orientation, domestic or sexual violence victim status, credit history, citizenship status, military/veteran status, or other characteristics protected under applicable state and federal laws, regulations, and/or executive orders.