04 ago
|
Entravision Digital Global Advertising powered by Technology
|
Barcelona
04 ago
Entravision Digital Global Advertising powered by Technology
Barcelona
ppEntravision AdTech Services (ATS) is looking for a Senior BI Analytics Engineer to own and scale the analytics infrastructure across our integral function. This role sits at the center of Finance, Operations, and Product reporting — responsible for turning raw data from our ERP, CRM, adtech, and HRIS platforms into reliable, decision‑ready intelligence. /p pYou will build and maintain our BI reporting layer, design scalable data pipelines, and partner with Finance, Sales Ops, and Business Development teams to deliver dashboards, models, and ad‑hoc analyses that drive strategic decisions across Adwake, Smadex, and Playback Rewards. /p h3Key Responsibilities /h3 ul liFinance BI ownership: Design, build, and maintain production Power BI dashboards and semantic models across GSS business units — covering financial performance, revenue, operational KPIs, and compliance metrics /li liData pipeline engineering: Build robust, scalable ETL/ELT pipelines sourcing from ERP, CRM, HRIS, TE, Payroll system, etc /li liFinancial reporting: Own multi‑entity financial reporting models, including advertiser concentration analysis, margin analytics, billing reconciliation, and revenue recognition dashboards /li liData 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 /li liSelf‑service enablement: Build and maintain standardized datasets and templates that empower Finance and Business stakeholders to answer questions independently without analyst bottlenecks /li liAdtech analytics: Develop reporting on campaign performance, publisher margins, DSP/SSP revenue, and attribution data — connecting adtech signals to financial outcomes /li liGovernance lineage: Implement data quality checks, documentation,
and lineage tracking to support SOX‑compliant reporting and audit readiness /li /ul h3Requirements /h3 ul li5+ years of experience in BI, data engineering, or analytics engineering roles in a commercial environment /li liExpert‑level BI skills: DAX, data modeling, row‑level security, deployment pipelines, incremental refresh /li liStrong SQL skills across multiple platforms (SQL Server, BigQuery, Snowflake, or similar) /li liHands‑on experience building and maintaining ETL/ELT pipelines (dbt, Azure Data Factory, Python, or equivalent) /li liExperience working with ERP financial data, ideally NetSuite — understanding GL structures, cost centres, intercompany eliminations, and period‑end reporting /li liFamiliarity with CRM data models (Salesforce) and the ability to join CRM pipeline data with financial actuals /li liStrong analytical thinking with the ability to translate business questions into data models and dashboards /li liExperience working in SOX‑compliant or audit‑sensitive environments /li liExceptional English skills (C1 level), both written and spoken /li /ul h3Nice to Have /h3 ul liExperience with adtech platforms: MMPs, DSP/SSP reporting APIs /li lidbt (data build tool) experience for modular, tested SQL transformations /li liBackground in adtech, mobile marketing, FinTech, or performance marketing analytics /li liPython for data pipeline scripting and automation /li liAWS and/or GCP cloud data platform experience /li /ul pSubmit your CV in English to be considered for this role. /p h3What We Offer /h3 ul liExciting challenges and opportunities for growth /li liTicket Restaurant /li liAccess to gyms and studios around Barcelona /li liHealth Insurance /li liBreakfast, Fruit Snacks at the office /li liRegular Team Events /liliWork Anniversary Celebrations /li liGift Cards for special occasions /li liReferral Program /li liHybrid work format /li /ul /p #J-18808-Ljbffr
📌 Senior BI & Analytics Engineer (Barcelona)
🏢 Entravision Digital Global Advertising powered by Technology
📍 Barcelona