Automation Specialist

Key Roles and Responsibilities:1. Process Discovery and Solution DesignPartner 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 DevelopmentDevelop 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 AutomationAutomate 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 SupportPrepare 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