Data Engineer AI
Remote, United States
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 integrations, data production, data quality, and data security.
Responsibilities
- Create, maintain and execute intermediate to advanced Spark scripts for data management and data validation, and data integration
- Create, maintain and execute basic to intermediate SQL scripts for data management and data validation.
- Optimize the queries to improve the efficiency of daily tasks.
- Perform data analysis and identify any issues.
- Work with other groups such as Engineering team, DBA, Cloud ops, etc. to troubleshoot and resolve any environmental or network issues that impact your work. Extend your support to after – hours or weekends as needed.
- Create and maintain data pipelines as needed
- Validates the tasks results to ensure that all the requirements are met.
- Adhere to all the industry level and organization level compliance rules and regulations to maintain data integrity.
- 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.
- 3+ years of working knowledge of big data technologies (Spark, S3, Kafka, Ray, Hadoop, etc.)
- 3+ years of working knowledge of cloud (AWS, Azure, GCP, OCI etc.)
- 3+ years of working knowledge of RDBMS (Oracle, MS SQL, Vertica, etc.) and experience using SQL, PL/SQL or other data integration/ETL tools.
- 3+ years of data analysis. Preferably in the Healthcare industry of enrollment, medical claims and/or pharmacy claims.
- Proficient in Microsoft Office Suite applications PowerPoint, Word, Excel and Outlook.
- Flexible work schedule.
- Experience with project management tools like JIRA.
- Databricks and/or Snowflake environment familiarity a plus
Mental Requirements:
- Strong analytical skills
- Excellent verbal, listening and written communication skills.
- Ability to multitask and prioritize projects to meet scheduled deadlines and tight turnaround times.
- Ability to work well independently or in a team environment.
Working Conditions and Physical Requirements:
- 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 a dedicated, secure work area.
- Must be able to provide high-speed internet access / connectivity and office setup and maintenance.
Base compensation ranges from $105,000 to $125,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.
Since this job will be based remotely, all interviews will be conducted virtually.
Date of posting: 10/16/2024
Applications are assessed on a rolling basis. We anticipate that the application window will close on 12/16/2024, but the application window may change depending on the volume of applications received or close immediately if a qualified candidate is selected.
Apply
Job Profile
Must be able to perform duties with or without reasonable accommodation Must be able to provide a dedicated, secure work area Must be able to provide high-speed internet access
Benefits/Perks401(k) 9 paid holidays per year Competitive benefits Competitive benefits package Dental Disability Life Insurance Life insurance coverage Medical Medical, dental, vision, disability, and life insurance coverage Paid Family Leave Paid holidays Paid Time Off PTO Vision
Tasks- Compliance
- Create and maintain Spark scripts
- Data Analysis
- Data integration
- Data Management
- Ensure compliance
- Execute SQL scripts
- Maintain data pipelines
- Optimize queries
- Other duties as assigned
- Performance reviews
- Perform data analysis
- Prioritize projects
- Project management
- Special projects
- Troubleshoot issues
Access AI Analytical AWS Azure Big Data Cloud Communication Compliance Computer Computer Science Data analysis Databricks Data Integration Data Management Data Pipelines Data Quality Data Security Data Validation ETL ETL tools Excel GCP Hadoop Healthcare Healthcare industry Information Technology Insurance Jira Kafka Microsoft Office Microsoft Office Suite MS SQL Oracle Organizational Outlook PL/SQL PowerPoint Project Management RDBMS S3 Science Security Snowflake Spark SQL Technology Vertica Word Written communication
Experience3 years
EducationBachelor's degree Business Computer Science Engineering Equivalent Equivalent work experience Healthcare Information Technology Management Medical MS
TimezonesAmerica/Anchorage America/Chicago America/Denver America/Los_Angeles America/New_York Pacific/Honolulu UTC-10 UTC-5 UTC-6 UTC-7 UTC-8 UTC-9