Data Specialist

• Build and maintain warehouse models using BigQuery, Dataform, and dbt
• Write and review models, commit changes, and run releases
• Maintain marketing and sales data pipelines, including platform connectors
• Ensure new ad accounts and products land correctly in the warehouse
• Own product and brand mapping and fix mismatches at the source
• Investigate discrepancies from ad platforms through raw tables, transformed models, and reports
• Build and maintain Looker Studio reporting, including data sources, calculated fields, and access
• Build data quality checks and alerts
• Reconcile numbers against external systems and partners
• Document metric definitions such as active subscription, active customer, and churn
• Answer Media Buying, Finance, and Operations questions using supporting queries
• Perform other assigned tasks