Data Engineer Data Operations

Cotiviti is a company focused on data engineering to drive quality and timely processing in the healthcare sector. They are seeking a Data Engineer to develop tools for improving process efficiencies and query performance, while working with healthcare data management and ETL processes.

Responsibilities:

• Data Mapping and Programming
• Work as a team member in creation and maintenance of ETL scripts, tools, queries and applications used for healthcare data management, data validation, statistical report generation, and program validation
• Work as a team member to develop tools and techniques for improving process efficiencies and query performance
• Program per data transformation specifications to convert source data to be loaded into target data warehouse tables using T-SQL and other Data Integration/ETL tools
• Review & test the data to ensure accuracy & validity prior to uploading the data to the warehouse
• Perform data analysis, data mining and investigations and identify root cause of issues with SQL queries
• Work with Technical Operations to troubleshoot complex database issues related to the entire environment including OS, storage and servers. Provide off hours On-Call support to resolve production issues when necessary
• Complete all responsibilities as outlined in the annual performance review and/or goal setting
• Complete all special projects and other duties as assigned
• Must be able to perform duties with or without reasonable accommodation

Requirements:

• Bachelor's degree in relevant field such as Computer Science, Engineering, a related field, or equivalent experience
• 2+ years' experience with data aggregation, standardization, linking, quality check mechanisms, and reporting
• 2+ years' experience within the Healthcare or Insurance space in a Data Warehouse operations organization
• Strong knowledge of healthcare enrollment, medical claims, and drug claims data required
• Experience with RDBMS (SQL, Oracle, SQL, Vertica, etc.) and using T-SQL or other data integration/ETL tools
• Experience in the Analysis, design and development of solutions and strategies for creating extraction, transformation, loading (ETL) and real-time applications
• Experience with ticketing and documentation tools such as Jira
• Strong knowledge of coding and ability to follow best practices while developing and deploying codes
• Excellent written and verbal communication skills, with the ability to multitask and prioritize projects to meet scheduled deadlines
• Ability to analyze data with a high level of detailed accuracy and identify root causes of issues using queries
• Ability to work well independently or in a team environment
• Proficient in Microsoft Office Suite, including PowerPoint, Word, Excel, Outlook and Project
• Exceptional communication, problem-solving, and leadership skills
• Advanced analysis, problem-resolution, judgment, and decision-making capabilities
• Ability to prioritize and execute complex tasks in a high-pressure environment independently
• Strong results orientation, initiative, attention to detail, and customer service focus
• Expert time management skills, balancing daily operations, projects, and mentorship
• Ability to independently prioritize, re-prioritize, and manage multiple complex tasks
• Additional knowledge of non-traditional data types (health & wellness, workforce productivity, and EMR) preferred
• Understanding of new technologies like HDFS and NOSQL are a plus