TASI DATA ENGINEER – ID# 222782

Nov 17 2022
Job Description

TASI DATA ENGINEER – ID# 222782

 

CLOSING DATE:  December 1, 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:  Umerang Imetengel 956-8848 (Oahu). 

 

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

 

Regular, Full-Time, RCUH Non-Civil Service position with the Social Science Research Institute (SSRI), Telecommunication and Social Informatics/Pacific Health Informatics Data Center (TASI/PHIDC) 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.

 

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, Public Health, or other related field.

EXPERIENCE

Three to five (3-5) years of experience with datamanagement 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

Abilitytoconceptualizehealthconcepts 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 publicationsorgrantapplications.Abilityto​managedatabase managementsystems.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.

 

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 of Hawai‘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.