Sr Campaign Analyst

Quation; Bengaluru; On-site; INR 600,000 - 900,000; Full time

Job summary

Quation Solutions Pvt Ltd is seeking a Data Analyst Campaign Analyst specializing in the Retail Sector to analyze retail marketing campaigns, generate actionable insights, and enable data-driven decisions that enhance customer engagement and drive sales.

The role requires 1–3 years of relevant experience and proficiency in SQL, AWS Redshift, Python, and Excel, with exposure to Salesforce CDP or similar platforms. Collaboration with marketing and sales teams is essential.

Qualifications

• Bachelor's degree in data analytics, marketing, statistics, economics, or a related field.
• 1–3 years of experience in data analysis, campaign analytics, or retail marketing analytics.
• Proficiency in SQL for data extraction and manipulation, with advanced SQL skills preferred.
• Experience working with AWS Redshift for managing large datasets and analytical tasks.
• Strong skills in Excel for data organization, reporting, and analysis.
• Exposure to Salesforce CDP (Customer Data Platform) or other campaign management platforms.

Responsibilities

• Campaign Performance Analysis: Conduct deep analysis of marketing campaigns to evaluate effectiveness, ROI, customer engagement, and overall impact.
• Data Collection and Preparation: Build and maintain clean, organized datasets using SQL, AWS Redshift, and Python to support analytical needs.
• Customer Insights: Develop insights on customer segmentation, purchasing patterns, and behaviour to inform targeted marketing strategies.
• Dashboard Creation: Design and build dynamic dashboards and reports using advanced Excel and visualization tools for campaign performance tracking.
• Optimization and A/B Testing: Perform A/B tests and multivariate analyses to optimize campaign strategies and measure success.
• Collaboration: Work closely with the marketing and sales teams to align campaign insights with business goals and support data-driven decision-making.
• Data Documentation: Document processes and data flows for transparency and repeatability of campaign analyses.

Skills

Strong analytical skills

Excellent communication

Attention to detail

Collaborative mindset

Problem solving

Education

Bachelor's degree in data analytics / marketing / statistics / economics

Tools

SQL

AWS Redshift

Python

Excel

Salesforce CDP

Job description

Job Description

We are seeking a skilled and motivated Data Analyst Campaign Analyst specializing in the Retail Sector. In this role, you will focus on analysing retail marketing campaigns, generating actionable insights, and enabling our clients to make data-driven marketing decisions that enhance customer engagement, drive sales, and optimize performance.

Years of Experience: 1 3 Years relevant work experience

Responsibilities

• Campaign Performance Analysis: Conduct deep analysis of marketing campaigns to evaluate effectiveness, ROI, customer engagement, and overall impact.
• Data Collection and Preparation: Build and maintain clean, organized datasets using SQL, AWS Redshift, and Python to support analytical needs.
• Customer Insights: Develop insights on customer segmentation, purchasing patterns, and behaviour to inform targeted marketing strategies.
• Dashboard Creation: Design and build dynamic dashboards and reports using advanced Excel and visualization tools for campaign performance tracking.
• Optimization and A/B Testing: Perform A/B tests and multivariate analyses to optimize campaign strategies and measure success.
• Collaboration: Work closely with the marketing and sales teams to align campaign insights with business goals and support data-driven decision-making.
• Data Documentation: Document processes and data flows for transparency and repeatability of campaign analyses.

Qualifications

Basic Qualifications

• Bachelor s degree in data Analytics, Marketing, Statistics, Economics, or a related field.
• 1-3 years of experience in data analysis, campaign analytics, or retail marketing analytics.
• Proficiency in SQL for data extraction and manipulation, with advanced SQL skills preferred.
• Experience working with AWS Redshift for managing large datasets and analytical tasks.
• Strong skills in Excel for data organization, reporting, and analysis.
• Exposure to Salesforce CDP (Customer Data Platform) or other campaign management platforms.

Preferred Qualifications

• Familiarity with Python for data manipulation and analytics, including libraries like Pandas and NumPy.
• Experience in campaign analytics and optimization within the retail industry.
• Knowledge of machine learning basics to leverage customer insights for predictive modelling.
• Proficiency in A/B testing and statistical analysis methodologies.

Suggested Skills

• Advanced SQL: Essential for data querying and data preparation.
• AWS Redshift: Experience with Redshift for data storage, ETL, and analysis.
• Python: Familiarity with Python and data science libraries for analytics.
• Salesforce CDP: Exposure to Salesforce Customer Data Platform for campaign tracking and segmentation.
• MS Excel: Advanced skills in Excel, including pivot tables, complex formulas, and data visualization.

Preferred Skills

• Retail Industry Knowledge: Understanding of retail metrics, customer behaviour, and campaign metrics.
• Campaign Analytics: Proven experience in campaign data analysis and optimization, including A/B testing.

Ideal Soft Skills

• Strong analytical and critical thinking skills.
• Excellent communication, able to present complex insights to non-technical stakeholders.
• Attention to detail with an ability to prioritize and manage multiple tasks.
• Collaborative mindset with an ability to work cross-functionally.
• Solution-oriented with a proactive approach to identifying and solving problems.

General Recruitment Disclaimer

Quation Solutions Pvt Ltd is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. Immediate to 30-day notice period candidates are preferred.