03 ago
|
Smadex
|
Barcelona
Experteer Overview In this role you will own and scale the analytics infrastructure across our global Finance, Operations, and Product reporting. You’ll turn raw data from ERP, CRM, adtech, and HRIS into reliable intelligence, build the BI reporting layer, and design scalable data pipelines. You will partner with Finance, Sales Ops, and Business Development to deliver dashboards, models, and ad-hoc analyses that inform strategic decisions for Adwake, Smadex, and Playback Rewards. Expect a hands-on, cross-functional environment with SOX-aligned governance and measurable business impact.Compensaciones / Incentivos
- Finance BI ownership: design, build, and maintain production Power BI dashboards and semantic models across GSS business units for financial performance, revenue, operational KPIs, and compliance metrics
- Data pipeline engineering: build robust, scalable ETL/ELT pipelines sourcing from ERP, CRM, HRIS, Tu0026E, Payroll system, etc
- Financial reporting: own multi-entity financial reporting models, including advertiser concentration analysis, margin analytics, billing reconciliation, and revenue recognition dashboards
- Data modeling: design and document dimensional data models (star schema, SCD) for financial and adtech datasets; maintain a single source of truth for key KPIs across entities
- Self-service enablement:
build and maintain standardized datasets and templates to empower Finance and Business stakeholders to answer questions independently
- Adtech analytics: develop reporting on campaign performance, publisher margins, DSP/SSP revenue, and attribution data—connecting adtech signals to financial outcomes
- Governance u0026 lineage: implement data quality checks, documentation, and lineage tracking to support SOX-compliant reporting and audit readinessResponsabilidades
- 5+ years in BI, data engineering, or analytics engineering roles in a commercial environment
- Expert-level BI skills: DAX, data modeling, row-level security, deployment pipelines, incremental refresh
- Strong SQL skills across SQL Server, BigQuery, Snowflake, or similar
- Hands-on ETL/ELT experience (dbt, Azure Data Factory, Python, or equivalent)
- ERP financial data experience, ideally NetSuite (GL structures, cost centers, intercompany eliminations, period-end reporting)
- CRM data models (Salesforce) and joining CRM pipeline data with financials
- Strong analytical thinking and ability to translate business questions into data models and dashboards
- Experience in SOX-compliant or audit-sensitive environments
- Exceptional English skills (C1)Requisitos principales
- Health Insurance
- Hybrid work format
- Ticket Restaurant
- Breakfast, fruit u0026 snacks at the office
- Regular Team Events
- Gift Cards for special occasions
📌 Senior Bi & Analytics Engineer (Barcelona)
🏢 Smadex
📍 Barcelona