Database & Excel Automation Executive | Data Spectors (Mumbai)

Database & Excel Automation Executive | Data Spectors (Mumbai)

17 Nov
|
data spectors
|
Mumbai

17 Nov

data spectors

Mumbai

Job Summary

We are looking for a Database & Excel Automation Executive with 3+ years of hands-on experience in managing data systems, automating workflows, and creating smart reporting solutions using Excel, Google Sheets, SQL, and scripting tools. This role is ideal for someone who thrives at the intersection of data and automation - building seamless data pipelines, cleaning and transforming data, creating dashboards, and implementing Excel or Google Sheets-based automation to optimize business processes. The ideal candidate will have a solid foundation in database management, formulas, macros, VBA scripting, and data visualization, along with the curiosity and technical skills to automate repetitive workflows and ensure data consistency across systems.

Location: Navi Mumbai

Department: IT & Technical Operations

Reports to: Automation Specialist / Technical Project Manager

Key Responsibilities

- Data Management & System Maintenance: Maintain, update, and validate structured and unstructured datasets from multiple sources.
- Data Management & System Maintenance: Design and manage databases in MySQL, Google BigQuery, Airtable, or similar environments.
- Data Management & System Maintenance: Ensure high data accuracy, completeness, and consistency across systems and reports.
- Data Management & System Maintenance: Import, export, and synchronize data between internal systems, CRMs, and automation tools.
- Data Management & System Maintenance: Implement data cleaning and validation scripts to ensure real-time data integrity.
- Excel & Google Sheets Automation: Develop and maintain advanced Excel and Google Sheets dashboards for tracking performance metrics, operations, and reporting.
- Excel & Google Sheets Automation: Build automated Excel workflows using formulas, VBA scripts, and macros to eliminate repetitive manual tasks.
- Excel & Google Sheets Automation: Use Google Apps Script to connect Sheets with external APIs, CRMs, or databases for real-time updates.
- Excel & Google Sheets Automation:



Design dynamic reporting templates that auto-refresh and generate insights for management teams.
- Excel & Google Sheets Automation: Create pivot tables, lookup formulas, and conditional logic models for analytical decision-making.
- Reporting, Dashboards & Data Visualization: Develop performance dashboards that consolidate data from multiple departments (sales, operations, inventory, marketing).
- Reporting, Dashboards & Data Visualization: Build executive-level summary reports using Google Data Studio, Power BI, or Tableau (optional but preferred).
- Reporting, Dashboards & Data Visualization: Automate weekly and monthly report generation using pre-defined templates.
- Reporting, Dashboards & Data Visualization: Visualize key KPIs such as sales trends, efficiency metrics, and data accuracy scores.
- Reporting, Dashboards & Data Visualization: Present findings and optimization insights to management teams for data-driven decisions.
- Workflow Automation & Process Optimization: Identify manual data handling processes and implement automation using Zapier, Make (Integromat), or Python scripts.
- Workflow Automation & Process Optimization: Collaborate with developers and automation specialists to connect databases with other business systems.
- Workflow Automation & Process Optimization: Streamline reporting structures by centralizing data sources and removing redundancy.
- Workflow Automation & Process Optimization: Ensure data pipelines are scalable, secure, and error-free.
- Workflow Automation & Process Optimization: Support internal teams with data integration between CRMs, marketplaces, and spreadsheets.
- Documentation,



Collaboration & Support: Maintain documentation for all Excel models, scripts, macros, and data automation workflows.
- Documentation, Collaboration & Support: Provide ongoing support to internal teams for report usage, troubleshooting, and enhancements.
- Documentation, Collaboration & Support: Collaborate with project managers to ensure timely and accurate delivery of reports and dashboards.
- Documentation, Collaboration & Support: Train team members on best practices for data handling, sheet automation, and basic formulas.
- Documentation, Collaboration & Support: Suggest improvements to data collection and processing strategies based on operational needs.

Qualifications & Eligibility

- Bachelor's degree in Information Technology, Computer Applications, Statistics, or a related field.
- Minimum 3 years of experience in Excel automation, database management, or data analytics roles.
- Certifications in Excel (Advanced), Google Sheets Automation, or Database Management are advantageous.

Skills & Competence

- Excel formulas
- VBA
- Macros
- Google Apps Script
- Google Sheets
- SQL databases (MySQL, PostgreSQL, or similar)
- APIs integration scripting
- Zapier
- Google Data Studio

Responsibilities

- Be at the forefront of data-driven operations and automation innovation.
- Collaborate with cross-functional teams across technology, operations, and business units.
- Work on real-time projects impacting organizational efficiency and scalability.
- Develop hands-on expertise in automation and integration tools.
- Growth opportunities into data engineering, analytics, or automation specialist roles.
- Culture that values initiative, technical excellence, and continuous learning.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Database & Excel Automation Executive | Data Spectors (Mumbai)
🏢 data spectors
📍 Mumbai

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: database & excel automation executive | data spectors (mumbai) / mumbai

Subscribe to this job alert:

Get the latest job offers by email for: database & excel automation executive | data spectors (mumbai) / mumbai