Sales Operations Data Analyst

JR United Kingdom; London; On-site; GBP 35,000 - 55,000; Full time

Job summary

An established industry player is seeking a skilled Data Analyst to join their dynamic team in London. In this role, you will leverage your expertise in SQL and advanced spreadsheet functions to analyze and manipulate data, ensuring that business teams operate efficiently. You'll be responsible for creating insightful reports, monitoring data pipelines, and collaborating with various teams to drive improvements. This position offers an exciting opportunity to contribute to key business decisions and enhance operational efficiency in a fast-paced environment.

Qualifications

• Proficient in SQL and advanced data analysis techniques.
• Experience in creating dashboards and reports using data visualization tools.

Responsibilities

• Analyze and manipulate data using advanced spreadsheet functions.
• Work with SQL queries to extract and validate data from databases.
• Document processes and maintain a Single Source of Truth.

Skills

Data Analysis and Interpretation

SQL

Advanced MS Excel/Google Spreadsheets

Data Visualization Tools

Collaboration/Communication

Salesforce Lightning

Job description

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.