Sales Operations Data Analyst

Social network you want to login/join with:

Job Responsibilities

1. Analyze and manipulate data in spreadsheets using advanced functions such as Lookup & Reference, Pivot tables, Math & Logical operations.
2. Work extensively with databases, utilizing SQL queries to extract data, analyze datasets, identify anomalies, conduct root cause analysis, and implement corrective actions.
3. Document process steps, maintain SSOT (Single Source of Truth), create user guidelines, and enable business teams to operate efficiently.
4. Perform repetitive tasks with flexibility to adapt to fast-paced changes.

Technical Skills Required

• Data Analysis and Interpretation: Proficient in SQL and dashboard/table analysis.
• Spreadsheets: Advanced proficiency in MS Excel/Google Spreadsheets.
• Dashboards: Ability to create charts and tables using SQL queries in data visualization tools.
• Collaboration/Communication: Experience with Office 365, chat/messaging tools.
• CRM: Knowledge of Salesforce Lightning as a sales operations user.

Key Responsibilities

• Analyze project-specific requirements for partner onboarding, sales reporting, demand planning, pricing, and promotions.
• Define data dictionaries and maintain SSOT.
• Develop business reports on partner performance, sales anomalies, cost-to-serve, sales & marketing spend, and account-specific P&L.
• Monitor data pipelines and coordinate with engineering teams to resolve issues.
• Execute SQL queries for data extraction and validation.
• Interpret data from tables, charts, and reports; perform descriptive statistics and trend analysis.
• Configure and maintain reports on KPIs using in-house reporting tools.
• Publish periodic performance reports and recommend improvements.
• Collaborate with various teams to ensure efficient processes.
• Respond to operational issues and coordinate resolutions.
• Develop process playbooks and maintain documentation.

#J-18808-Ljbffr