Commercial Reporting Analyst

Ogury is a global adtech company that delivers Personified Advertising solutions grounded in privacy to brands, agencies and publishers by focusing on targeting personas, not people.

We deliver relevant audiences at scale and on quality publisher inventory thanks to our exclusive data, which is meticulously collected and crafted from millions of self-declared customer surveys, enriched with billions of impactful data points, and refined by AI. This results in audience insights and performance not available through any other AdTech platform.

Founded in 2014, Ogury is a global organization with a diverse team of 500+ people across 17 countries.

At Ogury, our vision unites us all. But we know that it takes people from all walks of life to come together and make it happen. We embrace and celebrate what makes us different, creating a unique and winning culture where everyone feels safe, has access to the same opportunities, and is excited about bringing their most authentic self to work. Everyday. 

Together we’re changing the face of adtech with values that inspire excellence, standards that encourage a leadership mindset, and an inclusive workplace where Ogurians are engaged and know they belong.

The Opportunity

We are looking for a motivated and detail-oriented Commercial Reporting Analyst to join our newly established Sales Effectiveness Team.

In this pivotal role, you will help drive the standardization, development, and maintenance of key reports, dashboards, and queries that provide valuable business insights to our commercial teams.

Working closely with our Senior Sales Effectiveness Analyst, you will play a key role in building scalable reporting frameworks, ensuring that our sales and commercial operations teams have seamless access to the data they need for informed decision-making.

This role will report directly to the Global Sales Effectiveness Director and is based out of our Barcelona office, where we encourage our teams to join us in person at least two days per week.

What you will do

• Partner with the Senior Sales Effectiveness Analyst to design and implement standardized, scalable reports for commercial teams, ensuring consistency across reporting tools
• Develop, optimize, and maintain SQL queries to extract and transform data from multiple data sources
• Assist in creating dashboards and reports using tools such as Omni, Looker, and Salesforce to deliver actionable business insights
• Support the setup and maintenance of self-service reporting tools, empowering non-technical users to generate and access relevant data independently
• Conduct regular data validation and testing to ensure the accuracy, reliability, and integrity of reports and dashboards
• Monitor data pipelines to identify and troubleshoot any issues in reporting tools, ensuring seamless data flow
• Document reporting processes and best practices, providing clear guidelines to help business users understand and effectively utilize reports
• Provide training and support to commercial teams on self-service tools and how to interpret and act on reports
• Collaborate with sales, operations, and FP&A teams to collect feedback and refine reporting requirements for continuous improvement
• Work closely with the BI team to ensure commercial reporting initiatives are aligned with broader organizational strategies.

What you will bring to Ogury

• Prior experience in Business Analytics, Information Systems, Computer Science, Finance, or a related field
• Proficient in SQL, with the ability to write queries to extract and manipulate data effectively
• Experience with BI tools such as Omni, Looker, or Tableau to create impactful reports and dashboards
• Knowledge of Excel for data analysis, reporting, and complex functions is a plus
• Strong analytical skills with a keen attention to detail to ensure accurate insights
• Excellent communication skills, both written and verbal, with the ability to translate technical concepts to non-technical stakeholders
• Time management skills, with the ability to prioritize tasks and meet deadlines in a fast-paced environment
• Proactive problem-solving approach and a continuous improvement mindset to drive efficiency
• Familiarity with data warehousing concepts and data integration best practices
• Experience in fast-paced industries such as ad tech, tech, or SaaS is a plus

#LI-HP1 #LI-Hybrid

We thank you in advance for your interest in Ogury!

Applications will close on February 28, 2025.

Benefits vary by locations but you can expect: 

- Competitive salary

- 401k matching

- Flexible working options

- Generous holiday leave on top of the standard national and local holidays

- Monthly meal vouchers

- Life insurance plan

- Modern and collaborative working space

- Keeping our Ogurians happy and healthy is a priority for us, so we offer access to both physical and mental health and wellbeing resources

At Ogury we are a group of creative thinkers and action-takers that thrive in a diverse and inclusive workplace.