Data Engineer II

MediQuant LLC • Independence, OH

6d • Onsite

About The Position

The Data Engineer II is responsible for providing various database extracts of discrete and non-discrete data (i.e. documents, images, attachments, etc.) from various legacy applications. The DE II is also responsible for preparing and loading data into a Microsoft SQL Server environment. Additional activities for this position include transformation of discrete data, conversion of documents and images into formats supported by MediQuant software, and data analysis/quality assurance reviews of incoming data sets to ensure completeness and accuracy of the data. In addition to the responsibilities of the DE I position, the DE II is responsible for mentoring the DE I team members, contributing to the improvement of extraction and load processes, and having a higher level of understanding of legacy system databases.

Requirements

• Advanced knowledge of SQL Scripting skills, able to query and transform data
• Proficiency in one of the following programming languages: Python, Java, C#
• Familiar with PowerShell/Bash scripting
• Excellent organizational and documentation skills
• At least 1 year of experience in Healthcare IT or clinical environments, familiar with healthcare terminology
• Advanced knowledge of healthcare data terminology used in both Clinical and Financial systems to help with scope review and understanding the datasets that are under review.
• Detailed knowledge of common database error messages, able to identify extract errors and derive a solution through either research or previous knowledge
• Able to understand database catalog, schema, and table layouts
• Able to work with large directories of files, extract metadata stored in the directory listing, and export resulting output in a tabular format, linking the metadata to the corresponding file path
• Knowledge of scripting tools (i.e. Python, Java, C#, PowerShell/Bash, etc.) and ability to write scripts to read, write, copy, rename, move, sort, or otherwise process many non-discrete data files
• Proficient with ODBC drivers and is able to set up ODBC connectivity to various database types
• Ability to solve problems using logical thought processes and devising creative solutions
• High attention to accuracy and detail
• Ability and desire to work in a strong team culture
• Knowledge with HIPAA regulations involving PHI and HITECH
• Strong customer service and information technology acumen
• Must be able to pass all security clearances mandated by various government contracts as well as any client hospital/healthcare security requirements.
• Any employee working on government projects will be required to successfully pass a government background check and receive a Common Access Card (CAC).
• Additionally, the applicant must be a U.S. citizen and will be subject to a Public Trust security background investigation and must meet requirements to obtain a Department of Defense (DOD) network account.

Nice To Haves

• Bachelor’s degree in Computer Science, Computer Engineering, Software Engineering, preferred.
• Experience working with healthcare datasets preferred.
• Preferred Experience with Legacy Systems (for example, but not limited to): Meditech (Magic, Client Server, 6.0, etc.), Cerner (MS4, Siemens Invision, Millennium, Soarian, etc.), McKesson (Star, Series, Paragon, etc.), Allscripts (Pro, Touchworks, etc.), GE Centricity, NextGen, CPSI, eClinicalWorks, SunQuest, Medhost
• Preferred Experience with Databases (for example, but not limited to): Intersystems Cache, Sybase, PostgreSQL, IBM DB2, Oracle, MySQL, Microsoft SQL Server

Responsibilities

• Extracts all data from legacy database systems.
• Loads various discrete and non-discrete data sources into a Microsoft SQL Server environment.
• Reviews incoming datasets to check for errors and ensure validity.
• Troubleshooting and Problem Solving: Identifies problems and proactively intervenes to mitigate or eliminate potential for negative impact.
• Organization and Time Management: Handles multiple projects and tasks and prioritizes deadlines.
• Mentoring: Actively mentors DE I team members, teaching the extract and load processes and assisting in issue resolution.
• Process Improvement: Works alongside DE III to actively improve and refine the extraction and load processes.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: High school or GED