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. #J-18808-Ljbffr