Microsoft Specialist

Job description: ( Contract/Remote)

Highly skilled Excel specialist with strong expertise in VBA, Macros, and Data Automation. Candidate will be responsible for pulling data from multiple large Excel files, cleaning and transforming the data, and building automated dashboards and reports. This role requires strong analytical thinking, attention to detail, and the ability to streamline complex data workflows.

Key Responsibilities

Develop, enhance, and optimize Excel VBA scripts and macros to automate repetitive tasks.

Pull, merge, and consolidate data from multiple large Excel workbooks and data sources.

Perform data cleaning, transformation, and normalization to prepare datasets for reporting.

Build automated and interactive Excel dashboards, including charts, pivots, slicers, and summary views.

Ensure data accuracy and reliability through validation, error handling, and QA checks.

Improve existing spreadsheets, formulas, and workflows for better performance and scalability.

Work closely with business teams to understand reporting needs and deliver timely insights.

Troubleshoot, debug, and optimize VBA code for better performance in large datasets.