We are seeking a Senior Campaign Data Analyst with strong Python and SQL skills to support our Digital Prospects Marketing / Campaign Operations Retainer. The ideal candidate will be responsible for analyzing large campaign datasets, developing actionable insights, and supporting campaign strategy through audience analysis and performance reporting. Experience working in big data environments and exposure to marketing campaign audience building and complex campaign analysis to support performance & strategy discussions.
Key Responsibilities:
Campaign Data Analysis & Insights
- Perform advanced data analysis using Python and SQL to support digital marketing campaigns, campaign operations, and performance optimization.
- Analyze customer, prospect, audience, and campaign data to identify trends, opportunities, anomalies, and actionable insights.
- Conduct complex campaign performance analyses to support marketing strategy, optimization, and business decision-making.
- Develop a strong understanding of business objectives, audience strategies, campaign requirements, and underlying data mappings to ensure accurate execution and reporting.
Campaign Operations & Audience Management
- Own end-to-end campaign operations, from audience selection and campaign setup through execution, validation, and reporting.
- Build, validate, and optimize marketing audiences for digital campaigns across multiple data sources.
- Manage audience creation and list hygiene, including targeting criteria, suppression logic, exclusions, and data requirements.
- Deliver accurate audience files and ensure flawless campaign execution through rigorous data validation and quality control (QC) processes.
- Build and scale campaign processes from the ground up by establishing reusable execution, QC, documentation, and reporting frameworks.
- Ensure data quality, consistency, and accuracy across multiple marketing and campaign data sources.
- Maintain campaign metadata, data mappings, and reporting assets to support scalable and consistent campaign operations.
Reporting, Automation & Dashboards
- Create, maintain, and enhance campaign performance reports, dashboards, and ad hoc analyses.
- Develop reusable SQL queries and Python scripts to automate campaign reporting, data preparation, validation, and recurring analytical processes.
- Create dashboards and reports to monitor campaign KPIs, customer engagement, conversion, and other marketing performance metrics.
- Continuously improve reporting processes and analytical frameworks to increase efficiency, scalability, and accuracy.
Stakeholder Collaboration
- Partner with marketing and campaign stakeholders to understand campaign objectives, audience requirements, and business priorities and translate them into analytical and operational solutions.
- Collaborate with cross-functional teams to resolve data, audience, and campaign execution issues.
- Present analytical findings, insights, and recommendations to business stakeholders in a clear, concise, and actionable manner.
Required Skills & Qualifications:
- 5+ years of hands-on experience with Python for data analysis (Pandas, NumPy, data manipulation, automation) and advanced SQL skills with experience writing complex queries, joins, CTEs, window functions, and performance optimization with the ability to independently analyze data, troubleshoot issues, develop insights, and support end-to-end campaign execution.
- Knowledge of CRM and marketing automation platforms (Adobe Campaign, Salesforce Marketing Cloud, Marketo, Eloqua, etc.).
- Experience with visualization tools such as Power BI or Tableau.
- Advanced Excel skills for data analysis, reporting, validation, reconciliation, and quality checks.
- Hands-on experience with email marketing, digital marketing campaigns, audience management, campaign operations, or campaign execution.
- Strong understanding of marketing data, audience segmentation, targeting, suppression logic, and campaign data flows.
- Exceptional attention to detail with a strong quality assurance mindset and the ability to identify data discrepancies and campaign execution issues.
- Ability to quickly understand business context, campaign objectives, operational processes, data relationships, and underlying data mappings.
- Strong analytical and problem-solving skills, with the ability to investigate complex data issues and respond effectively to ad hoc analytical requests.
Nice to Have:
- Experience with statistical analysis and predictive modeling.
- Understanding of A/B testing, attribution models, and customer lifecycle analytics.
- Experience working in Agile environments.
Thrive & Grow with Us:
- Competitive Salary: Your skills and contributions are highly valued here, and we make sure your salary reflects that, rewarding you fairly for the knowledge and experience you bring to the table.
- Dynamic Career Growth: Our vibrant environment offers you the opportunity to grow rapidly, providing the right tools, mentorship, and experiences to fast-track your career.
- Idea Tanks: Innovation lives here. Our "Idea Tanks" are your playground to pitch, experiment, and collaborate on ideas that can shape the future.
- Growth Chats: Dive into our casual "Growth Chats" where you can learn from the best—whether it's over lunch or during a laid-back session with peers, it's the perfect space to grow your skills.
- Snack Zone: Stay fuelled and inspired! In our Snack Zone, you'll find a variety of snacks to keep your energy high and ideas flowing.
- Recognition & Rewards: We believe great work deserves to be recognized. Expect regular Hive-Fives, shoutouts and the chance to see your ideas come to life as part of our reward program.
- Fuel Your Growth Journey with Certifications: We’re all about your growth groove! Level up your skills with our support as we cover the cost of your certifications.