CONSULTANT - EXCEL, MACROS & PQ

Job Summary: The Consultant - Excel, Macros & Power Query (PQ) will be responsible for designing, developing, and implementing advanced Excel solutions, automating processes using VBA Macros, and utilizing Power Query for data manipulation and transformation. This role demands extensive experience in Excel, VBA Macros, and Power Query, along with strong analytical skills.

Key Responsibilities:

  • Design and develop advanced Excel solutions to support business decision-making.

  • Create, maintain, and optimize VBA Macros for process automation.

  • Utilize Power Query to import, clean, and transform data from various sources.

  • Develop and maintain dashboards, reports, and visualizations to communicate insights effectively.

  • Collaborate with stakeholders to understand their data needs and provide tailored solutions.

  • Conduct data analysis to identify trends, patterns, and opportunities for improvement.

  • Mentor junior consultants and provide technical guidance on complex projects.

  • Stay updated with the latest advancements in Excel, VBA Macros, and Power Query.

  • Contribute to the continuous improvement of data analytics processes and methodologies.

Qualifications:

  • Bachelor’s degree in Computer Science, Information Technology, Business Administration, or a related field.

  • Minimum of 5 years of professional experience in data analytics or business intelligence, with a focus on Excel, VBA Macros, and Power Query.

  • Strong proficiency in Excel, including advanced functions and formulas.

  • Expertise in VBA Macros for process automation.

  • Experience with Power Query for data manipulation and transformation.

  • Excellent problem-solving and analytical skills.

  • Strong communication and interpersonal skills.

  • Ability to work independently and as part of a team.

  • Experience with other data analysis tools and programming languages such as Python or R.

  • Knowledge of database management systems (e.g., SQL).

  • Familiarity with data visualization tools like Power BI or Tableau.

  • Strong project management skills.

  • Multilingual abilities are a plus.

Reports to: Associate Director - Transformations

Employment Type: Full Time & Permanent

Industry & Department: Consulting / IT 

Requisition Number / Job ID: TRAN/CO/EM/1109

How to Apply:

  • Interested candidates are invited to send their updated resume at tag@verleap.com & mention the Requisition Number in the email subject.

Direct Reports: No

Location & Working Model: Hyderabad / Hybrid & WFA

Job Status: Actively Hiring 

Shift Timings: 3:00pm IST to 11.00pm IST 

What We Offer:

  • Annual Fixed Bonus.

  • Flexi-basket for Tax Exemptions.

  • Fixed Week-Offs (Saturday & Sunday).

  • Monthly Internet and Fitness Reimbursement.

  • Competitive Market-fit Compensation Package.

  • Flexible Working (Hybrid & Work From Anywhere).

  • Health Insurance for Self and Dependents of INR 5L.

  • 20 Paid Time-Offs (Leaves) a Year + 10 Fixed Holidays a Year.