Назад
Company hidden
11 дней назад

Reporting and Dashboard Specialist (SQL)

Формат работы
onsite
Тип работы
fulltime
Грейд
junior
Английский
c1
Страна
Colombia
Вакансия из списка Hirify.GlobalВакансия из Hirify Global, списка международных tech-компаний
Для мэтча и отклика нужен Plus

Мэтч & Сопровод

Для мэтча с этой вакансией нужен Plus

Описание вакансии

Текст:
/
TL;DR
Reporting and Dashboard Specialist (SQL/BigQuery): Building and maintaining client dashboards by connecting marketing data through Funnel and Fivetran, querying BigQuery, and configuring Sigma reporting with an accent on data accuracy, KPI alignment, and client-facing analytics. Focus on investigating platform-to-warehouse discrepancies, automating setup and QA with SQL and Python, and improving reusable dashboard templates and playbooks.

Location: Full-time in-office role in Bogotá, Colombia; must currently live in Bogotá and overlap with US Eastern business hours. Other locations: LATAM.

Company

hirify.global is a Performance Branding company providing integrated media, creative, SEO, Lifecycle, Retail Media, Affiliate, and Influencer services for major brands.

What you will do

  • Own dashboard setups from sales handoff and client onboarding through launch, maintenance, optimization, and evolution.
  • Confirm KPIs and definitions with client stakeholders, secure platform access, and present live dashboards.
  • Connect Meta, Google, TikTok, Amazon, GA4, Shopify, and other data sources through Funnel and Fivetran, configuring dimensions, metrics, and campaign mapping rules.
  • Build and customize client dashboards in Sigma using standard templates and scope bespoke requests.
  • Investigate and fix discrepancies between platform and warehouse data, including timezone, attribution-window, currency, mapping, and duplicate-row issues, at the Funnel or BigQuery source.
  • Write SQL and Python scripts for setup and QA automation, document live dashboards, track setups, monitor data quality, and improve templates and playbooks.

Requirements

  • Current residence in Bogotá, Colombia and full-time in-office availability.
  • Professional fluency in written and spoken English for direct work with US-based brands.
  • 0–2 years of experience in data analysis, BI, marketing analytics, or a related field; internships and university projects count.
  • Comfort writing SQL with SELECT, WHERE, GROUP BY, JOINs, and CTEs to investigate data issues.
  • Understanding of tables, keys, joins at different levels of detail, filtering, and data structure.
  • Hands-on experience building dashboards in Sigma, Looker, Looker Studio, Tableau, Power BI, or a similar BI tool.
  • Strong spreadsheet skills and comfort working with large, messy datasets.
  • Ability to investigate unexplained numbers, communicate findings to non-technical people, manage multiple account setups, and meet committed timelines.
  • Ability to work across time zones and overlap with US Eastern business hours.

Nice to have

  • Python for data work, including pandas and scripting repetitive tasks; this will be weighted heavily.
  • BigQuery or another cloud data warehouse.
  • Funnel, Fivetran, or Supermetrics.
  • Familiarity with paid media platforms and metrics such as spend, ROAS, CPA, and CTR across Meta, Google, TikTok, or Amazon.
  • Agency or client-services experience.
  • Experience using AI tools to automate or accelerate analytical work.

Culture & Benefits

  • Collaborative, small, closely knit, versatile teams working on integrated marketing systems and iconic brands.
  • AI is used in daily work across teams to improve analysis, operations, creative work, and decision-making.
  • Unlimited vacation policy.
  • Monthly phone, internet, and food stipend.
  • Health insurance coverage.
  • Competitive base salary determined by ability level.

Hiring process

  • Submit a resume in English.
  • Complete a short practical data exercise in SQL, Python, or a spreadsheet.

Будьте осторожны

Если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого. Это мошенники. Обязательно жмите «Пожаловаться» или пишите в поддержку. Подробнее в гайде →