Senior Data Engineer (GCP / dbt / Looker)

<h2 data-path-to-node="0">Who is Artefact?</h2> <p data-path-to-node="1">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.</p> <p data-path-to-node="2">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.</p> <hr data-path-to-node="3"> <h2 data-path-to-node="4">Main Responsibilities</h2> <p data-path-to-node="5">As a <strong data-path-to-node="5" data-index-in-node="5">Data Engineer (GCP / dbt / Looker)</strong>, 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 <strong data-path-to-node="5" data-index-in-node="182">Business Insights & Analytics</strong> department, specifically supporting strategic network development initiatives.</p> <p data-path-to-node="6">You will focus on integrating and transforming data from planning systems into a robust <strong data-path-to-node="6" data-index-in-node="88">GCP environment</strong>, enriching data visibility through <strong data-path-to-node="6" data-index-in-node="139">Looker</strong>, and ensuring the long-term scalability of the data infrastructure. You will:</p> <ul data-path-to-node="7"> <li> <p data-path-to-node="7,0,0"><strong data-path-to-node="7,0,0" data-index-in-node="0">Data Pipeline Development:</strong> Design and build scalable data pipelines using <strong data-path-to-node="7,0,0" data-index-in-node="74">dbt and SQL</strong> on <strong data-path-to-node="7,0,0" data-index-in-node="89">GCP (BigQuery)</strong>. You will maintain existing pipelines, optimize for performance, and implement rigorous data historization.</p> </li> <li> <p data-path-to-node="7,1,0"><strong data-path-to-node="7,1,0" data-index-in-node="0">Business Collaboration:</strong> 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.</p> </li> <li> &lt