Hansa Cequity - Data Analyst - SQL

Role Overview :

We are seeking a Reporting Analyst for reporting and automation of segmentation, targeting, and campaign channel analytics.

This role will play a critical part in supporting marketing strategy and campaign operations across email, SMS, push notifications, and other channels.

You will be responsible for driving data-driven insights, dashboards, and process automation using tools like AWS Redshift, SQL, and Tableau.

Key Responsibilities :

• Develop automated dashboards and reports for marketing performance across channels (Email, SMS, Push).
• Design and maintain user segmentation logic for targeting and personalization.
• Collaborate with campaign and CRM teams to evaluate segmentation effectiveness and channel performance.
• Automate recurring reports and streamline data pulls using SQL and Redshift.
• Ensure accurate data delivery and monitoring through ETL pipelines and QA checks.
• Support A / B testing frameworks and campaign performance diagnostics.
• Translate analytical findings into actionable business recommendations.
• Maintain a strong understanding of marketing KPIs such as CTR, conversion, opt-out, and retention rates.

Skills & Tools :

(ref : hirist.tech)