Data Engineer - Research Administration

at University of Kansas Medical Center in Kansas City, Kansas, United States

Job Description

• Design, develop, and maintain data pipelines and databases to support clinical and population health research
  
• Transcode electronic health record (EHR) data (e.g., from eClinicalWorks) into common data models for use in research
  
• Act as an honest broker to prepare deidentified or limited datasets in compliance with institutional and regulatory policies
  
• Ensure data quality, security, and compliance with HIPAA, IRB, and institutional standards
  
• Collaborate with researchers and clinicians to gather data requirements and deliver technical solutions
  
• Develop and optimize analytic datasets for investigators and research teams
  
• Document data workflows, processes, and schema to support transparency and reproducibility
  
• Develop dashboards and data visualizations to support research and reporting needs
  
• Contribute to the development of infrastructure to support new data sources and research partnerships
  
• Participate in team meetings, training, and cross-campus collaboration to align with institutional research priorities
  

• Bachelor's degree in computer science, information technology, informatics, or a related field. Education may be substituted for experience on a year for year basis.
  

• 3 years of experience in data engineering, database management, or a related role, preferably in a healthcare or research setting.
  
• 2 years' experience working with SQL and database management systems (e.g., MySQL, MS SQL Server, PostgreSQL).
  
• 1 year experience with data integration tools and ETL (Extract, Transform, Load) processes.
  
• 1 year of experience working in a healthcare, clinical, or research data environment
  
• Knowledge of programming languages such as Python or R for data manipulation and analysis.
  

• Master's degree in biomedical informatics, computer science, data science, or a related field. Education may be substituted for experience on a year for year basis.
  

• 2 years of experience working with healthcare data standards and systems (e.g., Epic, eClinicalWorks, REDCap, OMOP).
  
• 2 years of experience developing ETL processes in a cloud or distributed computing environment.
  
• 1 year of experience serving as an honest broker or handling deidentified/limited datasets in compliance with HIPAA and IRB protocols.
  
• 1 year of experience collaborating directly with clinical or academic research teams to gather data requirements and deliver technical solutions.
  
• Familiarity with clinical data standards and healthcare databases (e.g., Epic, CIBMTR, REDCap, OMOP).
  

• Strong problem-solving skills and attention to detail.
  
• Analytical thinking
  
• Excellent communication and interpersonal skills.
  
• SQL and relational database management
  
• ETL development and data integration
  
• Programming in Python or R
  
• Data documentation and workflow tracking
  
• Understanding of data privacy and security regulations (e.g., HIPAA)
  
• Collaboration with technical and non-technical stakeholders
  
• Clinical data standards (e.g., OMOP, HL7, FHIR)
  
• Cloud-based data platforms (e.g., AWS, Azure)
  
• EHR systems such as Epic or eClinicalWorks
  
• Data visualization and reporting tools (e.g., Tableau, Power BI)
  
• Natural Language Processing (NLP) or machine learning techniques
  
• Knowledge of version control systems (e.g., Git)