Automation Specialist

Advantmed

Ahmedabad

On-site

INR 1,200,000 - 2,400,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Advantmed in Ahmedabad is seeking a Automation Engineer to drive process discovery, design practical automation, and deliver data workflows across Excel, SQL, and web sources. You will build Python-based solutions using Pandas, SQLAlchemy, Selenium, Beautiful Soup, PyTest, and Matplotlib, plus Excel/VBA automations for recurring operational needs.

Join a role focused on data automation, reporting, testing, deployment, and governance, with collaboration across operations and BI teams to optimize

Qualifications

Responsibilities

  • Collaborate with stakeholders to map workflows, capture requirements, and design future-state automation.
  • Develop automations to import, validate, transform and export data across Excel, SQL, email, shared folders, and web sources.
  • Build Python-based solutions using Pandas, SQLAlchemy, Selenium, Beautiful Soup, PyTest and related tools.
  • Develop and maintain Excel/VBA automations and reporting tools for recurring ops.
  • Create user-friendly interfaces and configuration controls for guided execution.
  • Follow modular, reusable design for maintainability and scalability.
  • Prepare test scenarios, coordinate UAT, and support production releases with logging and alerts.

Tools

Python
Pandas
SQLAlchemy
Selenium
Beautiful Soup
PyTest
Matplotlib
Excel
VBA

Job description

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.
  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.
    • Maintain logging, alerts, retry controls, exception reports and recovery instructions for business-critical automations.
  5. Documentation and Governance
    • Maintain requirement documents, process maps, solution designs, technical documentation, user guides, test evidence and release notes.
    • Follow coding, naming, version-control, access-control and documentation standards.
    • Protect confidential healthcare and operational data by applying approved security, privacy and access requirements.
    • Maintain an automation inventory with ownership, dependencies, schedules, business criticality and support information.
  6. Stakeholder Collaboration and Continuous Improvement
    • Provide clear status updates on scope, timelines, risks, dependencies and production issues.
    • Train users and hand over operating instructions to business and support teams.
    • Identify opportunities to standardize, optimize or re-engineer processes before automating inefficient steps.
    • Keep technical skills current and recommend appropriate technologies based on business value, control and maintainability.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Automation Tester
Lead Automation Tester

Exathought • Bengaluru

On-site
INR 900,000 - 1,500,000
Automation Engineer
Automation Engineer

GAVS Technologies • Chennai

On-site
INR 1,800,000 - 2,400,000
AI Automation Engineer
AI Automation Engineer

Solutions Centric Global • Bengaluru

On-site
INR 900,000 - 1,300,000
Digital Specialist-Automation
Digital Specialist-Automation

Ujjivan Small Finance Bank • Bengaluru

On-site
INR 10,000,000 - 20,000,000
Director - Automation
Director - Automation

HCA Healthcare - India • Hyderabad

On-site
INR 2,500,000 - 3,500,000
Automation Manager
Automation Manager

Prescient Automation • Pune District

On-site
INR 900,000 - 1,300,000
Program Manager Finance Operations
Program Manager Finance Operations

Zetwerk • Bengaluru

On-site
INR 1,500,000 - 2,600,000
Senior Specialist, Intelligent Automation
Senior Specialist, Intelligent Automation

Jones Lang LaSalle Incorporated • Gurugram District

On-site
INR 1,200,000 - 2,400,000
Java Automation Architect
Java Automation Architect

Larsen & Toubro Limited • Bengaluru

On-site
INR 4,000,000 - 6,000,000
Automation & Operations Specialist
Automation & Operations Specialist

Oracle • Bengaluru

On-site
INR 1,500,000 - 1,900,000