Senior Data Engineer (GCP / dbt / Looker)

Über diese Stelle

<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> <p data-path-to-node="7,2,0"><strong data-path-to-node="7,2,0" data-index-in-node="0">Reporting & Visualization:</strong> Support the development and enhancement of reports in <strong data-path-to-node="7,2,0" data-index-in-node="81">Looker using LookML</strong>, ensuring that data is accessible and intuitive for end-users across global markets.</p> </li> <li> <p data-path-to-node="7,3,0"><strong data-path-to-node="7,3,0" data-index-in-node="0">Quality & Documentation:</strong> Deliver high-quality technical and functional documentation, conducting regular audits of data flows to ensure absolute accuracy and completeness.</p> </li> <li> <p data-path-to-node="7,4,0"><strong data-path-to-node="7,4,0" data-index-in-node="0">Proactive Advisory:</strong> Act as a technical partner, proposing innovative solutions to maximize the value extracted from raw data.</p> </li> </ul> <hr data-path-to-node="8"> <h2 data-path-to-node="9">Candidate Profile</h2> <p data-path-to-node="10">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.</p> <ul data-path-to-node="11"> <li> <p data-path-to-node="11,0,0"><strong data-path-to-node="11,0,0" data-index-in-node="0">Education:</strong> Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a related field.</p> </li> <li> <p data-path-to-node="11,1,0"><strong data-path-to-node="11,1,0" data-index-in-node="0">Technical Skills:</strong> Proficiency in <strong data-path-to-node="11,1,0" data-index-in-node="33">SQL</strong> and <strong data-path-to-node="11,1,0" data-index-in-node="41">dbt</strong> is essential. You must have hands-on experience with <strong data-path-to-node="11,1,0" data-index-in-node="98">Google Cloud Platform (BigQuery)</strong>.</p> </li> <li> <p data-path-to-node="11,2,0"><strong data-path-to-node="11,2,0" data-index-in-node="0">Data Modeling:</strong> Solid understanding of ETL/ELT processes, pipeline architecture, and data modeling best practices.</p> </li> <li> <p data-path-to-node="11,3,0"><strong data-path-to-node="11,3,0" data-index-in-node="0">Visualization:</strong> Working knowledge of <strong data-path-to-node="11,3,0" data-index-in-node="36">Looker and…