Role Summary
As a Technical Business Analyst, you will be responsible for the end-to-end lifecycle of business process automation using Python, SQL, and RPA tools (UiPath/Power Automate). With a strong foundation in Software Engineering principles such as OOP, you will design, develop, and deploy robust, scalable, professional-grade solutions.
Key Responsibilities
-
Technical Development (Python & SQL)
- Advance Python Engineering: Build modular, reusable code applying OOP concepts such as inheritance, polymorphism, and classes.
- Data Orchestration: Create ETL pipelines to extract data from sources (Databases, APIs, Excel) and load processed data back to production databases using Pandas and NumPy.
- Quality & Testing: Implement a test-first culture by writing comprehensive unit tests using Pytest or Unittest, including parameterized testing for edge cases.
- API Integration: Develop and maintain interfaces that interact with internal and external web services via HTTP requests.
- Workflow Automation: Lead the development of complex automation workflows using UiPath (advanced proficiency) and Power Automate.
- Exception Handling: Ensure system resilience by implementing sophisticated debugging and error-handling constructs (try-except-else-finally).
-
Business Analysis & Stakeholder Management
- Requirement Engineering: Translate vague business needs into structured technical requirements and documentation.
- Stakeholder Bridge: Serve as the primary point of contact between technical teams and business units to ensure project alignment.
- Data Visualization: Use Matplotlib or similar libraries to present data insights that drive executive decision-making.
Required Technical Profile
- Python Expertise (8/10): Deep knowledge of the standard library, data manipulation with Pandas, and professional debugging.
- RPA Mastery (8/10): Extensive experience in UiPath for UI-based automation and Power Automate for API/Cloud-based flows.
- Database Skills: Strong proficiency in SQL for complex data extraction and manipulation.
- Version Control: Professional experience using Git for code tracking, branching, and team collaboration.
- Design Patterns: Ability to apply basic architectural patterns to ensure code is clean and maintainable.
Core Competencies
- Communication: Ability to articulate technical constraints to non-technical audiences clearly.
- Analytical Thinking: A natural curiosity for how business processes work and how they can be optimized through technology.
- Autonomy: Comfortable taking ownership of a project from the initial 'Problem Statement' to the final 'Deployment'.
Additional Information
Experience Level: 3-5 years