Reporting and Dashboard Specialist - CO

Job description

About the Role As a Reporting & Dashboard Specialist, you will own client reporting and dashboards across their entire lifecycle, from the moment a deal is won through ongoing maintenance, optimization, and evolution as client needs grow. Based in Bogotá, you will sit on the Product & Technology team and be the dedicated, consistent resource for this work, ensuring the reporting delivered remains accurate, aligned, and valuable over time. This is a hands-on data role. You’ll connect client data through Funnel and BigQuery, build dashboards in Sigma, and, most importantly, figure out why a number doesn’t match and fix it. You don’t need to be a software engineer, but you do need to be comfortable in SQL and curious enough to keep digging until you find the answer. This is an entry-level role with a clear path to grow into data engineering, measurement, or our in-house AI and analytics products. What You’ll Do • Own dashboard setups end-to-end for new client accounts, from sales handoff through a live dashboard. Join sales handoffs and onboarding calls to understand what was pitched and scope realistic timelines. • Work directly with client stakeholders to confirm KPIs and definitions, secure platform access, and walk them through their dashboards once live. • Connect client data sources (Meta, Google, TikTok, Amazon, GA4, Shopify, and others) through Funnel and Fivetran, and configure the dimensions, metrics, and mapping rules that label campaigns correctly. • Build client dashboards in Sigma from WITHIN’s standard templates, customizing where an account requires it and flagging bespoke requests that need scoping. • Investigate discrepancies between platform-reported and warehouse numbers, such as timezone and attribution-window differences, currency conversion, unmapped campaign names, and duplicate rows, and fix them at the source in Funnel mapping or BigQuery rather than patching the dashboard. • Write SQL and Python scripts to automate repetitive setup and QA steps across accounts, like bulk mapping checks or reconciling dashboards against platform exports. Use AI tools, including Claude, to move faster, and check their output as carefully as you’d check your own. • Hand off live dashboards to account teams with clear written documentation, keep a status tracker of every setup in flight, monitor data-quality alerts on your accounts, and help improve our templates and playbooks so each new account goes live faster than the last. What We’re Looking For • You currently live in Bogotá, Colombia. • Professional fluency in written and spoken English; you’ll work directly with US-based brands. • 0 to 2 years of experience in data analysis, BI, marketing analytics, or a related field (internships and university projects count). • You’re comfortable writing SQL to answer your own questions: SELECT, WHERE, GROUP BY, JOINs, and CTEs. You don’t need to be an engineer, but you should be able to query a table to figure out why a number is wrong. • You understand how data is structured: tables, keys, and what happens when you join two tables at different levels of detail. When numbers don’t match, your first instinct is to check how the data was joined or filtered. • Hands-on experience building dashboards in a BI tool (Sigma, Looker, Looker Studio, Tableau, Power BI, or similar). • Strong spreadsheet skills and comfort working with large, messy datasets. • When a number looks wrong, you can’t let it go until you know why, and you can explain what you found to someone non-technical. You’ve gone down a rabbit hole like this before, at work, in school, or in a side project, and you can tell us about it. • Organized enough to run several account setups at once and hit the timelines you commit to. • Able to work across time zones and overlap with US Eastern business hours. Nice to Have • Python for data work (pandas, scripting repetitive tasks). We’ll weight this heavily, and you’ll use it to automate setup and QA across accounts. • BigQuery or another cloud data warehouse. • Funnel, Fivetran, or Supermetrics. • Familiarity with paid media platforms and metrics (spend, ROAS, CPA, CTR) across Meta, Google, TikTok, or Amazon. • Agency or client-services experience. • Experience using AI tools to automate or speed up analytical work. &