[Hiring] Digital Media Data Analyst @S Base Technologies

Role Description

We are looking for a Digital Media Data Analyst to join our team and take ownership of validating and analyzing advertising data from key media platforms:

• Meta (Facebook/Instagram)
• TikTok
• Google Ads

This role is critical in supporting paid media strategy by ensuring that advertising data ingested into Snowflake is clean, accurate, and actionable. The analyst will drive insights into consumer behavior, ad spend effectiveness, and audience engagement, ensuring alignment between platform data and internal consumer systems.

Key Responsibilities

• Perform data validation and reconciliation of advertising datasets across:
  • TikTok Ads
  • Facebook Advertisements
  • Google Ads datasets
• Support source-to-target data mapping from ad platforms to Snowflake.
• Analyze campaign KPIs like impressions, CTR, engagement, and conversions.
• Validate relationships between ads, consumer profiles, and spend behavior.
• Investigate anomalies or mismatches in metrics reported by platforms vs. internal data models.
• Act as a bridge between marketing, data engineering, and analytics for end-to-end data quality monitoring.
• Collaborate with stakeholders even where business/technical ownership is unclear, to trace and resolve issues.
• Build dashboards and ad-hoc reports showing performance trends and data accuracy levels.

Qualifications

• Strong working experience with:
  • Meta Business Suite (Facebook/Instagram Ads)
  • TikTok Ads Manager
  • Google Ads Console
• Understanding of advertising campaign structure, audience segmentation, and tracking pixel configuration.
• Strong SQL skills, particularly for querying large datasets in Snowflake.
• Familiar with data models that relate ads to consumers and their spending behavior.
• Proven experience validating ingestion pipelines and data transformations from:
  • Google Ads to Snowflake
  • Facebook Ads to Snowflake
  • TikTok Ads to Snowflake
• Experience building validation reports or dashboards using tools such as:
  • Tableau
  • Looker
  • Power BI
• Ability to interpret advertising KPIs in a business context and derive meaningful insights.
• Familiarity with CDPs like Hightouch, Segment, or mParticle.
• Experience with data pipeline orchestration tools (e.g., Airflow, DBT) for data quality validation.

Requirements

• Location: Remote (Must work CST hours)
• Contract Duration: 6 Months (with potential extension)
• Start Date: Immediate
• Rate: $55 Candidate Rate
• 10-minute screening with Vish (please include availability with submission)
• Technical interview with CHTS, E-commerce QA expert, Raju Thomas
• Final interview with End Client

Feedback from First Round Interview

• Limited proactiveness in explaining and driving the conversation
• Difficulty articulating technical concepts clearly
• Very limited exposure to QAing data lakes or contributing to a broader QA strategy