Data & Analytics Engineer
Avnayurveda, Tamil Nadu
About the Company
AVN Group of Companies is looking for a technically strong and detail-oriented Data & Analytics Engineer to build, maintain and enhance its group-wide data integration, analytics and business intelligence capabilities across AVN Arogya Healthcare and AVN Ayurveda Formulations.
About the Role
The role will enable departments to access reliable, timely and actionable performance data through automated data pipelines, KPI scorecards and interactive dashboards. The selected candidate will take ownership of the existing analytics foundation established for the hospital business and extend it across manufacturing, sales, HR, finance, CRM and other business functions. The successful candidate will work closely with the Director – Operations and departmental managers to translate approved KPI definitions into tested data pipelines and reporting solutions.
Key Responsibilities
- Connect, integrate and maintain data from multiple business systems, including:
- Hospital Management System (HMS) – SQL Server
- Microsoft Dynamics 365 Business Central (BC)
- greytHR
- PRX
- Zoho CRM
- Google Ads and Meta Ads platforms
- Develop and maintain automated data pipelines to extract and load data into the Google Cloud data environment.
- Schedule, monitor and troubleshoot data loads to ensure reliable and timely availability of information.
- Maintain read-only access to source systems and ensure that analytics processes do not modify source data.
- Extend integrations to new applications and business systems as required.
- Convert management-approved KPI definitions into tested, documented and maintainable code.
- Develop departmental KPI dashboards, scorecards and interactive drill-down reports.
- Enable reporting at group, entity, branch, department, team, product, doctor and sales representative levels, as applicable.
- Automate the flow of actual KPI performance data into the Performance Management System (PMS).
- Prepare accurate and timely data packs for monthly management and departmental performance reviews.
- Identify data gaps, inconsistencies and unclear metric definitions and seek clarification before implementation.
- Validate source data, reconcile reported figures and investigate discrepancies before publishing reports.
- Establish appropriate data quality checks, automated tests, error alerts and reconciliation controls.
- Maintain version-controlled code, technical documentation and review processes using Git.
- Monitor pipeline performance, resolve failures and continuously improve reliability and maintainability.
- Ensure appropriate access controls, confidentiality and secure handling of patient, employee and customer information in accordance with applicable data protection requirements, including the Digital Personal Data Protection Act, 2023, and applicable rules.
- Work closely with the Director – Operations, HR, Finance, Sales, Manufacturing, Hospital Operations and other departments.
- Explain data outputs, reporting logic and data limitations to non-technical stakeholders.
- Translate approved business requirements into scalable technical solutions.
- Ensure reporting solutions remain consistent with management-approved metric definitions.
Requirements
- B.E./B.Tech, MCA or M.Sc. in Computer Science, Information Technology, Statistics or a related discipline; equivalent relevant experience will also be considered.
- 3–6 years of relevant experience in Data Engineering, Analytics Engineering, Business Intelligence Development or a closely related role.
- Demonstrated experience maintaining production-grade data pipelines, integrations or reporting code.
Preferred Qualifications
- Experience with Microsoft Dynamics 365 Business Central or Dynamics NAV; exposure to SAP or Tally is also valuable.
- Experience in hospital/healthcare, pharmaceutical manufacturing, FMCG or other multi-department business environments.
- Familiarity with Power BI, Zoho Analytics or Looker Studio.
- Exposure to Google Cloud Platform and cloud-based data storage or processing.
- Experience integrating HRMS, ERP, CRM, advertising or operational systems.
What We Offer
- A long-term, on-site opportunity in Madurai.
- Priority for candidates with hands-on production experience, strong data validation skills and a notice period of 30 days or less.
Location & Work Mode
- On-site work in Madurai, Tamil Nadu.