Nov 19 2021
Job Description



Telecommunications and Social Informatics.  (2) Regular, Full-Time, RCUH Non-Civil Service position with the Social Science Research Institute (SSRI), Telecommunication and Social Informatics (TASI) Research Program, located at the University of Hawai‘i (UH) in Honolulu, Hawai‘i. Continuation of employment is dependent upon program/operational needs, satisfactory work performance, availability of funds, and compliance with applicable Federal/State laws. 




DUTIES:  Works with team to develop and implement programs and code to apply business rules; Extract, Transform, Load (ETL) processes; and enhancements to data. Participates in data quality improvement and data quality assurance processes with subject matter experts, data submitters, stakeholders, and other team members. Develops and implements data quality checks on received data. Assists with developing processes to identify, communicate and resolve data anomalies and errors. Assists with developing the master person and master provider indexing processes. Conducts planning and implementation of data source integration, source to target mapping, data mapping, data product development, and other data management and related functions as with stakeholders and other team members. Documents data quality, ETL, and other data enhancement processes. Builds data products, including but not limited to, visualizations. 


PRIMARY QUALIFICATIONS: EDUCATION/TRAINING:  Bachelor’s Degree from an accredited four (4) year college or university in Computer Science, Engineering, Physics, Math, Statistics, Social Science, Management Information Systems, Information Technology, Pubic Health, or other related field.  EXPERIENCE:  At least three (3) years of experience with data management tools, Database Management System (DBMS) software, and programming. Experience must include documenting and rectifying data quality issues; writing Extract, Transform, Load (ETL) or Extract, Load, Transform (ELT) pipelines. Experience must include working in an implemented software development life cycle environment. (Master’s Degree from an accredited college or university in Computer Science, Engineering, Physics, Math, Statistics, Social Science, Information Technology, Public Health, or related field may substitute for two (2) years of experience.).  ABIL/KNOW/SKILLS:  Knowledge of research methods and statistical and/or analytical techniques. Knowledge of database management systems, and Open Database Connectivity. Knowledge of database administration procedures. Knowledge of programming structure and conventions. Knowledge of cybersecurity best practices; knowledge of server software, virtualization, and operating systems (e.g., Linux and Windows Server). Knowledge of healthcare claims data, healthcare coding structures. Working knowledge of research design, methodologies, analysis, and reporting. Working knowledge of database design principals. Working knowledge of systems development lifecycle methodologies. Basic knowledge of U.S. health systems and payer-provider relationship. Basic knowledge of Medicaid, Medicare, Children’s Health Insurance Programs, including statutory authorities, regulations. Basic knowledge of data resources of the federal government. Basic knowledge of 835, 837 i/p/d EDI ANSI X.12 and pharmacy claims data structures and data fields. Ability to conceptualize health concepts with data. Ability to develop and initiate strategies for data collection and integration. Ability to use statistical packages, computer applications or programs to analyze healthcare data sets, and/or other software for data management. Ability to manage processes to achieve objectives. Ability to translate business requirements into analytics solutions and creating dimensional models. Ability to contribute to research reports and publications or grant applications. Ability to manage database management systems. Post Offer/Employment Condition: Must be able to pass a post offer criminal background check. PHYSICAL/MEDICAL REQUIREMENTS:  Able to lift and carry up to fifty (50) pounds unassisted. POLICY AND/OR REGULATORY REQUIREMENTS:  As a condition of employment, employee will be subject to all applicable RCUH policies and procedures and, as applicable, subject to the University of Hawai‘i's TASI/PHIDC Research Program HIPAA/PHI privacy and security policy and the HIPAA/PHI privacy and security policy of various cooperating entities/organizations. Violation of the RCUH's, the UH's, or the business entity's policies and/or procedures or applicable State or Federal laws and/or regulations may lead to disciplinary action (including, but not limited to possible termination of employment, personal fines, civil and/or criminal penalties, etc.). Must complete the University of Hawai‘i's TASI/PHIDC Research Program HIPAA/PHI privacy and security training and the HIPAA/PHI privacy and security of various cooperating entities/organizations, training immediately after hire or not later than employee’s initial exposure to HIPAA/PHI. Must maintain a current status on the University’s and/or the business entity's training requirements.  


SECONDARY QUALIFICATIONS:  High proficiency in handling enterprise systems and data. Experience with cloud computing technologies and databases (e.g., Amazon Web Services, Microsoft Azure, Google Cloud, etc.). Experience working with or within healthcare data management and operational protocols relating to HIPAA and Health Information Technology for Economic and Clinical Health (HITECH) laws and regulations. Certificate in health informatics or analytics. Certificate in data warehousing or databases. 


INQUIRIES:  Umerang Imetengel 956-8848 (Oahu). 


Please apply directly on the RCUH website to be considered for the position.


APPLICATION REQUIREMENTS: Please go to www.rcuh.com and click on “Job Postings.” You must submit the following documents online to be considered for the position: 1) Cover Letter, 2) Resume, 3) Supervisory References, 4) Copy of Degree(s)/Transcript(s)/Certificate(s). All online applications must be submitted/received by the closing date (11:59 P.M. Hawai‘i Standard Time/RCUH receipt time) as stated on the job posting. All RCUH employees and positions are subject to the August 5, 2021 Emergency Proclamation requiring all State/RCUH employees to be fully vaccinated for COVID-19 or be subject to weekly testing for COVID-19.  All post-job offer/new hires will be required to show proof that they are fully vaccinated (e.g., their CDC COVID-19 Vaccination Record Card) or a Negative COVID-19 Test result during the onboarding process.  Requests for a religious or medical accommodation from the COVID-19 vaccination will be handled on a post-job offer basis.  Individuals granted an accommodation will be subject to the weekly testing requirement. If you do not have access to our system and the closing date is imminent, you may send additional documents to [email protected] If you have questions on the application process and/or need assistance, please call (808)956-7262 or (808)956-0872. 


CLOSING DATE:  December 26, 2021. 


RCUH’s mission is to support and enhance research, development and training in Hawai‘i, with a focus on the University ofHawai‘i.


Equal Opportunities Employer – Minorities/Women/Disability/Veteran.