Microsoft Excel Specialist – Remote

About the role

We are hiring for a client to develop and maintain financial models, reports and dashboards using advanced Excel functions. The remote position focuses on optimizing data processing workflows and ensuring accuracy in financial and operational reporting.

Key responsibilities

• Develop and maintain complex financial models, including forecasting, budgeting, and variance analysis.
• Design and update dynamic dashboards to visualize key performance metrics for stakeholders.
• Automate repetitive Excel tasks using macros and VBA to improve efficiency and reduce manual errors.
• Validate and reconcile financial data to ensure accuracy and compliance with reporting standards.
• Collaborate with cross‑functional teams to gather requirements and deliver customized Excel solutions.

Required profile

• Strong analytical skills to interpret financial data and generate actionable insights.
• Ability to create and maintain interactive dashboards using Excel Power Pivot and Power Query.
• Familiarity with data validation, error handling, and troubleshooting in Excel.

Required skills

• Excel
• VLOOKUP
• INDEX‑MATCH
• SUMIFS
• XLOOKUP
• Excel macros
• VBA
• Power Pivot
• Power Query
• Data validation
• Error handling
• Troubleshooting