Data Analyst L1

Define Ventures; Hyderabad; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Define Ventures is looking for a data analyst to transform healthcare claims and related data into actionable insights. You will build dashboards, automate reports, and partner with cross-functional teams to improve audit outcomes and operational performance.

The role emphasizes SQL, Python, and BI tooling with a strong focus on data quality and actionable business recommendations.

Qualifications

• 2+ years of experience in Data Analytics, BI, or healthcare Claims Analytics/Payment Integrity.
• Advanced SQL including complex joins, CTEs, stored procedures, and large datasets.
• Proficient in Python for automation, reporting workflows, data transformation, and analytics.
• Advanced Microsoft Excel and Google Sheets skills with pivots, lookups, formulas, and dashboards.
• Experience with BI/reporting tools such as Power BI and Tableau.
• Ability to ensure reporting accuracy, reconcile numbers, and maintain trust in published metrics.
• Strong analytical mindset with cross-source data pattern recognition.
• Experience creating automated reporting suites, KPI dashboards, and executive scorecards.
• Experience monitoring SLA/TAT, productivity, and financial metrics.
• Excellent communication to translate findings into business recommendations.

Responsibilities

• Analyze large healthcare datasets to identify trends, anomalies, and opportunities.
• Build analytics to optimize provider outreach, response tracking, and performance.
• Monitor and improve audit lifecycles, SLAs, TAT, queue aging, and productivity metrics.
• Perform invoice reconciliation and ensure accurate financial reporting.
• Create and maintain dashboards, scorecards, and KPI reports using BI tools.
• Develop automated daily/weekly/monthly operational and financial reports.
• Generate ad hoc analyses to support evolving priorities.
• Ensure reports and dashboards are reconciled across systems.
• Create profiling reports for auditors, providers, clients, and recoveries.
• Detect drift and inefficiencies; recommend corrective actions.

Skills

SQL

Python

Excel

Google Sheets

BI analytics

Education

Bachelor’s degree in Analytics/Statistics/CS/Finance/Healthcare Administration

Tools

Power BI

Tableau

Looker

Job description

Opportunity Overview

We are seeking a highly analytical, detail-oriented, and results-driven Data Analyst to join our dynamic Payment Integrity team. This role is critical in transforming complex healthcare claims, provider, operational, and financial data into actionable insights that improve business performance, optimize audit outcomes, and drive operational excellence.

The ideal candidate will be highly skilled at uncovering patterns in data, connecting the dots across multiple data sources, identifying process inefficiencies, and recommending corrective actions. You will partner closely with engineering, operations, audit, finance, product, and leadership teams to support strategic decision-making through advanced analytics, dashboarding, forecasting, automation, and performance measurement. This opportunity is ideal for a self-motivated professional who thrives in a fast-paced, high-growth environment and enjoys solving complex business problems through data.

What you’ll do

• Analyze large healthcare datasets including medical claims, audit outcomes, provider data, reimbursements, appeals, invoices, outreach activity, and operational performance metrics to identify trends, anomalies, and business opportunities.
• Build analytics to support provider outreach effectiveness, response tracking, follow‑up performance, and provider abrasion control initiatives.
• Monitor and improve end‑to‑end audit lifecycle SLAs, turnaround time (TAT), queue aging, throughput, and productivity metrics.
• Perform invoice reconciliation by validating recoveries, fees, payments, billing outputs, and financial reporting accuracy.
• Build and maintain dashboards, scorecards, and KPI reporting using Power BI, Tableau, Looker, or similar tools.
• Develop automated daily, weekly, and monthly reports for operational, financial, and executive stakeholders.
• Be flexible and responsive in generating ad hoc reports and business analysis based on evolving operational priorities.
• Ensure all reports, dashboards, and published metrics are accurate, reconciled, and aligned across systems.
• Create profiling reports for auditors, providers, clients, claims inventory, productivity, and recoveries; continuously monitor for changes, trends, and performance drift.
• Detect operational drift, unusual patterns, leakage points, and inefficiencies; recommend corrective actions to improve overall process efficiency.
• Uncover hidden patterns in data and connect insights across multiple sources to support business decisions.
• Perform root cause analysis on missed recoveries, SLA breaches, provider abrasion, operational delays, and reporting variances.
• Use advanced analytics and forecasting to support staffing models, productivity planning, and business growth initiatives.
• Create and optimize complex queries, data models, and automated workflows using SQL and Python.
• Partner closely with operations, audit, finance, product, and leadership teams to support strategic decision-making through analytics and reporting.
• Maintain data governance standards and adhere to HIPAA and company privacy policies.

Required Qualifications

• 2+ years of experience in Data Analytics, Business Intelligence preferably healthcare Claims Analytics, or Payment Integrity Analytics.
• Advanced expertise in SQL including complex joins, CTEs, stored procedures, optimization, and large dataset handling.
• Strong hands‑on expertise in Python for automation, reporting workflows, data transformation, and advanced analytics.
• Advanced proficiency in Microsoft Excel and Google Sheets including pivots, lookups, formulas, data validation, and dashboards.
• Experience with BI/reporting tools such as Power BI, Tableau.
• Proven ability to ensure reporting accuracy, reconcile numbers, and maintain trust in published metrics.
• Strong analytical mindset with ability to uncover patterns in data and connect the dots across multiple sources.
• High attention to detail with a strong focus on data quality and accuracy.
• Experience creating automated reporting suites, KPI dashboards, and executive scorecards.
• Experience monitoring productivity, SLA, TAT, queue health, financial metrics, and operational performance.
• Strong cross‑functional collaboration skills and ability to work with operations, audit, finance, product, and leadership teams.
• Excellent communication skills with ability to translate complex findings into clear business recommendations.
• Strong prioritization, ownership mindset, and problem‑solving capability.
• Bachelor’s degree in Analytics, Statistics, Computer Science, Finance, Healthcare Administration, or related field.

Nice to Haves

• Knowledge of AWS services like Lambda, S3, EC2 and Textract.
• Strong experience in Payment Integrity operations, healthcare claims data, provider analytics, audit workflows, and financial reporting.
• Should have intellectual curiosity to learn new things.
• Familiarity with version control tools such as Git.
• Experience using Jira for tracking requests, sprint planning, and workflow management.

Ability to commute/relocate

• Hyderabad (Nacharam), Telangana: Reliably commute or planning to relocate before starting work (Preferred)

Equal Opportunity Statement

Cohere Health is an Equal Opportunity Employer. We are committed to fostering an environment of mutual respect where equal employment opportunities are available to all. To us, it’s personal.