Senior Data Analyst

About the role

The is entrusted with owning the integrity and actionable output of advertising platform reporting and analytics. This role serves as the critical bridge between complex data insights and day-to-day operational execution for the business. The hire will be responsible for designing intake workflows for new metric requests from diverse client stakeholders and internal partners. They will construct dimensional models within dbt specifically to power cross-channel performance views that inform strategy. Establishing review checkpoints to validate rule compliance before any dashboard goes live is a core ownership. The position requires shipping weekly reports that track campaign health using SQL-derived data assets with precision. Collaboration is central, requiring close partnership with Data Reporting and Platform Engineering teams to ensure alignment. Ultimately, the analyst will utilize dbt to construct reliable data models that form the definitive foundation for global business decisions at Ogury.

Key facts

What you'll do

• Execute the work posted for the Senior Data Analyst role at Ogury in Barcelona.
• Translate ambiguous business questions from client services and product teams into structured analytical approaches.
• Design intake workflows to capture and clarify new metric requirements from stakeholders efficiently.
• Construct dimensional models within dbt to power cross-channel performance views for reporting.
• Establish review checkpoints to validate rule compliance before dashboard publication.
• Ship weekly reports that track campaign health using SQL-derived data assets.
• Partner with engineering teams to align schema changes with product roadmaps and analytics needs.
• Automate routine validation steps to free up analyst capacity for strategic hypothesis testing.
• Refine data definitions to ensure consistent naming conventions across all reporting environments.
• Guide product teams through analytics implementation reviews for major platform updates and changes.
• Follow the scope and instructions outlined -
• Utilize dbt and SQL to build and maintain the data models required for reporting.
• Contribute to changing the face of adtech by supporting data-driven decisions with robust analytics.

Requirements

• Possess a minimum of three years of experience analyzing advertising datasets in technical capacities.
• Demonstrate the ability to write complex SQL queries against large dimensional tables with confidence.
• Show fluency in dbt for transformation logic and data modeling as a core requirement of the position.
• Maintain a clear understanding of advertising metrics, including reach, frequency, and attribution models.
• Exhibit the capability to translate ambiguous business questions into structured analytical approaches.
• Commit to adhering to Ogury's values of inclusivity, engagement, and belonging in the workplace.
• Thrive in a collaborative environment where diverse backgrounds are welcomed and celebrated.
• Ensure a safe and authentic working space where every team member can engage fully.
• Align with the company vision to unite all individuals through data and shared goals.
• Meet the hard bars of experience and technical skill as defined for this senior role.
• Be prepared to apply directly on the official Ogury posting to confirm current requirements.
• Understand that this role operates under full-time engagement in the Barcelona location.
• Acknowledge that compensation details should be verified Nice to have
• Experience with Persona Intelligence concepts would support your contributions to the team.

Practical notes

• What you'll do includes following the scope and instructions outlined in the official Ogury posting for this role.
• This position is based in Barcelona and operates on a full-time basis.
• The compensation range for this role is specified as 55,000 EUR to 70,000 EUR.
• Candidates are expected to apply directly through the official Ogury posting to confirm current requirements and to proceed with the application process.
• This role requires a long-term commitment to the Barcelona location under full-time engagement terms.
• No specific deadline for applications is mentioned in the provided source material.