POSITION TITLE: Data Engineer I
Supervised by: Data Engineer III - Team Lead
FLSA Status: Full-time, Exempt/Salaried
Location: HQ in Brecksville, OH; this position can be remote (home based)
The Data Engineer I 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 I 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.
JOB DUTIES and ESSENTIAL FUNCTIONS: A qualified individual must be able to perform these essential functions of the job as listed, with or without accommodation. (An Asterisk (*) Identifies an Essential Function).
- Extracts all data from legacy database systems. (*)
- Under the guidance of DE II or DE III, can establish connectivity to client legacy database
- Establishes basic ODBC connectivity to various database types.
- Kicks-off extract process and monitors the process during runtime
- Identifies extract errors and performs simple troubleshooting steps.
- Uses Structured Query Language (SQL) commands needed to browse the database and view data before extraction
- Compares layout of the legacy database with the layout of the extraction to ensure that all tables and expected row counts match
- Performs quality assurance checks on extraction 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. (*)
- Under guidance of DE II or DE III, loads flat file data into a SQL Server Database.
- Exports large directories of files, and extracts metadata stored in the directory listing. Resulting output is in a tabular format, linking the metadata to the corresponding file path
- Using scripting tools (i.e. Python, Java, C#, PowerShell/Bash, etc.), writes scripts to read, write, copy, rename, move, sort, or otherwise process many non-discrete data files.
- Reviews incoming datasets to check for errors and ensure validity.
- Acts as a second validator to review database layouts, and verifies that no data is missing from the legacy system.
- Uses MQ scoping language from the contract and determines if the dataset delivered falls within the expected scope, or if the dataset delivered does not match the expected deliverable.
- Collaborates with both the Client/Extractor and the DM/IC to ensure a smooth transition of the data between the extraction and the modeling
- Responsible for the location of the data. Communicates clearly to the team as the location of the data changes during the review process
- Runs detailed comparisons between table lists from the legacy system and the extracted dataset. Works with other team members to compare to past extract projects throughout MediQuant history.
- Troubleshooting and Problem Solving. (*) – Identifies problems and proactively intervenes to mitigate or eliminate potential for negative impact.
- Effectively checks work for accuracy, giving specific attention to error zones. Takes ownership to ensure own work is error-free.
- Conducts independent research when issues are identifies; and problem-solves. Recognizes when additional help is needed and proactively reaches out to mentors/leaders for help.
- Uses strong data analysis skills to debug data anomalies
- Applies technical knowledge and seeks to fully understand the client’s expectations by asking questions.
- Works collaboratively with project teams to innovate and find solutions to complex issues.
- Documents issues and resolutions for and “lessons learned” to avoid repeating.
- Liaise with application/tool developers, PMO, IT, or other sources to create tools needed to streamline workflows
- Organization and Time Management. (*) – Handles multiple projects and tasks and prioritizes deadlines.
- Identifies and utilizes all resources available when priorities conflict or when external challenges are lining up against the deadline. Must be able to clearly communicate with the PM and Lead, at the time conflicting priorities threaten delivery of scheduled tasks.
- Manages a fluctuating workload and prioritizes workload during times of peak demand and conflicting priorities. Knows when to seek assistance to ensure deadlines are met and quality is delivered
- Maintains organized notes and uses project management tools to keep project team updated with the latest statuses and roadblocks
- Attributes 90% of available time to billable initiatives for named clients, making sure that time is properly allocated on their timesheet.
- Collaboration Skills
- Organizational Skills
- Interpersonal and Communication Skills
- Critical Thinking
- Problem Solving/Analysis
- Team Player
- Time Management
Required Education and Experience
- Bachelor’s degree in Computer Science, Computer Engineering, Software Engineering, preferred. High School Diploma or GED with 1-3 years of applicable experience in computer science related field required.
- Programming Skills
- Basic 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
- Able to understand database catalog, schema, and table layouts
- Basic understanding of healthcare data terminology (Clinical, Financial, Accounts, Visits, Charges, etc.) to help with scope review and understanding the datasets that are under review.
Additional Eligibility Qualifications
- 1-3 years’ experience in Healthcare IT or clinical environments, preferred
- Past experience extracting Healthcare data, preferred
- 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
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/Security Clearance (if applicable). In compliance with Federal employment laws, MediQuant will verify the identity and employment authorization of each person hired.
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.