AI Data & Automation Analyst

As an AI Data & Automation Analyst based in Chandigarh, you will be responsible for managing the end-to-end marketing analytics stack for various performance marketing teams. Your role will involve handling raw campaign data, creating dashboards, and automated reports to facilitate daily decision-making processes for the team. Key Responsibilities: - Own the marketing analytics data stack on Supabase (Postgres) by designing schemas, data models, and optimizing query performance for reporting and dashboards. - Develop and maintain clear dashboards using tools like Loveable/React or BI tools to provide visibility into campaign performance across different niches and teams. - Create and manage automated data pipelines and scripts to extract campaign and performance data from platforms like Lookfinity and Meta/Facebook Ads Library into Supabase. - Utilize SQL and Python (or similar tools) to clean, transform, and aggregate large marketing datasets for regular reporting and ad-hoc analysis. - Apply statistical techniques such as hypothesis testing, basic regression, and A/B test analysis to evaluate campaigns and funnels, suggesting optimizations. - Enhance analytics for creative and copy workflows by developing dashboards for script assignments, approvals, and performance tracking. - Implement data quality checks, documentation, and governance to ensure stakeholders trust the numbers in reports and dashboards. - Collaborate closely with marketing, creative, and tech teams to analyze open questions and present findings in a clear, actionable manner. Qualifications & Skills: - 13+ years of experience in data analytics or data automation, preferably in performance marketing or a similar data-driven environment. - Strong analytical skills with the ability to interpret complex datasets and provide clear insights and recommendations. - Proficient in SQL (preferably on PostgreSQL) and skilled in data modeling for reporting and analytics. - Experience with scripting languages like Python (or JavaScript/TypeScript) for building pipelines, automations, and API integrations. - Familiarity with BI/dashboard tools such as Power BI, Tableau, Looker Studio, or React/Loveable dashboards. - Interest or experience in AI/ML concepts and tools used in analytics, reporting, or marketing optimization is a strong advantage. - Excellent communication skills and ability to work with both technical and non-technical stakeholders in a fast-paced, experiment-driven environment. As an AI Data & Automation Analyst based in Chandigarh, you will be responsible for managing the end-to-end marketing analytics stack for various performance marketing teams. Your role will involve handling raw campaign data, creating dashboards, and automated reports to facilitate daily decision-making processes for the team. Key Responsibilities: - Own the marketing analytics data stack on Supabase (Postgres) by designing schemas, data models, and optimizing query performance for reporting and dashboards. - Develop and maintain clear dashboards using tools like Loveable/React or BI tools to provide visibility into campaign performance across different niches and teams. - Create and manage automated data pipelines and scripts to extract campaign and performance data from platforms like Lookfinity and Meta/Facebook Ads Library into Supabase. - Utilize SQL and Python (or similar tools) to clean, transform, and aggregate large marketing datasets for regular reporting and ad-hoc analysis. - Apply statistical techniques such as hypothesis testing, basic regression, and A/B test analysis to evaluate campaigns and funnels, suggesting optimizations. - Enhance analytics for creative and copy workflows by developing dashboards for script assignments, approvals, and performance tracking. - Implement data quality checks, documentation, and governance to ensure stakeholders trust the numbers in reports and dashboards. - Collaborate closely with marketing, creative, and tech teams to analyze open questions and present findings in a clear, actionable manner. Qualifications & Skills: - 13+ years of experience in data analytics or data automation, preferably in performance marketing or a similar data-driven environment. - Strong analytical skills with the ability to interpret complex datasets and provide clear insights and recommendations. - Proficient in SQL (preferably on PostgreSQL) and skilled in data modeling for reporting and analytics. - Experience with scripting languages like Python (or JavaScript/TypeScript) for building pipelines, automations, and API integrations. - Familiarity with BI/dashboard tools such as Power BI, Tableau, Looker Studio, or React/Loveable dashboards. - Interest or experience in AI/ML concepts and tools used in analytics, reporting, or marketing optimization is a strong advantage. - Excellent communication skills and ability to work with both technical and non-technical stakeholders in a fast-paced, experiment-driven environme