Hello There Collective
Posted 38 days agoVerified live 14h ago
Paid Data Analyst
Brief overview
Remote
2+ yrsMinimum
Spreadsheet Formulas and Pivot TablesPaid Media Data AnalysisPaid Media Metrics ROASPaid Media Metrics CPAPaid Media Metrics CTRPaid Media Metrics CPMPaid Media Metrics MERSupermetricsDataboxMeta Ads ManagerTikTok Ads ManagerClient-Facing Dashboard DevelopmentData Cleaning and Quality AssuranceProactiveness
About the company
Hello There Collectivehellotherecollective.com
Hello There Collective offers creative content, social media, advertising, and brand promotion services.
Job description
Summary
Hello There Collective is a social-first creative agency focused on culturally relevant, performance-driven brands across organic, influencer, and paid channels. The Paid Data Analyst will own the pulling, cleaning, quality assurance, and preparation of paid media data, maintain dashboards, and surface insights, opportunities, anomalies, and pacing issues to support reporting and strategy.
Responsibilities
- Pull paid media performance data across all reporting clients on a consistent weekly rhythm, ahead of end week reporting
- Clean and QA the data so it's accurate and structured before it reaches the paid team
- Prepare the numbers and cuts the team needs to build or sign off on client reports
- Run the monthly data pulls that feed our crossindustry benchmark and projection models
- Work in Supermetrics for data pulling and automation, and Databox for dashboards
- Help build and maintain client dashboards against each client's specific KPIs
- Keep data sources connected, organized, and refreshed
- Turn clean data into clear observations: what's working, what's shifting, where the efficiency is
- Surface upsell and scaling opportunities in the data so the team can act on them
- Flag anomalies, tracking issues, and pacing problems before they become client problems
Skills
- 2+ years in a data, analytics, reporting, or paid media operations role (agency experience a plus)
- Strong spreadsheet skills. Comfortable with formulas, pivots, and cleaning messy data quickly
- Able to calculate core paid media metrics from raw inputs (ROAS, CPA, CTR, CPM, MER) without being handed the formula
- Detailobsessed. You catch the error in the export before anyone else does
- Fast. You understand agency pace and can turn work around in the time the business actually needs, not in nine hours
- Proactive and organized. You prepare ahead instead of reacting at the deadline
- Able to do the analysis yourself. You can use AI to move faster, but you understand the work well enough to do it without leaning on it entirely
- Experience with Supermetrics, Databox, or similar reporting and dashboard tools
- Familiarity with Meta Ads Manager and TikTok Ads Manager reporting
- Experience building or maintaining client facing dashboards
- Exposure to influencer or creator performance data
Qualifications
Must Haves
- 2+ years in a data, analytics, reporting, or paid media operations role (agency experience a plus)
- Strong spreadsheet skills. Comfortable with formulas, pivots, and cleaning messy data quickly
- Able to calculate core paid media metrics from raw inputs (ROAS, CPA, CTR, CPM, MER) without being handed the formula
- Detailobsessed. You catch the error in the export before anyone else does
- Fast. You understand agency pace and can turn work around in the time the business actually needs, not in nine hours
- Proactive and organized. You prepare ahead instead of reacting at the deadline
- Able to do the analysis yourself. You can use AI to move faster, but you understand the work well enough to do it without leaning on it entirely
Nice to Haves
- Experience with Supermetrics, Databox, or similar reporting and dashboard tools
- Familiarity with Meta Ads Manager and TikTok Ads Manager reporting
- Experience building or maintaining client facing dashboards
- Exposure to influencer or creator performance data
