Data Analyst

Data Analyst

AlohaCare is a local, non-profit health plan serving Hawai`i's low-income residents with free Medicaid and dual Medicare health insurance coverage. Our members include children, seniors and adults residing on all islands. We provide comprehensive benefits and managed care services with an emphasis on healthy living habits and preventive primary health care. Our approach is to meet the whole-person health and social needs of members. Through our community partnerships we offer innovative services such as connection to social service agencies, Native Hawaiian healing services and in-home primary care for qualified members. Our mission is to serve in the true spirit of aloha by ensuring and advocating for access to quality health care for all. We are Hawaii's third-largest health plan and offer a wide network of quality primary care, specialists, hospitals, pharmacies and among many other providers across the state.

AlohaCare employees have a passion for helping Hawai`i's most underserved communities. Our caring culture is fundamental to our company-wide team approach to providing high quality services. We support our employees with a supportive and positive work environment, healthy work-life balance, continuous communication, and a generous benefits package.

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.
• All other duties assigned.
• Adhere to regulatory compliance and quality guidelines as well as AlohaCare policies and procedures.
• 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.
• Strong interpersonal and facilitation skills with the ability to communicate with all levels of the organization.
• Strong, effective, and precise written and oral communication skills; speak clearly and persuasively in positive or negative situations.
• Professional telephonic etiquette skills.
• Ability to solve problems, analyze, think critically and make good judgment.
• Strong customer service skills and be able to work in a diverse, demanding and evolving environment with strong conflict and problem resolution skills.
• 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.
• Experience in the operation of general office equipment to include PC, fax/copy machine and phone system.

Preferred Requirements:

• 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.

Mental, Physical and Environmental Demands:

• Sedentary Work: Exerting up to 20 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull, or otherwise move objects. Sedentary work involves sitting most of the time but may involve walking or standing for brief periods of time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.
• In office working environment.
• 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.