Senior Data Analyst (Sales Ops)

Job Description

Key Responsibilities

• 1. Advanced Excel Reporting & Automation
  • Develop, maintain, and optimize Excel‑based dashboards and reports.
  • Build complex formulas including INDEX/MATCH, XLOOKUP, IF/IFS, SUMIFS, TEXT functions, array formulas, and more.
  • Create and manage PivotTables, PivotCharts, and dynamic dashboards.
  • Automate repetitive tasks using Macros and VBA (optional based on requirement).
  • Create templates for forecasting, planning, sales tracking, and performance reporting.
• 2. Data Analysis & Insights
  • Perform large‑scale data cleaning, transformation, and consolidation.
  • Conduct trend analysis, variance analysis, and what‑if scenario modeling.
  • Support cross‑functional teams with data‑driven insights and recommendations.
• 3. Data Validation & Accuracy
  • Implement data validation rules, checks, and error‑handling processes.
  • Ensure accuracy, consistency, and integrity of all data and reports shared.
  • Perform root‑cause analysis on data discrepancies.

Technical Skills

• Expert-level Excel skills: PivotTables, Power Query, Power Pivot, advanced charting
• Complex formulas and dynamic arrays
• Conditional formatting (advanced use)
• Data modeling and scenario management
• Experience with VLOOKUP/XLOOKUP, LOOKUP arrays, and multi-criteria formulas.
• Ability to handle large datasets efficiently.
• Knowledge of Power BI is a plus.
• VBA/Macro skills (optional based on job level).

Professional Skills

• Strong analytical and problem‑solving abilities.
• Exceptional attention to detail and accuracy.
• Ability to present data in a clear, structured, and visual manner.
• Strong communication and documentation skills.
• Ability to work under pressure and meet deadlines.