Automation Specialist

Advantmed India LLP; Ahmedabad District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Advantmed India LLP seeks an automation developer to design and implement data automation across Excel, SQL databases and email/web sources. The role requires building Python-based solutions, automating reporting, and ensuring data quality through validated pipelines.

You will partner with operations and planning teams to translate requirements into scalable automation, maintainable code, and clear acceptance criteria for production deployment.

Qualifications

• Proficiency in Python and data automation libraries.
• Experience with data extraction, transformation and loading.
• Ability to design scalable automation solutions.

Responsibilities

• Partner with Operations, Planning, Reporting and stakeholders to map workflows and capture control requirements.
• Document current-state processes and design future-state automation opportunities.
• Convert business requirements into technical specs, acceptance criteria and delivery plans.
• Develop automations that import, validate, transform and export data across sources.
• Build and maintain Excel/VBA automations and reporting tools.

Skills

Python

Pandas

Selenium

Beautiful Soup

PyTest

Matplotlib

Excel

VBA

Tools

SQLAlchemy

SQL

Job description

1. Process Discovery and Solution Design

• Partner with Operations, Planning, Reporting and other stakeholders to understand workflows, pain points, business rules, inputs, outputs and control requirements.
• Document the current-state process, identify automation opportunities, and design a practical future-state workflow.
• Assess feasibility, dependencies, exceptions, risks and expected benefits before development begins.
• Convert business requirements into clear technical specifications, acceptance criteria and delivery plans.

2. Automation Development

• Develop automations that import, validate, transform and export data between Excel, MS SQL databases, email attachments, shared folders, web sources and approved applications.
• Build Python-based solutions using relevant libraries such as Pandas, SQLAlchemy, Selenium, Beautiful Soup, PyTest, Matplotlib and suitable GUI frameworks.
• Develop and maintain Excel/VBA automations, advanced formulas and reporting tools for recurring operational requirements.
• Create user-friendly interfaces, configuration controls and process flows where business users require guided execution.
• Use modular, object-oriented and reusable design practices to improve maintainability and scalability.

3. Reporting and Data Automation

• Automate existing and new reporting requirements while keeping outputs standardized and flexible enough for approved business changes.
• Create controlled data pipelines and scheduled workflows that reduce repetitive effort and manual handling.
• Validate source-to-output reconciliation, data completeness, transformation logic and exception handling.
• Coordinate with BI and reporting teams where automation feeds dashboards, scorecards or client deliverables.

4. Testing, Deployment and Production Support

• Prepare test scenarios and perform functional, regression, negative and volume testing before release.
• Coordinate user acceptance testing, capture approvals and implement production releases through the applicable change process.

Monitor production automations, investigate failures, perform root-cause analysis and restore service within agreed priorities