Key Roles and Responsibilities:

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.

1. 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.

1. Reporting and Data Automation

- Automate existing and new reporting requirements while keeping outputs standardized and adaptable 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.

1. 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

Preferred Technical Qualifications:

- Experience with Selenium, PyTest, PyCharm, Beautiful Soup, SQLAlchemy, Matplotlib, Django, Qt or comparable Python tools and frameworks.

- Experience developing simple graphical user interfaces for user management, configuration or guided process execution.

- Knowledge of APIs, JSON, SFTP, email automation, file-based integrations and scheduled job execution.

- Exposure to Microsoft Power Automate, Power BI, SSIS, Git or another version-control platform.

- Experience with web data extraction using approved methods and with appropriate validation and exception controls.

📌 Automations Specialist (Ahmedabad)
🏢 Advantmed
📍 Ahmedabad