Marketing Operations Analyst

FocusKPI; Wellesley (MA); On-site; USD 90,000 - 130,000; Full time

Job summary

FocusKPI is looking for a Marketing Operations Analyst to join a high-tech SaaS client. The role focuses on writing complex SQL to access warehouse data and building audience profiles in the CDP to enable precise marketing targeting while ensuring GDPR/CCPA compliance.

Ideal candidates will have 3-5 years in data management/analytics, a Bachelor's in a related field, and experience with Databricks/Snowflake and Tableau.

Qualifications

• Bachelor's degree in Data Science, Computer Science, or related field.
• 3-5 years of experience in data management or analytics, preferably in a marketing environment.
• Proficiency in SQL and Python.
• Experience with Databricks/Snowflake and Tableau.
• Strong analytical and problem-solving skills with the ability to derive actionable insights.
• Excellent attention to detail and data quality standards.
• Curiosity and comfort with ambiguity in data processes.

Responsibilities

• Audience targeting: develop segmentation strategies using SQL to support targeted campaigns.
• Data governance and management: understand data quality and flow, improve usability and accessibility.
• Compliance oversight: ensure marketing data practices comply with privacy regulations (GDPR/CCPA).
• Data integration: collaborate with IT/engineering to bring data into the CDP for analysis.
• Analytics and reporting: design analyses and provide regular reports on marketing performance and audience behavior.
• Cross-functional collaboration: gather requirements and clearly communicate deliverables to stakeholders.

Skills

SQL

Python

Data analysis

Data governance

Attention to detail

Problem solving

Communication

Education

Bachelor's degree in Data Science/CS

Tools

Databricks

Snowflake

Tableau

Job description

FocusKPI is looking for aMarketing Operations Analyst to join one of our clients, a high-tech SaaS company.

As a Marketing Operations Analyst on the Marketing Operations & Technology team, you’ll help share the client's marketing data strategy. This includes driving data governance and consistency across systems, enabling effective audience targeting for strategic marketing initiatives, and ensuring compliance with privacy regulations such as GDPR and CCPA. This is a hands-on technical role, ideal for someone who thrives in ambiguity, works autonomously with large data sets, and brings structure to complex problems. The role involves writing complex SQL to access data in our warehouse, while also building and activating audiences through our customer data platform (CDP). The ideal candidate is innately curious and passionate about identifying novel approaches to derive value from disparate data sets and highly motivated to improve your skillset around the modern data stack.

Responsibilities:

• Audience Targeting: Develop and implement audience segmentation strategies using advanced SQL queries and data manipulation to support targeted campaigns.
• Data Governance and Management: Gain a comprehensive understanding of our data quality and flow processes, while identifying and developing solutions to enhance data usability and accessibility.
• Compliance Oversight: Ensure all marketing data practices adhere to privacy regulations, including GDPR and CCPA.
• Data Integration: Collaborate with cross-functional teams such as IT and engineering to integrate data from various sources into the customer data platform (CDP) for comprehensive analysis.
• Analytics and Reporting: Design and execute data analyses to derive actionable insights, providing stakeholders with regular reports on marketing performance and audience behaviour.
• Collaboration and Communication: Collaborate cross-functionally with marketing stakeholders to gather evolving requirements, design effective solutions, and clearly communicate nuances of the deliverable to ensure alignment and actionable outcomes.

Requirements:

• Bachelor’s degree in Data Science, Computer Science, or a related field
• Minimum of 3-5 years of experience in data management, analytics, or similar, preferably within a marketing environment
• Proficiency in SQL for data manipulation and analysis. Comfortable with Python.
• Experience working within data platforms like Databricks/Snowflake, and analytics modeling platforms such as Tableau
• Strong analytical and problem-solving skills with the ability to interpret complex data sets and generate actionable insights.
• Exceptional attention to detail and a commitment to maintaining high data quality standards.
• Demonstrates innate curiosity, comfort with ambiguity, and a proactive approach to identifying opportunities for improvement and innovation in data processes

No C2C resumes are considered