Business Analyst

ARStrat LLC; Bengaluru; On-site; INR 900,000 - 1,300,000; Full time

Job summary

ARStrat LLC in Bengaluru is seeking a data reconciliation analyst to ensure accuracy between EHR systems and internal datasets. You will perform detailed data comparisons, investigate discrepancies, and prepare clear operational reports.

The role requires strong SQL and Excel skills, knowledge of healthcare revenue cycle processes, and adherence to HIPAA. You will collaborate across teams to implement corrective actions and improve workflow efficiency.

Qualifications

• Bachelor’s degree required.
• Strong analytical and problem‑solving skills with financial/data interpretation.
• Proficiency in SQL and Excel for data analysis.
• Knowledge of healthcare financial systems and revenue cycle processes.
• Familiarity with Epic system navigation and balance verification.
• Ability to identify discrepancies and resolve data issues.
• Understanding of HIPAA and healthcare regulatory standards.
• Excellent communication and collaboration skills.

Responsibilities

• Perform reconciliation of healthcare data between EHR and internal systems.
• Investigate data exceptions, conduct root cause analysis, and implement fixes.
• Analyze processes to identify gaps and system improvements.
• Generate reports monitoring accounts receivable, payments, and adjustments.
• Provide analytical insights to support operational and strategic decisions.
• Document processes and collaborate with internal teams.
• Manage tasks, prioritize workload, and ensure timely delivery.
• Ensure compliance with healthcare regulations and policies.
• Collaborate with cross‑functional stakeholders to address data issues.

Skills

SQL

Excel

Data analysis

Healthcare knowledge

HIPAA compliance

Attention to detail

Communication

Problem solving

Education

Bachelor’s degree

Tools

Epic system

Job description

Responsibilities

• Perform reconciliation of healthcare data including financial transactions, payments, and operational metrics to ensure accuracy between EHR and internal systems.
• Investigate data exceptions, conduct root cause analysis, and implement corrective actions to resolve discrepancies and improve operational outcomes.
• Analyze business processes and operational workflows to identify gaps, inefficiencies, and system improvement opportunities.
• Generate reports and perform data analysis to monitor accounts receivable, payments, adjustments, and support management reporting needs.
• Identify key business trends and provide analytical insights to support operational and strategic decisions.
• Document processes, collaborate with internal teams, and support initiatives that enhance workflow efficiency and productivity.
• Manage project tasks, prioritize workload, and ensure timely delivery of reconciliation and its operational activities.
• Ensure compliance with healthcare regulations, internal policies, and industry standards.
• Collaborate with cross‑functional stakeholders and internal teams to address reconciliation, workflow, and data‑related issues.

Requirements

• Bachelor’s degree.
• Strong analytical and problem‑solving skills with the ability to interpret financial and operational data and identify discrepancies.
• Proficiency in SQL (writing queries, joins, and data filtering) and Excel including Pivot Tables, XLOOKUP, and advanced formulas for data analysis.
• Knowledge of healthcare financial systems, insurance/patient payments, adjustments, reimbursement methodologies, and revenue cycle processes.
• Familiarity with Epic system navigation, transaction reviews, and balance verification.
• Strong problem‑solving and critical‑thinking skills to identify and resolve discrepancies.
• Understanding of healthcare regulations, compliance standards, and HIPAA.
• Ability to analyze data trends, identify data discrepancies, and support resolution through insights and reporting.
• Strong attention to detail and ability to work with large datasets while maintaining data accuracy and integrity.
• Excellent communication, collaboration, and organizational skills with the ability to manage multiple tasks and deadlines.