Business Intelligence (BI) Data Visualization & Analytics Specialist
The RoleSupport our passionate and entrepreneurial team as a Business Intelligence (BI) Data Visualization & Analytics Specialist.
In this role, you will refine and evolve and our reporting and dashboarding layer—supporting Ad Operations, Account Management, Media Strategy, and leadership teams. You’ll transform complex campaign and operational data into clear, actionable insights through scalable dashboards and automated reporting workflows.
This role starts with standard reporting and dashboard ownership but has significant room to grow if you enjoy problem-solving, automation, and improving how teams use data to make decisions.
The ProfileYou are equally comfortable working with raw data as you are presenting insights to non-technical stakeholders. You enjoy bringing structure to complex datasets, spotting inconsistencies, and turning numbers into stories that drive action.
You’re proactive, detail-oriented, and curious to stakeholder issues and needs. You take pride in building reliable, well-documented dashboards and enjoy collaborating with operations, engineering, and account teams to understand what data actually matters.
What You’ll Be Doing Own the development and maintenance of internal and client-facing dashboards
• Build, optimize, and document dashboards using Looker Studio
• Knowledge of SQL queries (Redshift or equivalent) to extract, clean, and transform data is an asset
• Normalize metrics across campaigns and platforms to ensure consistency and accuracy
• Automate recurring reporting workflows and data refreshes
• Create internal monitoring dashboards to track campaign health, delivery, and performance
• Partner with Ad Operations and Account Management to surface actionable insights
• Support ad-hoc analysis, deep dives, and investigative reporting using Excel and BI tools
• Contribute to improving reporting standards, data definitions, and analytics workflows
• Identify opportunities for automation, efficiency, and scalability in reporting processes
Does This Sound Like You? SQL skills with experience querying data warehouses (Redshift or similar; nice to have)
• Proven experience building dashboards and visualizations (Looker preferred)
• Comfortable cleaning, normalizing, and validating data across multiple sources
• Strong Excel skills for ad-hoc analysis and reconciliation
• Ability to translate complex data into clear insights for non-technical audiences
• Excellent attention to detail and strong analytical thinking
• Comfortable working in a fast-paced, deadline-driven environment
• Self-directed and able to work independently in a remote setting
Nice to Have:
• Automation experience (Python, dbt, APIs, ETL pipelines)
• Experience with additional BI tools (Power BI, Tableau, etc.)
• Familiarity with digital advertising metrics, programmatic, or Ad Operations workflows
Apply tot his job
Apply To this Job
In this role, you will refine and evolve and our reporting and dashboarding layer—supporting Ad Operations, Account Management, Media Strategy, and leadership teams. You’ll transform complex campaign and operational data into clear, actionable insights through scalable dashboards and automated reporting workflows.
This role starts with standard reporting and dashboard ownership but has significant room to grow if you enjoy problem-solving, automation, and improving how teams use data to make decisions.
The ProfileYou are equally comfortable working with raw data as you are presenting insights to non-technical stakeholders. You enjoy bringing structure to complex datasets, spotting inconsistencies, and turning numbers into stories that drive action.
You’re proactive, detail-oriented, and curious to stakeholder issues and needs. You take pride in building reliable, well-documented dashboards and enjoy collaborating with operations, engineering, and account teams to understand what data actually matters.
What You’ll Be Doing Own the development and maintenance of internal and client-facing dashboards
• Build, optimize, and document dashboards using Looker Studio
• Knowledge of SQL queries (Redshift or equivalent) to extract, clean, and transform data is an asset
• Normalize metrics across campaigns and platforms to ensure consistency and accuracy
• Automate recurring reporting workflows and data refreshes
• Create internal monitoring dashboards to track campaign health, delivery, and performance
• Partner with Ad Operations and Account Management to surface actionable insights
• Support ad-hoc analysis, deep dives, and investigative reporting using Excel and BI tools
• Contribute to improving reporting standards, data definitions, and analytics workflows
• Identify opportunities for automation, efficiency, and scalability in reporting processes
Does This Sound Like You? SQL skills with experience querying data warehouses (Redshift or similar; nice to have)
• Proven experience building dashboards and visualizations (Looker preferred)
• Comfortable cleaning, normalizing, and validating data across multiple sources
• Strong Excel skills for ad-hoc analysis and reconciliation
• Ability to translate complex data into clear insights for non-technical audiences
• Excellent attention to detail and strong analytical thinking
• Comfortable working in a fast-paced, deadline-driven environment
• Self-directed and able to work independently in a remote setting
Nice to Have:
• Automation experience (Python, dbt, APIs, ETL pipelines)
• Experience with additional BI tools (Power BI, Tableau, etc.)
• Familiarity with digital advertising metrics, programmatic, or Ad Operations workflows
Apply tot his job
Apply To this Job