What are the responsibilities and job description for the Information Systems Intern position at AlohaCare?
Apply online at http://www.alohacare.org/Careers/Default.aspx
The Company
AlohaCare is a local, non-profit health plan serving the Medicaid and Medicare dual eligible population. We provide comprehensive managed care to qualifying health plan members through well-established partnerships with quality health care providers and community-governed health centers. Our mission is to serve individuals and communities in the true spirit of aloha by ensuring and advocating access to quality health care for all. This is accomplished with emphasis on prevention and primary care through community health centers that founded us and continue to guide us as well as with others that share our commitment. As Hawaii’s third-largest health plan, AlohaCare offers comprehensive prevention, primary and specialty care coverage in order to successfully build a healthy Hawaii.
The Culture
AlohaCare employees share a passion for helping Hawaii’s most underserved communities. This passion for helping and caring for others is internalized and applied to our employees through 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 through frequent diversity, recognition, community, and educational events and programs. AlohaCare has a strong commitment to support Hawaii’s families and reinforces a healthy work/home balance for its employees. Because AlohaCare values honesty, respect, and trust with both our internal and external customers, we encourage open-door, two-way communication through daily interactions, employee events and quarterly all-staff meetings. These employee-focused efforts contribute to a friendly, team-oriented culture which is positively reflected into the communities we serve.
Position Summary
The Information Systems intern is responsible for supporting the Data Analyst Manager and the System Configuration Manager in the various functions of the Information Systems Department, specifically the Business Support Services. This role handles tasks related to data extraction and analysis, preparation of reports and other tasks as needed that provide support to the team. Strong attention to detail and precise documentation are critical to the success in this role. The position requires the ability to exercise sound judgment and take initiative in addressing non-routine situations.
Primary Duties & Responsibilities
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/veterans’ status, or other characteristics protected under applicable state and federal laws, regulations, and/or executive orders.
The Company
AlohaCare is a local, non-profit health plan serving the Medicaid and Medicare dual eligible population. We provide comprehensive managed care to qualifying health plan members through well-established partnerships with quality health care providers and community-governed health centers. Our mission is to serve individuals and communities in the true spirit of aloha by ensuring and advocating access to quality health care for all. This is accomplished with emphasis on prevention and primary care through community health centers that founded us and continue to guide us as well as with others that share our commitment. As Hawaii’s third-largest health plan, AlohaCare offers comprehensive prevention, primary and specialty care coverage in order to successfully build a healthy Hawaii.
The Culture
AlohaCare employees share a passion for helping Hawaii’s most underserved communities. This passion for helping and caring for others is internalized and applied to our employees through 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 through frequent diversity, recognition, community, and educational events and programs. AlohaCare has a strong commitment to support Hawaii’s families and reinforces a healthy work/home balance for its employees. Because AlohaCare values honesty, respect, and trust with both our internal and external customers, we encourage open-door, two-way communication through daily interactions, employee events and quarterly all-staff meetings. These employee-focused efforts contribute to a friendly, team-oriented culture which is positively reflected into the communities we serve.
Position Summary
The Information Systems intern is responsible for supporting the Data Analyst Manager and the System Configuration Manager in the various functions of the Information Systems Department, specifically the Business Support Services. This role handles tasks related to data extraction and analysis, preparation of reports and other tasks as needed that provide support to the team. Strong attention to detail and precise documentation are critical to the success in this role. The position requires the ability to exercise sound judgment and take initiative in addressing non-routine situations.
Primary Duties & Responsibilities
- Develop business intelligence reports in PowerBI
- Work within the Microsoft Platform to better understand the new tools that we have access to and how we can better leverage them, including but not limited, to Power Pages, Power Automate and Bookings.
- Database related tasks including but not limited to, integrating data into a database, building tables and understanding the extract, transform, load (ETL) process and developing visualizations
- Utilize SQL to perform QA on data within our claims processing system to ensure accuracy while also documenting the findings
- Analyze and document CMS and Medicaid data that would need to be loaded into our claims processing system (ex: quarterly fees)
- 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.
- High school diploma or equivalent
- Current student entering their junior or senior year in an accredited undergraduate program in Computer Science, Business Administration, Public Health, Management or other related field.
- Prior experience using SQL, Excel and other statistical/analytical tools
- Intermediate skills using Microsoft Programs: Word, Excel, Outlook, and Powerpoint
- Strong verbal and written communication in English
- Ability to operate general office equipment to include PC, fax/copy machine, and telephone
- Positive attitude and ability to accept direction
- Strong problem solving and reasoning skills
- Excellent interpersonal skills and ability to work with cross functional teams
- Good prioritization and organizational skills
- 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.
- Requires prolonged operation of a computer workstation, including the ability to type for extended periods of time on a keyboard during the scheduled workday
- Inside working conditions
- No environmental hazards
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/veterans’ status, or other characteristics protected under applicable state and federal laws, regulations, and/or executive orders.
Salary : $15 - $17
