Executive - Excel Automate

Role & responsibilities

• Excel Automation: Develop and maintain Excel VBA macros, Power Query scripts, and other automation tools to streamline repetitive data processing tasks, reporting, and analysis.
• Data Integration: Automate the import and export of data from multiple sources (e.g., databases, APIs, and external files) into Excel, ensuring accurate and efficient data flow.
• Report Generation: Build automated reporting systems that generate accurate, up-to-date reports with minimal user intervention. Optimize complex formulas and processes to ensure fast execution.
• Process Optimization: Identify inefficiencies in existing workflows and create solutions that minimize manual data entry and reduce human error.
• Collaboration: Work closely with business stakeholders (Finance, Operations, Logistics, etc.) to understand their needs and create tailored Excel automation solutions that meet those requirements.
• Documentation: Provide clear documentation and training materials for any automated systems you develop. Ensure that all stakeholders can easily use and maintain the automated solutions.
• 
  Quality Assurance: Test and debug automated solutions to ensure accuracy and reliability. Monitor automated processes and troubleshoot any issues that arise.
• Data Analysis & Insights: Assist in creating advanced analytical tools in Excel that provide valuable insights for business decision-making, including creating dashboards and visualizations.

Preferred candidate profile

• Education: Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field, or equivalent experience.
• Technical Skills:
• Excel: Expertise in Excel, including advanced functions (VLOOKUP, INDEX/MATCH, PivotTables, etc.), formulas, and data modelling.
• VBA: Strong knowledge of Excel VBA for automating repetitive tasks, writing macros, and creating custom solutions.

Looking to get Placed? Try our Placement Guarantee Plan

Get Hired
• Power Query & Power Pivot: Experience with Power Query for data manipulation and Power Pivot for data modelling and reporting.
• Data Integration: Familiarity with connecting Excel to external databases and APIs (SQL, JSON, etc.) for data extraction and automation.

• Experience:
• Proven experience in Excel automation and process optimization, ideally in a business or finance setting.
• Familiarity with additional automation tools like Python, R, or Microsoft Power Automate and Power Apps is a plus.

Preferred Skills:

• Experience with Microsoft Power BI or other data visualization tools.
• Knowledge of SQL or other database query languages.
• Understanding of business intelligence principles and practices.