T
VBA & Python Automation Developer
RM 10,000 - RM 11,000 / month
Checking job availability...
Original
Simplified
Title: VBA & Python Automation Developer
Job Description:
- Work with internal teams to Identify improvements in the current existing process
- Partner with the stakeholders to ensure requirements are optimized and implemented efficiently, effectively, and following business objectives
- Standardization/automation of existing reports/dashboards using VBA, SQL, and other technologies
- Carry out proficient programming using VBA and excel functions and build robust Excel based applications
- Ability to ideate and work with cross teams to automate or streamline processes
- Continue to innovate and bring incremental process improvements wherever possible.
Key Skills - Must Have:
- Mandatory: 5+ years of Experience with VBA and advanced MS Excel functions
- Expert programming skills using variable types, loops, arrays, dictionary, collection etc.
- Must have automated processes with 200k+ of rows of data in MS Excel using VBA or other scripts
- Familiar with intermediate to advanced excel formulas like INDEX, MATCH, OFFSET, INDIRECT etc.
- Must have worked with MS Excel pivots, charts and conditional formatting
- Demonstrate strong communication skills to translate technical software solutions to non-technical clients
- Ready to learn (if not already possess) – Python automation to extract data from pdf, .txt files and integrate data flow seamlessly between applications. Use python libraries like pandas, numpy, pdfplumber, pdfminer.six, re etc.
Good To Have:
- R programming for data analytics and visualization
- Knowledge of data visualization and analytics apps like Power BI/ClickView/Tableau
- Knowledge of Excel Power query and Power pivot, advanced MS Excel and VBA
- Knowledge of Microsoft Power Automate
- Experience in financial reporting/automation.
Job Type: Full-time
Pay: RM10,000.00 - RM11,000.00 per month
Experience:
- VBA: 2 years (Required)
- Python: 2 years (Required)
Work Location: In person