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