A
Onsite Maintenance Technician
AVI-SPL
Mumbai
Full-Time
0-3 Years experience
Description
Main Duties and Responsibilities
- Download and consolidate operational data from multiple in-house systems on a weekly cadence.
- Process, validate, and clean data in Excel to a very high standard (e.g., PivotTables, XLOOKUP/INDEX-MATCH, Power Query, complex formulas); build repeatable templates and automated checks.
- Reconcile datasets against operational calendars and other source systems; investigate variances and escalate issues with clear supporting detail.
- Maintain and update project/work-order data, including project actuals, internal hours, and external costs, in partnership with global teams.
- Develop and maintain reporting and dashboards (e.g., SharePoint lists and Power BI) to provide real-time visibility of usage, costs, and billing readiness.
- Produce new reports as required, including ad hoc analysis to support operational and billing queries.
- Identify trends, anomalies, and recurring data-quality issues; propose corrective actions and process improvements.
- Continuously improve data collection, validation, and reporting processes to increase accuracy, efficiency, and auditability.
- Provide weekly and monthly status updates on workload, data quality, and billing readiness; meet agreed deadlines and service levels.
Skills Required
- Bachelor's degree (or equivalent experience) in data, finance, business operations, analytics, or a related field.
- Advanced Excel proficiency (required): PivotTables, Power Query, complex formulas, data validation, and automation (VBA/macros preferred).
- Experience building operational reports and dashboards (Power BI and/or similar tools) and working with structured data sources (e.g.,SQL databases).
- Should know basics of SharePoint e.g. how to create SharePoint Lists, how to create and design SP pages and sp libraries
- Experience supporting project or operational workflows, including tracking actuals, budgets, timelines, and vendor costs.
- Strong written and verbal communication skills, with the ability to translate data issues into clear actions for stakeholders.
- Strong stakeholder management skills and a collaborative approach when working across teams and time zones.
- Excellent time-management and organizational skills; able to manage multiple deadlines and maintain accuracy under pressure.
- High attention to detail and strong problem-solving skills, including root-cause analysis for data discrepancies.
- Service-oriented mindset with the ability to work effectively with managers and customers to resolve billing and reporting queries.
About AVI-SPL
-
