Develop, maintain, and optimize complex Excel workbooks, dashboards, and models.
Utilize advanced Excel functions (e.g., VLOOKUP/XLOOKUP, INDEX/MATCH, PivotTables, Power Query, Power Pivot, macros).
Clean, structure, and analyze large datasets to provide actionable insights.
Automate repetitive tasks using Excel formulas, VBA, or Power Query workflows.
Create visually effective charts and reports for management presentations.
Ensure accuracy and integrity of data across all spreadsheets and reports.
Collaborate with cross-functional teams to understand reporting requirements and provide data-driven solutions.
Troubleshoot spreadsheet errors, formula issues, and data inconsistencies.
Maintain documentation for reporting processes and spreadsheet structure.
Assist with data migration, integration, and standardization projects.