Healthcare Data Engineer/Architect with ETL, Tableau, SAS, SQL Server, DBA, R/Python and Medicaid/Medicare/insurance/claims experience

Request ID: BL-9517-1 (97590914)

Healthcare Data Engineer/Architect with ETL, Tableau, SAS, SQL Server, DBA, R/Python and Medicaid/Medicare/insurance/claims experience

Location: Columbia SC
Duration: 6 Months Hrs/Wk: 37.50

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
• Master’s Degree and 3 years of relevant experience; OR Bachelor’s Degree with major courses in a technical field and five years of relevant experience
• Experience with large relational database administration
• Demonstrated experience in healthcare claims data management and analysis, such as Medicare, Medicaid, and private insurance data
• Proficiency in R/Python or other scripting language
• Experience working with ETL processes
• Interest in public health or issues relevant to health services research and health program/policy evaluation
• Ability to exercise sound judgment in making decisions and maintain thorough documentation of the decision-making process
• Exemplary communication skills and ability to effectively communicate complicated processes to diverse audiences within and outside OHSU
• Strong commitment to rigorous research methods, objectivity and accuracy of findings, and reproducibility of results

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
• Experience with Medicaid claims data
• Knowledge of structuring data for Tableau
• Knowledge of SAS
• Strong knowledge of SQL
• Experience working in Windows environment

REQUIRED EDUCATION/CERTIFICATIONS:
Master’s Degree and 3 years of relevant experience; OR Bachelor’s Degree with major courses in a technical field and five years of relevant experience.

REQUIRE THREE REFERENCES-ONE TO BE A FORMER SUPERVISOR

Experience
Database Platforms MS SQL No 1 Advanced Within 1 Year 2 – 4 Years
Miscellaneous ETL Process and Development Yes 1 Advanced Within 1 Year 2 – 4 Years
Miscellaneous Tableau No 1 Advanced Within 1 Year 2 – 4 Years
Programming Languages Python Yes 1 Advanced Within 1 Year 2 – 4 Years
Programming Languages SAS No 1 Advanced Within 1 Year 2 – 4 Years

Remote Work Availability: 0%

Here at the Division of Integrated Health and Policy Research (IHPR) at UofSC’s Institute for Families in Society (IFS), we are committed to using innovative and forward-looking software and development tools to transform large scale diverse data into meaningful insights and to share our research mission with partners and the wider community. The Data Engineer provides high-level professional analytic support in research activities at The Institute is devoted to transforming health systems through actionable cross-disciplinary and collaborative research. This position will lead the ongoing development and maintenance of IHPR’s analytic and data management systems. Sponsorship not available. Must be willing to relocate.

DAILY DUTIES / RESPONSIBILITIES:
• Management of large databases of health insurance claims from Medicaid, Medicare, and all-payer warehouses, other state administrative datasets, as well as EHR data, and development of validation processes to ensure data quality
• Building out and automating various Extract, Transform, Load (ETL) processes across the Institute
• Coordination and problem-solving with Institute faculty/staff in order to understand needed support and use cases
• Development of innovative solutions to fill gaps in analytics
• Active contribution to the review of working practices and the development of data analysis and management standard operating procedures
• Performance of other research related duties as assigned

Leave a Reply