Job Description

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. Our Romandie office (Lausanne / Geneva) is at the heart of Artefact's growth, advising clients on their most pressing strategic challenges -- from AI strategy and governance to digital transformation roadmaps and advanced data engineering.

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.

Work Eligibility:

You must be eligible to work in Switzerland.

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 the Lausanne / Geneva area.

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.