Location: New Delhi
Salary: Up to ₹40,000 per month
Department: Business Intelligence & Analytics
Job Type: Full-Time
Key Responsibilities
- Develop workflow automations using Google Apps Script to improve operational efficiency and reduce manual work
- Design and manage advanced Google Sheets and Excel-based systems with automation, validations, dropdowns, approvals, and data controls
- Automate reports, alerts, notifications, and data collection processes across departments
- Build interactive dashboards and KPI trackers using Power BI for Sales, Service, HR, Finance, Production, Inventory, and Management
- Develop Power BI reports using DAX, measures, KPIs, drill-down analytics, and Row-Level Security (RLS)
- Prepare daily, weekly, and monthly MIS reports, management dashboards, and business performance reports
- Perform data cleaning, validation, transformation, and analysis of large datasets
- Support automation and analytics initiatives across inventory management, service operations, HR reporting, procurement, and business operations
- Work closely with department heads to identify automation opportunities and improve reporting accuracy
Required Skills
- Google Apps Script
- Advanced Google Sheets & Microsoft Excel
- VLOOKUP, XLOOKUP, INDEX-MATCH, Pivot Tables, Power Query
- Microsoft Power BI, DAX, KPI Development, RLS
- SQL and Database Querying
- MIS Reporting & Business Analytics
- Dashboard Development & Data Visualization
- Data Cleaning, Validation & Transformation
Preferred Qualifications
- Bachelor's degree in Computer Science, Information Technology, Data Analytics, Statistics, or related field
- Experience in Manufacturing, Medical Devices, Healthcare, or Distribution businesses preferred
- Strong analytical, problem-solving, and process automation mindset
- Ability to independently manage automation and reporting projects