Analytics Engineer

Ogury; Paris; Sur place; EUR 40 000 - 80 000; Plein temps

Résumé du poste

An innovative adtech company is seeking an Analytics Engineer to enhance data accessibility for decision-making across various business functions. In this role, you will transform raw data into structured datasets, ensuring reliability and actionability for stakeholders. Your expertise will optimize operations, from marketing lead acquisition to financial analysis. This dynamic position offers the chance to work with cutting-edge tools and collaborate with diverse teams. If you're passionate about data and eager to make an impact, this opportunity is perfect for you!

Prestations

Competitive compensation package

Flexibility in working hours and location

Generous holiday and leave allowance

Daily meal voucher

Access to physical and mental health resources

Qualifications

• Proficient in SQL and dbt for data modeling and transformation.
• Experience with Redshift and optimizing query performance.

Responsabilités

• Design and maintain scalable data models and transformation pipelines.
• Collaborate with stakeholders to understand data requirements.

Connaissances

SQL

dbt (Data Build Tool)

Amazon Redshift

Data Pipelines

Airflow

Communication Skills

Outils

NetSuite

Salesforce

HubSpot

TravelPerk

Expensify

Clickhouse

Description du poste

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 19 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. Every day.

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.

Working at Ogury

At Ogury, we pledge to provide all our team members with an equitable voice across our company and community. We understand that to have Ogurians who are engaged, respected, and who feel proud to belong means creating a safe space where everyone feels comfortable bringing their most authentic selves to work. Every day.

About the Role

Ogury is seeking an Analytics Engineer to join our growing Corporate Data team.

This role is focused on enabling business teams across Finance, Sales, Marketing, IT, and other corporate functions to access and leverage high-quality, well-modeled data for decision-making and operational efficiency.

As an Analytics Engineer, you will be responsible for transforming raw data from various business tools into structured, accessible datasets that support reporting, analysis, and automation.

You will collaborate with business stakeholders to understand their needs and ensure data is available, reliable, and actionable.

Your work will help optimize business operations such as lead acquisition for marketing, sales spend tracking, financial supplier-side analysis, and IT asset management.

What you will be doing

1. Design, build, and maintain scalable data models and transformation pipelines following Data Platform requirements to support corporate data needs.
2. Work with stakeholders (ops or analysts) in Finance, Sales, Marketing, IT, and other business units to understand their data requirements and develop appropriate solutions.
3. Develop and maintain data transformations using dbt (Data Build Tool) to ensure clean, reliable, and well-documented data models.
4. Own and optimize ELT workflows using Airflow and other orchestration tools.
5. Manage and optimize data storage and querying performance in Amazon Redshift and in the future Clickhouse.
6. Collaborate with the Data Platform team to integrate business-critical tools such as NetSuite, Salesforce, HubSpot, TravelPerk, Expensify, and Yooz into our data ecosystem.
7. Ensure data quality governance and security best practices are applied across all datasets.
8. Build or help analysts to build and maintain business intelligence dashboards and reports in Omni to enable self-service analytics.

What you will bring to Ogury

1. Proficient in SQL with experience in writing efficient and maintainable queries for data modeling and transformation.
2. Hands-on experience with dbt for transforming and structuring data within cloud-based data warehouses.
3. Experience with Redshift (or other columnar databases like BigQuery, Snowflake, Clickhouse) and optimizing query performance.
4. Strong understanding of data pipelines, ELT workflows, and orchestration tools (Airflow, Prefect, Dagster, or similar). Ability to work closely with business stakeholders translating business needs into scalable data solutions.
5. Experience integrating data from business and corporate tools such as NetSuite, Salesforce, TravelPerk, Expensify, HubSpot, Yooz is a plus.
6. Comfortable working in a fast-paced evolving environment with multiple priorities.
7. Strong communication and collaboration skills with the ability to make data accessible and actionable for non-technical users.

How Ogury supports you

At Ogury, we believe in taking care of our team members and providing a work environment that supports both professional growth and personal wellbeing.

While benefits may vary by location, here’s a glimpse of what you can typically expect when you join our team:

• A competitive compensation package
• Flexibility in working hours and location
• Generous holiday and leave allowance in addition to national holidays
• Daily meal voucher
• A strong focus on the wellbeing of our team members with access to both physical and mental health resources
• And more

We thank you in advance for your interest in Ogury!

Our Commitment

At Ogury, we are committed to fostering an inclusive workplace by providing equal employment opportunities to all. We will consider all qualified applicants without discrimination based on any characteristic protected by applicable laws.

We are committed to providing an accessible and inclusive candidate experience. If you require accommodations during the recruitment process please contact us. In accordance with applicable laws, we will work with you to provide reasonable support and ensure a fair hiring process.

Please note that this position is for an existing vacancy and is open to all qualified candidates.

Key Skills