Data Analyst

AVMLabs L.L.C; Coimbatore District; On-site; INR 800,000 - 1,100,000; Full time

Job summary

AVMLabs L.L.C is seeking an experienced BI/Data Analyst to design and build Power BI dashboards for clinical, operational, and financial KPIs. You will write optimized SQL queries, maintain SSRS reports, and work with data from LIMS, EMS, billing, and ERP systems to support MIS reporting.

You will conduct data quality root cause analyses, collaborate with the development team, and ensure data privacy compliance. Strong Excel modeling and GitHub version control are required.

Qualifications

• Experience building dashboards and reports for clinical/operational data.
• Strong SQL skills for data extraction, transformation, and reporting.
• Proficiency in SSRS and report development for periodic MIS.
• Familiarity with data privacy standards is a plus.

Responsibilities

• Design and build interactive Power BI dashboards and reports for KPIs.
• Write optimised SQL queries and stored procedures.
• Develop and maintain SSRS reports for daily, weekly, monthly MIS.
• Work with datasets from LIMS, clinic systems, billing, and ERP sources.
• Conduct root cause analysis on data quality issues and coordinate with dev team for resolution.
• Version-control report definitions and queries using GitHub.
• Support finance and operations with Excel-based models and ad hoc data requests.
• Assist in building ETL pipelines and data transformation workflows.
• Prepare executive-level MIS reports.

Skills

Power BI

SQL

SSRS

ETL

Tools

GitHub

Job description

• Design and build interactive Power BI dashboards and reports for clinical, operational, and financial KPIs
  
• Write optimised SQL queries and stored procedures for data extraction, transformation, and reporting
  
• Develop and maintain SSRS reports for structured periodic reporting (daily, weekly, monthly MIS)
  
• Work with structured datasets from LIMS, clinic management systems, billing modules, and ERP sources
  
• Conduct root cause analysis on data quality issues and collaborate with the development team forresolution
  
• Maintain and version-control report definitions and query scripts using GitHub
  
• Support finance and operations teams with Excel-based models, pivot analyses, and ad hoc data requests
  
• Assist in building ETL pipelines and data transformation workflows
  
• Prepare executive-level Business Review (MIS) reports
  
• monthly, quarterly, and annual
  
• Ensure data privacy compliance in line with DPDPA 2023 standards for patient and client data