About the role

  • Senior Business Intelligence Analyst ensuring data accuracy and consistency for marketing funnels at Sioux digital. Leading dashboard creation and team mentorship in a hybrid work model.

Responsibilities

  • Ensure accuracy, consistency and clarity of marketing and business funnel data.
  • Lead the creation/evolution of metrics and dashboards (Power BI and Looker Studio).
  • Structure and validate data in BigQuery (and relational databases).
  • Drive analyses that lead to action and mentor the team (mid and junior levels).

Requirements

  • Senior BI experience (agency or product/marketing data-driven), with a track record of ownership of the numbers and reducing reporting errors.
  • Strong analytical profile and structured logical reasoning: decompose problems, define inclusion/exclusion criteria, build rules (CASE WHEN), validate edge cases, compare database vs platform and justify each metric.
  • Marketing/business metrics: CPC, CPA, ROAS, LTV, funnel/cohort, pacing/projections; critical review and reconciliation across sources.
  • Advanced Power BI (tabular modeling, DAX, Power Query/M, RLS, performance optimization) and advanced Looker Studio (parameters, blends, optimizations).
  • Strong BigQuery and SQL for BI: CTEs, joins, aggregations, basic window functions; creating views/tables; understanding of partitioning/clustering and efficient consumption.
  • GA4 and GTM: plan measurement (events, parameters, UTMs), specify dataLayer for developers, validate (Tag Assistant/DebugView) and ensure alignment between tracking and dashboard metrics.
  • Quality and governance: metrics glossary, single source of truth, automated checks (integrity/reconciliation), pre-publication audit, access control (RLS/IAM) and basic versioning.
  • Practical automation: schedule light extractions/transformations (scheduled SQL, Apps Script or similar), handle timezones/currencies/late data and document the flow.
  • Advanced Excel/Google Sheets (validations, functions, etc.).
  • Clear, didactic communication; ability to mentor and raise the team’s level.
  • Nice-to-haves: ELT with Dataform/dbt (tests: unique/not null/referential), Git and standardized documentation.
  • Python (pandas) in Google Colab/Jupyter for validations, POCs and light automations.
  • Google Apps Script for Workspace integrations/routines (alerts, Sheets, APIs).
  • Media/CRM integration (Meta/Google/TikTok/LinkedIn × RD Station/HubSpot): join keys, daily granularity, reconciliation of currencies/timezones, deduplication and handling delays.
  • FinOps in BigQuery (column pruning, correct partitioning, pre-aggregations, BI Engine) and cost/performance monitoring.
  • Power BI Service (Deployment Pipelines, Tabular Editor/XMLA, governance in the Service).
  • Server-side tagging, Consent Mode and MMPs (AppsFlyer/Adjust).
  • Applied statistics (A/B testing, hypothesis testing) and basics of attribution models (MTA/MMM).
  • English for reading and meetings when necessary.

Benefits

  • Flexible benefits: choose how to allocate the benefit amount among meal voucher (VR), food allowance (VA), fuel voucher, home-office allowance, etc.;
  • Health and dental insurance: it’s important to take care of your health;
  • Life insurance: your safety matters to us too;
  • Annual bonus: to reward your dedication throughout the year;
  • Paid annual leave: because you deserve time to recharge;
  • Support for courses, certifications and events: we care about your development;
  • Birthday day off and a small gift;
  • Alura e-learning: employees have access to a learning path to take courses for free;
  • Referral program: help us find talent and earn a bonus;
  • Work in a dynamic, collaborative environment with lots of learning, recognition and flexible hours;
  • Hybrid work model (2 days in-office per week), based in the Berrini area.

Job title

Senior BI Analyst

Job type

Experience level

Senior

Salary

Not specified

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job