Advanced Excel Data Analyst - TJ / 1840394

About the job

Our client Agay Barho is looking for a Advanced Excel Data Analyst in REMOTE

We are seeking an exceptionally skilled MS Excel Specialist -Part time to manage, maintain, and enhance our trackers and reporting sheets. The ideal candidate will have advanced Excel expertise, a strong eye for detail, and the ability to turn complex data into clear, actionable insights. This role is critical in ensuring that our reporting processes are accurate, efficient, and insightful.

Responsibilities

Key Responsibilities

:

 

• Develop, maintain, and optimize complex Excel trackers, dashboards, and reporting templates.
• Automate repetitive tasks using advanced Excel functionalities (macros, VBA, Power Query, Power Pivot).
• Perform data cleaning, validation, and analysis to ensure accuracy and reliability of reports.
• Create dynamic dashboards and visualizations for management and cross-functional teams.
• Collaborate with teams to gather reporting requirements and provide actionable insights.
• Identify opportunities to improve reporting efficiency and implement best practices.
• Troubleshoot and resolve data inconsistencies or reporting issues promptly.
  
   

Skills & Competencies

 

• Advanced Excel proficiency
• Data analysis and visualization
• Process automation using macros/VBA
• Strong organizational and documentation skills
• Excellent communication and collaboration abilities
• Excellent interpersonal, negotiation, communication, and analytical skills.

Desired Skills and Experience

Advanced Excel Functions, Data Visualization, Pivot Tables, Data Cleaning, Reporting and dashboarding