AdTechTalent
Data Science1 month agoHybrid

Ogury

Senior Data Analyst

dbtSQLSnowflakeBigQueryClickHousedata modelingdata governancebusiness intelligenceadtechanalyticsdata sciencedashboardhybrid

Key details

Salary

Not specified

Employment type

Full-time

Seniority

Senior

Years experience

5-10

Location

Barcelona, Spain

Full job description

Ogury is seeking a Senior Data Analyst to specialize in advertising platform reporting and analytics. The role involves building scalable, automated reporting solutions to support Product and Client Services teams. Responsibilities include designing automated dashboards, leading data governance and quality initiatives, building production-grade data models with dbt, and collaborating cross-functionally to provide actionable insights. Requirements include 5+ years in Data Analytics or BI, expertise in dbt, SQL, cloud data warehouses (Snowflake, BigQuery, ClickHouse), proficiency in BI tools (Omni, Tableau, Looker, Power BI), and strong communication skills. The position offers a hybrid work model based in Barcelona with benefits including competitive compensation, comprehensive coverage, meal vouchers, leave allowances, and health resources.

What you'll do

  • Design, develop, and scale automated dashboards and analytics solutions that provide deep insights into ad platform performance, campaign delivery, and user engagement for both Product and Client Services teams
  • Lead initiatives to define data standards, enforce data quality checks, and document data lineages to ensure a trusted, single source of truth
  • Build, maintain, and optimize production-grade data models using dbt, ensuring efficient transformations and analytics-ready datasets
  • Act as the analytical partner to Product Managers and Client Services to guide feature development and provide scalable client-facing insights
  • Uncover trends, identify platform inefficiencies, and provide actionable recommendations that optimize ad revenue and user experience

Requirements

  • 5+ years of experience in Data Analytics, Business Intelligence, or Analytics Engineering, ideally within an AdTech
  • Proven hands-on experience using dbt to develop, test, and deploy scalable data models in a cloud data warehouse (e.g., Snowflake, BigQuery, ClickHouse)
  • Expert-level SQL skills, including writing highly optimized, complex queries and managing large-scale, clickstream, or transactional datasets
  • Advanced proficiency in building scalable, intuitive dashboards in modern BI tools (e.g. Omni, Tableau, Looker, Power BI) tailored for both internal product tracking and external client services
  • Strong understanding of data quality frameworks, data governance principles, and version control (Git)
  • Exceptional communication skills with a track record of translating complex technical metrics into scalable solutions for product teams and business clients

Tech stack

dbtSQLSnowflakeBigQueryClickHouseOmniTableauLookerPower BIGit

Benefits

A competitive compensation packageComprehensive benefits coverageMeal voucherHoliday and leave allowance, in addition to national holidaysAccess to physical and mental health resourcesFlexible Working Model with hybrid approach: two core in-office collaboration days plus one additional office day of your choosing

Apply now

Ready to take the next step in your career? Click the button below to continue to the application process.

Continue to applicationBrowse more jobs

Similar jobs

More roles worth a look

Related opportunities based on specialty and working model so candidates can keep momentum.