Cotiviti’s Quality & Analytics division turns billions of claims and clinical records into actionable insights for the nation’s largest health plans. We’re looking for a hands-on senior engineer who lives and breathes SQL, loves squeezing every last millisecond out of complex queries, and is eager to help us explore the next wave of AI-powered analytics.

1. End-to-End Data Architecture & Engineering

• • Design, build, and maintain highly optimized Oracle and SQL Server objects (tables, partitions, materialized views, indexes) that drive Cotiviti’s HEDIS® quality-measurement products and advanced analytics.
  • Translate annual NCQA HEDIS specifications into auditable PL/SQL and T-SQL code under full version control.

1. Advanced SQL & Performance Tuning

• • Write, refactor, and harden complex queries, stored procedures, and set-based batch processes; analyze execution plans, refine indexing strategies, and tune statistics for peak throughput.
  • Profile nightly and monthly workloads to keep processing within SLA.

1. AI/ML Exploration & Proof-of-Concepts

• • Partner with data scientists to assemble clean, feature-rich datasets that can feed future predictive initiatives (e.g., gap-in-care propensity).
  • Run limited POCs in Python or SQL Machine Learning Services, documenting findings and early guidelines for model quality and data-drift checks.

1. Agile Delivery & Stakeholder Engagement

• • Collaborate daily with technical product owner, Product Owners, and client representatives to refine requirements, demo data products, and secure end-user acceptance.
  • Provide accurate estimates, own user stories through Definition of Done, and contribute to sprint retrospectives with a continuous-improvement mindset.

1. Documentation & Governance

• • Maintain robust data-mart artifacts—source inventories, flow diagrams, data dictionaries, mapping specs—and enforce coding standards that meet HIPAA and internal security guidelines.

1. DevOps & Tooling

• • Adapt to the in-house tools for source code development and maintenance
  • Extend CI/CD pipelines (Bitbucket, Bamboo and Octopus) and build utilities in C#/.NET to automate schema deployments, regression tests, and data-quality gates.

1. Production Support & Continuous Improvement

• • Rotate through on-call support to troubleshoot data discrepancies, resolve performance incidents, and deliver hot-fixes.
  • Mentor junior engineers, perform peer code reviews, and share reusable patterns across teams.

1. Compliance & Security

• • Embed security-by-design principles into pipelines and storage; stay current with HIPAA, SOC 2, and Cotiviti security policies.

1. Corporate Citizenship

• • Fulfill objectives in the annual Performance Plan and any special projects assigned by leadership.
  • Uphold Cotiviti’s code of conduct, ethics, and EEO guidelines.

• Education & Experience
  • Bachelor’s or master’s degree in Computer Science, Information Systems, Engineering, or equivalent work experience.
  • 8+ years of hands-on database engineering with Oracle 11g/12c/19c and Microsoft SQL Server 2016+.
  • 5+ years delivering large-scale data solutions (healthcare experience a plus).
• Technical Expertise
  • Mastery of PL/SQL and T-SQL (window functions, CTEs, dynamic SQL, bulk operations, parallel execution).
  • Proven success in execution-plan analysis, advanced indexing/partitioning, and large-volume ETL (ODI, SSIS, or equivalent).
  • Foundational knowledge of AI/ML concepts—feature engineering basics and model evaluation terminology—to collaborate effectively with data-science teams.
  • Experience with C#/.NET for automation or micro-service wrappers; Python for scripting.
  • Working knowledge of database security (row-level access, encryption, auditing) and backup/recovery best practices.
  • Familiarity with Agile/Scrum (SAFe a plus) and modern DevOps tooling (Git, CI/CD, containerization).
• Soft Skills
  • Exceptional analytical and troubleshooting abilities; able to dissect complex data issues and craft pragmatic solutions.
  • Clear, persuasive communicator who can translate technical findings into business-friendly language for executives and clients.
  • Demonstrated leadership in mentoring, influencing without authority, and driving cross-team initiatives to timely completion.
  • Comfortable collaborating with distributed teams across time zones.

Preferred / “Nice-to-Have”

• Direct HEDIS or NCQA quality-measure experience.
• Web application frontend development using Angular.
• Oracle or Microsoft professional certification (OCP, DP-203, etc.).
• Experience migrating on-prem databases to cloud or hybrid architectures.
• Exposure to healthcare interoperability standards (HL7 FHIR, X12).
• Prior involvement in GenAI or LLM projects (e.g., code generation, documentation, chatbots).
• Hands-on experience packaging DB utilities or ETL jobs in Docker/Openshift.

Mental Requirements:

• Critical Thinking: Ability to think critically and evaluate information objectively, considering different perspectives and potential implications before drawing conclusions or making recommendations.
• Attention to Detail: must have a keen eye for detail to ensure accuracy in data analysis, interpretation, and reporting.
• Quantitative Aptitude: Strong numerical skills are essential for conducting quantitative analysis, working with statistical methods and models, and manipulating data using mathematical operations.
• Data Interpretation: skilled in interpreting data visualizations, charts, graphs, and other forms of data presentation to extract meaningful insights and communicate findings effectively.
• Communication Skills: Effective communication skills are crucial for conveying complex technical concepts and insights to non-technical stakeholders clearly and understandably through written reports, presentations, and verbal discussions.
• Curiosity and Learning Agility: A strong desire to learn and explore new methodologies, techniques, and tools in the field of data analysis and insights generation is essential for staying current with industry trends and best practices.
• Resilience: The ability to handle pressure, adapt to changing priorities, and overcome setbacks is important in a fast-paced and sometimes ambiguous analytical environment.
• Ethical and Integrity: Upholding ethical standards and maintaining integrity in handling sensitive data and information is paramount for building trust and credibility in the insights provided

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 a dedicated, secure work area.
• be able to provide high-speed internet access / connectivity and office setup and maintenance.
• No adverse environmental conditions expected.

Base compensation ranges from $96,000 to $134,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.

This role is based remotely and all interviews will be conducted virtually.

Date of posting: 06/30/2025

Applications are assessed on a rolling basis. We anticipate that the application window will close on 09/29/2025, but the application window may change depending on the volume of applications received or close immediately if a qualified candidate is selected.

#LI-REMOTE

#LI-RA1

#senior