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
