Data Analyst

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

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Paid time off

401k employer contribution

Referral bonus

Pre-tax transportation and parking

Job summary

AlohaCare is seeking a Data Analyst to extract data from databases using SQL and analyze it with data tools. You will prepare reports, develop Power BI dashboards, and support data-driven decisions across programs.

Qualifications include a Bachelor’s degree in a related field and at least 1 year of experience with SQL, Excel, and BI tools. AlohaCare values teamwork and confidentiality in a fast-paced health care setting.

Qualifications

• Bachelor’s degree in a field related to data analysis, information systems, statistics or health sciences.
• 1 year of professional training or work experience.
• Experience using SQL, Excel, and analytic tools; understanding conditional statements.

Responsibilities

• Extracts data by querying databases with SQL and analyzes data using various tools.
• Develops BI reports in Power BI or QlikView.
• Supports data-driven decisions and prepares accurate reports for stakeholders.
• Maintains documentation for data requests and datasets.

Education

Bachelor’s degree in a relevant field

Tools

SQL

Excel

Power BI

R/SAS/SPSS

Job description

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.