Senior Data Engineer Gcp - Dbt - Looker H/F Artefact

Who is Artefact?

Artefact is a next-generation strategy and data consulting firm dedicated to transforming organizations through data and AI. We combine the rigor of top-tier strategy consulting with deep expertise in data, digital, and analytics to help clients achieve tangible business impact.

With 1,800+ consultants, data scientists, and engineers across 23 countries, we work with global leaders across various industries.

Main Responsibilities

As a Data Engineer (GCP / dbt / Looker), you will join our team as an external consultant to support a high-stakes project for a major global player. You will be a key driver in the Business Insights & Analytics department, specifically supporting strategic network development initiatives.

You will focus on integrating and transforming data from planning systems into a robust GCP environment, enriching data visibility through Looker, and ensuring the long-term scalability of the data infrastructure. You will:

- Data Pipeline Development: Design and build scalable data pipelines using dbt and SQL on GCP (BigQuery). You will maintain existing pipelines, optimize for performance, and implement rigorous data historization.
- Business Collaboration: Work closely with international business teams to translate complex requirements into technical data solutions. You will participate in design workshops and advise on data structure and integration approaches.
- Reporting & Visualization: Support the development and enhancement of reports in Looker using LookML, ensuring that data is accessible and intuitive for end-users across global markets.
- Quality & Documentation: Deliver high-quality technical and functional documentation, conducting regular audits of data flows to ensure absolute accuracy and completeness.
- Proactive Advisory: Act as a technical partner, proposing innovative solutions to maximize the value extracted from raw data.

Candidate Profile

We are looking for an engineer first, consultant second - someone with a builder's mindset and the ability to bridge the gap between technical architecture and business value.

- Education: Bachelor's or Master's degree in Computer Science, Data Engineering, or a related field.
- Technical Skills: Proficiency in SQL and dbt is essential. You must have hands-on experience with Google Cloud Platform (BigQuery).
- Data Modeling: Solid understanding of ETL/ELT processes, pipeline architecture, and data modeling best practices.
- Visualization: Working knowledge of Looker and LookML for professional data visualization.
- Soft Skills: Strong business acumen, attention to detail, and the ability to simplify complex data flows for commercial stakeholders.
- Languages: Fluency in English is mandatory; French or German is a strong plus.
- Nice to Have: Familiarity with Anaplan data logic or experience with commercial/distribution data domains.

Why Join Us

- Strategy with a Data Edge: Artefact sits uniquely at the crossroads of strategy and tech, giving you the chance to work on high-impact initiatives for prestigious global brands.
- Romandie Office Impact: As part of our growing Swiss team, you will have visibility and impact from day one, working within a dynamic, forward-thinking analytics environment.
- Cutting-Edge Stack: Work with a modern data stack (GCP, dbt, Looker) on projects that empower data-led decisions at a global scale.
- Culture of Doers: We are entrepreneurial, fast-moving, and committed to delivering impact - while supporting each other's growth.

This position is based in Paris with frequent travels to Switzerland and opportunity to relocate.

Don't worry if you don't meet all the criteria! We value motivation and potential above all else. We'd love to hear from you.