Senior Excel Data Analyst (Remote)

Senior Excel Data Analyst (Remote)

Posted 2 days ago by Quik Hire Staffing

Negotiable
Undetermined
Remote
United Kingdom

Summary: An Excel Expert is required to develop, validate, and maintain advanced financial and operational models for a global technology client. The role focuses on creating accurate forecasting, budgeting, and scenario analysis tools to support strategic decisions. Deep proficiency in Excel is essential for delivering reliable insights that drive business planning and risk assessment. Accuracy and auditability of outputs are critical to the success of this position.

Key Responsibilities:

  • Build and maintain complex financial models in Excel using macros, pivot tables, and advanced formulas.
  • Design and implement automated reporting dashboards to track KPIs and financial performance.
  • Validate model assumptions and stress-test outputs against historical and market data.
  • Collaborate with cross-functional teams to interpret data requirements and translate them into structured solutions.
  • Document formulas, logic, and workflows to ensure model transparency and ease of maintenance.

Key Skills:

  • Minimum 3 years of hands-on experience developing financial or operational models in Excel.
  • Expert-level knowledge of Excel functions including VLOOKUP, INDEX-MATCH, SUMIFS, and array formulas.
  • Proficiency in creating interactive dashboards with slicers, conditional formatting, and dynamic charts.
  • Experience with Excel VBA macros to automate repetitive tasks and enhance model functionality.
  • Strong analytical mindset with the ability to interpret business needs and translate them into technical solutions.

Salary (Rate): undetermined

City: undetermined

Country: United Kingdom

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Role: Excel Expert

Location: Remote (Work from Anywhere)

Payout: Competitive, based on experience

Role Overview: An Excel Expert is needed to develop, validate, and maintain advanced financial and operational models for a global technology client. This work supports high-impact strategic decisions by creating accurate forecasting, budgeting, and scenario analysis tools. The role requires deep proficiency in Excel’s modeling capabilities to deliver reliable insights that drive business planning and risk assessment. Accuracy and auditability of outputs are critical.

Key Responsibilities:

  • Build and maintain complex financial models in Excel using macros, pivot tables, and advanced formulas.
  • Design and implement automated reporting dashboards to track KPIs and financial performance.
  • Validate model assumptions and stress-test outputs against historical and market data.
  • Collaborate with cross-functional teams to interpret data requirements and translate them into structured solutions.
  • Document formulas, logic, and workflows to ensure model transparency and ease of maintenance.

Required Skills & Qualifications:

  • Minimum 3 years of hands-on experience developing financial or operational models in Excel.
  • Expert-level knowledge of Excel functions including VLOOKUP, INDEX-MATCH, SUMIFS, and array formulas.
  • Proficiency in creating interactive dashboards with slicers, conditional formatting, and dynamic charts.
  • Experience with Excel VBA macros to automate repetitive tasks and enhance model functionality.
  • Strong analytical mindset with the ability to interpret business needs and translate them into technical solutions.

More About the Opportunity: This role supports a global leader in digital transformation by ensuring data-driven decision-making through precise financial modeling. The contractor will contribute to scalable tools that are used across multiple business units, with opportunities to influence process improvements and automation initiatives. Work is project-based with clear milestones and deliverables.

Equal Opportunity Employer: We hire based on skills and expertise. All qualified candidates are welcome regardless of background, experience, or prior employment history. Applications are reviewed solely on demonstrated technical ability and qualifications.