Epicareer Might not Working Properly
Learn More
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