Analyst

Analyst

Analyst, Marketing Data Operations will provide day-to-day operational support for the marketing data ecosystem, with a primary focus on monitoring, maintaining, and troubleshooting data pipelines that ingest and transform performance data from paid media platforms such as Meta, Google, and TikTok.

Responsibilities:

• Support the identification, investigation, and resolution of data discrepancies across marketing platform data sources including Meta, Google, TikTok, and others
• Monitor data pipelines for anomalies, failures, and latency issues; escalate and help address incidents in a timely manner
• Write and maintain SQL-based queries and transformation logic to support consistent marketing data across reporting layers
• Assist with orchestration workflows using tools such as Apache Airflow, including helping to diagnose DAG failures and flag scheduling issues
• Develop and maintain Python scripts to support data quality checks, recurring ingestion processes, and operational automation
• Use GitHub for version control and collaborate with teammates on code reviews and deployment of data logic updates
• Work within development environments including Visual Studio Code and Cursor to build, test, and iterate on data and automation workflows
• Actively incorporate and help develop AI-assisted workflows leveraging tools like Claude to support day-to-day tasks: writing and debugging code, drafting documentation, and accelerating data investigations
• Support broader AI initiatives and projects across the team as needs evolve
• Maintain clear documentation of pipelines, data definitions, and troubleshooting processes to support team continuity
• Partner with marketing analysts and reporting teams to understand data needs and surface issues that may impact downstream reporting
• Support ad hoc data investigations and analyses as needed

Basic Qualifications:

• 2+ years of experience in a data analyst, marketing analytics, or data operations role
• Intermediate SQL proficiency comfortable writing complex queries, joining and transforming datasets, and debugging transformation logic
• Foundational knowledge of Python for data tasks, automation, or scripting
• Robust attention to detail and a methodical approach to diagnosing data issues
• Experience using GitHub or other version control systems for code management and collaboration
• Comfort working in modern development environments such as Visual Studio Code or Cursor
• Experience integrating AI tools, including large language models like Claude, into daily work for tasks like code generation, debugging, documentation, and analysis
• Exposure to or curiosity about workflow orchestration concepts; awareness with tools like Apache Airflow is a plus but not required

Additional Qualifications:

• Exposure to Google Cloud Platform, particularly BigQuery
• Comprehension with paid media platforms (eg Meta Ads Manager, Google Ads, TikTok for Business) and their data structures
• Experience with Tableau or other BI and visualization tools
• Insight with dbt or similar data transformation frameworks
• Hands-on experience using AI coding assistants (Claude, GitHub Copilot, Cursor) to improve personal development efficiency
• Experience using project management tools such as Jira or Confluence
• Ability to communicate technical findings clearly to non-technical teammates