Application Developer & Data Analyst – PHP / MySQL / JavaScript

JSChamps; Bengaluru; On-site; INR 406,000 - 487,000; Full time

Job summary

Sri Sri College of Ayurvedic Hospital and Research Hospital in Bengaluru is seeking a skilled PHP developer to build and maintain hospital applications. You will design modules for ticketing, inventory, patient services, and MIS dashboards, using CodeIgniter or Laravel with MySQL databases.

Responsibilities include creating user forms, workflows, and secure login systems, while ensuring data integrity and timely reporting.

Qualifications

• Proficient in PHP with practical module design for hospital operations.
• Experience with CodeIgniter or Laravel and MySQL/MariaDB databases.
• Ability to design dashboards and reports using MIS tools and Power BI / Looker Studio.
• Knowledge of API basics and data import/export, plus version control basics.

Responsibilities

• Develop internal modules for hospital operations (ticketing, inventory, patient service).
• Design forms, workflows, role-based logins, and reporting components.
• Maintain databases, write optimized SQL, and ensure data integrity.
• Create dashboards and MIS reports for management review.
• Train staff and provide day-to-day application support.
• Ensure data security, access controls, and documentation.

Skills

PHP

CodeIgniter

Laravel

MySQL/MariaDB

SQL queries

APIs

Excel/Google Sheets

Power BI/Looker Studio

Java

Education

Bachelor's

Tools

CodeIgniter

Laravel

MySQL/MariaDB

Job description

Sri Sri College of Ayurvedic Hospital and Research Hospital KA, IN

Job Description

Application Development

• Design and develop internal modules for hospital operations such as:
• Ticket management
• Purchase and inventory tracking
• Patient service tracking
• Department task tracking
• Manpower and work analysis
• MIS and management dashboards
• Customize and improve existing applications based on department and management requirements.
• Create user-friendly forms, approval workflows, role-based login systems, and reporting modules.
• Test, debug, and resolve application errors in a timely manner.
• Ensure that applications are practical, stable, secure, and suitable for daily hospital operations.
• Maintain proper documentation of application design, changes, user guides, and technical updates.
• Write clean, structured, and maintainable PHP code. Have good knowledge in Java.
• Work with PHP frameworks such as CodeIgniter, Laravel, or similar frameworks.
• Design and maintain MySQL / MariaDB databases.
• Write SQL queries, joins, views, reports, and optimized data extraction queries.
• Create and manage database tables, relationships, indexes, and backups.
• Handle form validations, data submissions, dynamic dropdowns, and user interface improvements.
• Integrate applications with databases and ensure smooth data flow between modules.
• Maintain secure access control, user permissions, and data confidentiality.

3. Database Management

• Design, maintain, and optimize databases for hospital applications.
• Ensure accuracy, consistency, and integrity of data.
• Support data migration, data cleaning, and data validation activities.
• Generate data extracts for operational, administrative, and management requirements.
• Maintain database backup processes and support data recovery whenever required.
• Monitor database performance and troubleshoot database-related issues.
• Ensure sensitive hospital, patient, employee, and financial data is protected through proper access controls.

4. Data Analysis and Reporting

• Collect, clean, analyze, and interpret hospital operational data.
• Prepare daily, weekly, and monthly MIS reports for management review.
• Analyze data related to:
• Billing and revenue
• Expenses and cost tracking
• Inventory and purchase usage
• Service turnaround time
• Identify gaps, delays, inefficiencies, and improvement opportunities through data analysis.
• Present findings in a clear, simple, and actionable format.

5. Dashboard and MIS Development

• Develop automated reports to reduce manual work.
• Build department-wise MIS formats for daily, weekly, and monthly reviews.
• Create visual reports, charts, and summaries for management presentations.
• Maintain accuracy and timeliness of all dashboards and reports.

6. Process Improvement and Automation

• Study current hospital workflows and identify areas for digital improvement.
• Convert manual registers, paper-based processes, and Excel-based trackers into structured applications wherever required.
• Support process standardization through digital forms, checklists, trackers, and automated reports.
• Assist in hospital projects related to:
• Manpower optimization
• Treatment costing
• Department productivity analysis
• Service quality tracking
• Purchase and inventory control
• Patient service improvement
• Work closely with department heads to understand practical operational problems and develop suitable technical solutions.

7. User Support and Training

• Provide day-to-day technical support to hospital staff using internal applications.
• Train users on newly developed applications, reports, and dashboards.
• Prepare simple user manuals, SOPs, and training materials.
• Collect user feedback and recommend improvements.
• Support staff in basic data entry, report generation, and application usage.
• Ensure smooth adoption of digital tools across departments.

8. Data Security and Confidentiality

• Maintain strict confidentiality of patient, employee, financial, and hospital operational data.
• Follow hospital policies related to data protection, access control, and information security.
• Ensure applications have appropriate user roles and permissions.
• Avoid unauthorized sharing, copying, or misuse of hospital data.
• Maintain proper records, logs, and documentation for audit and review purposes.
• Support compliance with applicable data protection and healthcare information security requirements.

Required Technical Skills

• Strong hands-on experience in PHP application development.
• Good knowledge of CodeIgniter, Laravel, or similar PHP frameworks.
• Strong knowledge of MySQL / MariaDB.
• Ability to write SQL queries, joins, subqueries, views, stored procedures, and reports.
• Knowledge of database design, indexing, relationships, backup, and optimization.
• Experience in developing web forms, dashboards, reports, workflows, and login systems.
• Ability to debug application errors and database issues.
• Knowledge of data import/export using Excel, CSV, and database tools.
• Basic understanding of APIs and system integration.
• Good knowledge of Excel, Google Sheets, and MIS reporting.
• Knowledge of Power BI, Looker Studio, or other dashboard tools will be an added advantage.
• Knowledge of Java will be an added advantage.

Required Functional Skills

• Ability to understand hospital workflows and department-level operational requirements.
• Ability to convert user requirements into practical software solutions.
• Good analytical and problem-solving skills.
• Good reporting and presentation skills.
• Ability to coordinate with multiple departments.
• Ability to work independently with minimum supervision.
• Ability to prioritize tasks based on urgency and operational importance.

Job Type: Full-time

Pay: Up to ₹40,000.00 per month

Ability to commute/relocate:

• Bangalore, Bengaluru - 560062, Karnataka: Reliably commute or willing to relocate with an employer-provided relocation package (Required)

Education:

• Bachelor's (Required)

Address

Main Road Kasia
Behind Shiv Mandir
Kushinagar-274402
Uttar Pradesh, India