AI Developer

Jewelex India Pvt Ltd; Mumbai; On-site; INR 800,000 - 1,600,000; Full time

Job summary

Jewelex India Pvt Ltd is seeking a detail-oriented automation professional in Mumbai to streamline reporting processes using Python, SQL, and Advanced Excel. The role focuses on developing automated solutions for repetitive tasks, report generation, and data processing to improve operational efficiency.

The successful candidate will automate data extraction, transformation, and file handling, write optimized SQL queries, and design automated Excel reports with Power Query and VBA/macros.

Qualifications

• Proficiency in Python scripting for data manipulation with pandas/openpyxl.
• Strong SQL knowledge: SELECT, JOINs, filters, aggregations.
• Advanced Excel skills: formulas, PivotTables, Power Query, VBA/macros.
• Experience in automating repetitive tasks, report generation.

Responsibilities

• Identify and automate repetitive reporting and operational tasks.
• Develop Python scripts for data extraction, transformation, and file processing.
• Write and optimize SQL queries for data retrieval and reporting.
• Design automated Excel reports using advanced formulas, PivotTables, Power Query, and VBA/macros.
• Collaborate with stakeholders to understand reporting requirements.
• Maintain documentation and provide user support for automation tools.

Skills

Python

SQL

Advanced Excel

Task Automation

Soft Skills

Job description

Role Summary

We are seeking a detail-oriented professional to automate reporting processes and improve operational efficiency using Python, SQL, and Advanced Excel. The role involves developing automated solutions for repetitive tasks, report generation, and data processing.

Key Responsibilities

• Identify and automate repetitive reporting and operational tasks.
• Develop automation scripts using Python for data extraction, transformation, and file processing.
• Write and optimize SQL queries for data retrieval, analysis, and reporting.
• Design and maintain automated Excel reports using advanced formulas, Power Query, and VBA/macros.
• Collaborate with stakeholders to understand reporting requirements and deliver automation solutions.
• Maintain documentation, troubleshoot existing automation tools, and provide user support when required.

Required Skills & Qualifications

• Python: Basic proficiency in scripting, file handling, and data manipulation using libraries such as pandas and openpyxl.
• SQL: Good understanding of SELECT statements, JOINs, filters, aggregations, and data updates.
• Advanced Excel: Strong knowledge of formulas, PivotTables, Power Query, VBA/macros, and report automation.
• Task Automation: Experience in automating repetitive tasks, report generation, and data consolidation.
• Soft Skills: Strong analytical and problem-solving skills, attention to detail, documentation, and effective communication.