Data Engineer

Overview

At Cotiviti, we are custodians of data for our clients. Using their technical experience in ETL processes, Data Engineers ensure operational functions are occurring as expected. This includes but is not limited to managing data implementations, data production, data quality, and data security.

Responsibilities

• Oversee ETL processes to ensure their success, with the primary responsibility of providing accurate and timely data across various products to support the company's revenue generation.
• Maintain data pipelines running on proprietary big data processing platform and providing support to make sure data delivery SLAs are met.
• Maintain data engineering processes using a variety of tools including T-SQL, Spark and Scala, and shell scripting. Generally focused on data ingestion for healthcare data management, data validation, statistical report generation, and program validation.
• Develop, support, and improve scalable and efficient data ingestion processes and techniques aimed at enhancing process efficiencies and optimizing query performance for our proprietary data applications and systems.
• Implement and perform data validation and quality checks to maintain high data integrity.
• Perform troubleshooting, data analysis, data mining, investigations and identifying root cause of issues using several cutting-edge data analysis tools in a fast-paced environment.
• Collaborate with stakeholders to understand data requirements and deliver high-quality data solutions.
• Work with Technical Operations to troubleshoot complex database issues related to the entire environment including OS, storage, and servers.
• Provide off hours support to resolve production issues when necessary
• Develop data transformation specifications to convert source data to be loaded into target data warehouse tables using SQL and other Data Integration/ETL tools.
• Support the implementation of data governance policies and security measures to protect sensitive information.
• Create and maintain dashboards as needed.
• Participate in meetings with clients and/or stakeholders.
• Complete individual productivity tracking
• Complete task assignments using department ticketing system within assigned deadline.
• Achieve organizational and individual goals as identified in performance reviews and goal setting exercises.
• Complete all special projects and other duties as assigned.
• Must be able to perform duties with or without reasonable accommodation.

This job description is intended to describe the general nature and level of work being performed and is not to be construed as an exhaustive list of responsibilities, duties and skills required. This job description does not constitute an employment agreement and is subject to change as the needs of Cotiviti and requirements of the job change.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology or equivalent work experience.
• 2+ years of working knowledge of RDBMS (Oracle, MS SQL, Vertica, etc.) and experience using SQL, PL/SQL or other data integration/ETL tools.
• MUST: 2+ years of experience in data engineering, data analysis, or a related field with a strong track record of building and managing data pipelines.
• MUST: 2-4 years’ experience with data aggregation, standardization, linking, quality check mechanisms, and reporting
• MUST: 2-4 years’ experience with big data technologies like Hadoop and Spark
• MUST: Proficient and experienced in analyzing, designing, and developing solutions and strategies involving relational databases (e.g., Oracle, Vertica, SQL Server), ETL tools (e.g., SSIS, ODI, Informatica), and data warehousing concepts.
• MUST: Solid understanding of Linux environments; strong knowledge of shell scripting and file systems.
• Knowledge of US healthcare data, preferably in data operations role, is a plus.
• Ability to analyze data with a high level of detailed accuracy, identify root causes of issues, and demonstrate problem-solving skills to troubleshoot data-related issues.
• Experience in coding principles and the ability to follow best practices for developing and deploying code for data manipulation and automation.
• Experience in at least one programming language such as Python, Java, Scala or Powershell.
• Knowledge of data governance principles, data quality, and data lifecycle management a plus.
• Proficient in Microsoft Office Suite applications PowerPoint, Word, Excel and Outlook.
• Flexible work schedule.
• Experience with project management tools like JIRA.
• Strong analytical skills
• Quick Learner, energetic and flexible
• Excellent verbal, listening and written communication skills.
• Ability to multitask and prioritize projects to meet scheduled deadlines and tight turnaround times.

Mental Requirements:

• 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.

Physical Requirements and Working Conditions:

• Remaining in a stationary position, often standing or sitting for prolonged periods.
• Repeating motions that may include the wrists, hands and/or fingers.
• Must be able to provide high-speed internet access / connectivity and office setup and maintenance.
• Must be able to provide a dedicated, secure work area.
• No adverse environmental conditions expected.

Base compensation ranges from $80,000 to $112,000 per year. Specific offers are determined by various factors, such as experience, education, skills, certifications, and other business needs.

Cotiviti offers team members a competitive benefits package to address a wide range of personal and family needs, including medical, dental, vision, disability, and life insurance coverage, 401(k) savings plans, paid family leave, 9 paid holidays per year, and 17-27 days of Paid Time Off (PTO) per year, depending on specific level and length of service with Cotiviti. For information about our benefits package, please refer to our Careers page.

Date of Posting: xx/xx/2025.

We anticipate that the application window will close on xx/xx/xxxx, but the application window may change depending on the volume of applications received or close immediately if a qualified candidate is selected.

Since this job will be based remotely, all interviews will be conducted virtually.

#junior