Automation Specialist

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