About
Full Time Professional Independence, OH, US
9 days ago Requisition ID: 1216
Supervised by: Data Engineer III - Team Lead
POSITION SUMMARY 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 the 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 mentors DE I team members, contributes to the improvement of extraction and load processes, and has a higher level of understanding of legacy system databases.
JOB DUTIES AND ESSENTIAL FUNCTIONS
Extracts all data from legacy database systems. (*)
Using existing software tools, establish connectivity to client legacy database
Kicks off extract process and monitors process during runtime
Use Structured Query Language (SQL) commands to browse and view database before extraction, and query database‑level statistics to estimate the volume of data to be extracted
Compare the layout of the legacy database with the layout of the extraction to ensure that all tables and expected row counts match
Perform quality assurance checks on extractions to ensure work is accurate and reliable before it is passed on to the next team
Loads various discrete and non‑discrete data sources into a Microsoft SQL Server environment. (*)
Use existing tools to load flat file data into a SQL Server database
Convert different file types, documents or images into PDF format
Reviews incoming datasets to check for errors and ensure validity. (*)
Act as a second validator after the person who extracted the data; review database layouts and verify that no data is missing from the legacy system
Use MQ scoping language from the contract to determine if the dataset delivered falls within the expected scope or if it does not match the expected deliverable
Collaborate with Client/Extractor and DM/IC to ensure a smooth transition of the data between extraction and modeling
Locate data and communicate to the team as the location of the data changes during the review process
Run accurate, detailed comparisons between table lists from the legacy system and the extracted dataset; work with other team members to compare to past extract projects throughout MediQuant history
Troubleshooting and Problem Solving. (*)
Identify problems and proactively intervene to mitigate or eliminate potential negative impacts
Effectively check work for accuracy, understanding where opportunities for errors exist; take ownership to ensure own work is error‑free
Research and problem‑solve independently; recognize when additional help is needed and proactively reach out to mentors/leaders
Use strong data analysis skills to debug data anomalies
Work collaboratively with project teams to innovate and find solutions to complex issues
Document issues and resolutions for lessons learned to avoid repetition
Apply technical knowledge and seek to fully understand the client’s expectations by asking questions
liaise with application/tool developers, PMO, IT, or other sources to create tools needed to streamline workflows
Organization and Time Management. (*)
Handle multiple projects and tasks and prioritize deadlines
Identify and utilize all resources available when priorities conflict or when external challenges arise; clearly communicate issues to PM and Lead
Handle a fluctuating workload and prioritize during peak demand and conflicting priorities; seek assistance when needed to meet deadlines and deliver quality
Keep organized notes and use project management tools to keep project team updated with the latest statuses and roadblocks
Attribute 90% of available time to billable initiatives for named clients, ensuring time is properly allocated on timesheets
Mentor DE I team members, teaching extract and load processes and assisting in issue resolution
Develop documentation to explain steps for resolving errors and troubleshooting extracts; make documentation available to team and DE I members
Process Improvement. (*)
Work with DE III to actively improve and refine extraction and load processes
Examine codebase of existing MediQuant tools and edit new functionalities or debug discovered issues during tool use
Assist DE III in developing standard procedures and processes; support rollout through mentoring
QUALIFICATIONS
Leadership skills
Organizational skills
Interpersonal and communication skills
Critical thinking
Problem solving/analysis
Team player
Self‑motivated / self‑starter
Time management
REQUIRED EDUCATION AND EXPERIENCE
Bachelor’s degree in Computer Science, Computer Engineering, or Software Engineering preferred. High School Diploma or GED with 3‑5 years of applicable experience in a computer‑science related field required.
Programming Skills
Advanced knowledge of SQL scripting, able to query and transform data
Proficiency in one of the following languages: Python, Java, or C#
Familiarity with PowerShell or Bash scripting
Excellent organizational and documentation skills
At least one 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 under review. Experience working with healthcare datasets preferred.
ADDITIONAL ELIGIBILITY QUALIFICATIONS PREFERRED EXPERIENCE WITH LEGACY SYSTEMS (for example, but not limited to)
Meditech (Magic, Client Server, 6.0, etc.)
NextGen
CPSI
eClinicalWorks
SunQuest
Medhost
PREFERRED EXPERIENCE WITH DATABASES (for example, but not limited to)
InterSystems Cache
Sybase
IBM DB2
Oracle
MySQL
Microsoft SQL Server
Detailed knowledge of common database error messages; able to identify extract errors and derive solutions through research or prior knowledge
Knowledge of database catalog, schema, and table layouts
Ability 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 (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 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 of HIPAA regulations involving PHI and HITECH.
Strong customer service and information technology acumen.
OTHER DUTIES Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
WORK AUTHORIZATION In compliance with Federal employment laws, MediQuant will verify the identity and employment authorization of each person hired. MediQuant participates in the Federal E‑Verify program.
SECURITY CLEARANCE 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.
AAP/EEO STATEMENT MediQuant, Inc. is an equal opportunity employer.
COMPLIANCE Employee shall comply with all MediQuant policies, state and federal laws, regulations, and contractual obligations when accessing MediQuant or client confidential data, confidential information, and information assets.
WORK ENVIRONMENT This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines. While performing some duties of this job, the employee is exposed to dust or other airborne particles. The noise level on the job site is typical of an office environment.
PHYSICAL DEMANDS While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to sit for long periods of time, stand, walk, use hands to finger, handle or feel, and reach with hands and arms. The employee is occasionally required to climb or balance; and stoop, kneel, crouch or crawl. The employee must occasionally lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.
POSITION TYPE AND EXPECTED HOURS OF WORK This is a full‑time position, and hours of work and days are typically Monday through Friday, 8:30 a.m. to 5 p.m. Some flexibility in hours is allowed, but the employee must be available during the core work hours of 9:00 a.m. to 3:30 p.m. and must work 40 hours each week to maintain full‑time status. Occasional evening and weekend work may be required as job duties demand.
TRAVEL Little to no travel is expected for this position.
#J-18808-Ljbffr
Languages
- English
Notice for Users
This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.