Primary work will consist of designing and implementing the data architecture for a common data model (OMOP) based on data from our existing Virtual Data Warehouse (VDW) and EPIC Electronic Health Record. The OMOP data model will support the efforts of the MEHRC, a consortium of health systems working in coordination with public health agencies to conduct innovative public health surveillance, research, and evaluation in Minnesota. The Research Informatics Analyst position will also serve as an analyst in the HHCJ Lab, supporting the Lead Data Scientist in assisting researchers in the development of data requests, fulfilling data requests from researchers and healthcare staff, and conducting analyses as part of a team.
Work is creative, fast-paced, and highly collaborative. Ideal for someone from an IT, informatics, data science or analytics background with strong experience working with relational databases and a desire to harness their skills to support health equity research in Minnesota.
This will be a remote position until lab co-directors and research institute leaders deem it safe to return to the office. Once staff return to the office, this will become a hybrid remote position, working from our office in downtown Minneapolis 1-2 days per week, with the option to work from home or the office the rest of the week.
ESSENTIAL JOB FUNCTIONS:
- Map OMOP data model from VDW data model and EPIC.
- Plan OMOP mappings from VDW and EHR
- Write SQL code to implement mappings
- Work independently to accomplish project goals
- Participate in quality assurance for the OMOP model
- Participate in MEHRC OMOP development activities
- Work closely with VDW Lead Data Scientist, Hennepin Healthcare staff, and collaborators at the MEHRC to meet project deadlines and conduct data quality checks
- Work with other health systems involved in the project to give and receive assistance in developing the data model
- Fulfill VDW data and analysis requests using SAS, SQL, R, or similar statistical package
- Collaborate with HHCJ Lab researchers on projects related to health equity, homelessness, and the criminal justice system
NON-ESSENTIAL JOB FUNCTIONS:
- Participate in VDW quality assurance processes
- Contribute to complex analyses, including statistics, modelling and predictive analytics
- Build code to format and automate data processes, including coding in R, Python, SAS or SQL
- Construct data mappings from other data sources outside of the EHR, including geocoding
- Work with interactive data visualization products such as Power BI, Tableau or similar
- Evaluate and propose data methods and technologies for improving data resources at the HHCJ lab
Any equivalent combination of education and experience that provides the required knowledge and skills is qualifying. Typical qualifications would be a Bachelor of Science (B.S.) or Engineering (B.E.) in computer science, information technology, data science, statistics, or a related field, with at least four years of applicable experience. Previous experience with electronic health record data is preferred.
Skill, Knowledge & Ability (SKA):
- Experience working with and querying data from relational databases using SQL or SAS
- Ability to follow and establish standard operating procedures within and across research projects and systems (health care, public health, academic, government, community-based organizations)
- Ability to work independently within guidelines, be organized, and establish priorities. Displays high standards of attendance and punctuality, maintains confidentiality, and manages time effectively
- Experience working with health care data
- Certification in one or more EPIC modules
- Understanding of data quality assurance best practices and processes
- Desire to participate in research and contribute to project development and analysis
- Experience with R, Python, SAS or similar statistical packages
- Experience using data models in a healthcare setting, including the HCSRN or OMOP data models
- Demonstrated interest and aptitude in emerging data methods and technologies.
MANDATORY COVID-19 VACCINE REQUIREMENT
AA/EOE of Minorities, Women, Disabilities, Veterans