Sr Campaign Data and Operations Analyst

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. Qualifications

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.