Jan 13 2023
Job Description


CLOSING DATE: September 24, 2022 or until filled. Applications received after this deadline may be considered only if the position is not filled or up to the date a selection has been approved by the RCUH (whichever comes first).

INQUIRIES:  Sean Okamoto 956-8848 (Oahu). 


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. Telework (from employee’s residence city and state) may be permissible subject to review and approval by Principal Investigator and RCUH. Continuation of employment is dependent upon program/operational needs, satisfactory work performance, availability of funds, and compliance with applicable Federal/State laws.


MONTHLY SALARY: Salary commensurate with qualifications.


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.



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: Three to five (3-5) 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.).


KNOWLEDGE: 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.

ABILITIES & SKILLS: Ability to effectively conduct work remotely (e.g., telework) as applicable.


Post Offer/Employment Condition: Must be able to pass a post offer criminal background check.


PHYSICAL/MEDICAL DEMANDS: Able to lift and carry up to fifty (50) pounds unassisted.


POLICY/REGULATORY REQUIREMENT: 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.

Please apply directly on the RCUH Website to be considered for this 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. 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. 

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


We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.