Senior Analytics Consultant (GCP / dbt / Looker)

<h2 data-path-to-node="6"><strong data-path-to-node="6" data-index-in-node="0">Who is Artefact?</strong></h2> <p data-path-to-node="7">Artefact is a next-generation strategy and data consulting firm. We sit at the intersection of top-tier strategy consulting and deep technical expertise. Our mission is to transform data into a competitive advantage for the world’s largest brands.</p> <p data-path-to-node="8">In our Romandie office, we don't just "process" data—we use it to solve high-stakes business puzzles. We are looking for a Senior Consultant who can bridge the gap between complex data ecosystems and executive-level decision-making.</p> <hr data-path-to-node="9"> <h2 data-path-to-node="10"><strong data-path-to-node="10" data-index-in-node="0">The Mission statement: Translating Data into Strategy</strong></h2> <p data-path-to-node="11">As a <strong data-path-to-node="11" data-index-in-node="5">Senior Analytics Consultant</strong>, you are the primary link between a major global client’s business goals and their technical infrastructure. This role isn't about building heavy infrastructure from scratch; it’s about <strong data-path-to-node="11" data-index-in-node="219">Analytics Engineering</strong>—architecting the logic that turns raw information into business intelligence.</p> <h3 data-path-to-node="12"><strong data-path-to-node="12" data-index-in-node="0">Core Responsibilities</strong></h3> <ul data-path-to-node="13"> <li> <p data-path-to-node="13,0,0"><strong data-path-to-node="13,0,0" data-index-in-node="0">Strategic Stakeholder Management:</strong> Lead workshops with international business leads to define KPIs and translate vague business questions into precise technical requirements.</p> </li> <li> <p data-path-to-node="13,1,0"><strong data-path-to-node="13,1,0" data-index-in-node="0">Analytics Engineering (dbt &amp; BigQuery):</strong> Design and maintain high-quality data models. You will own the "logic layer," ensuring that data is transformed, historized, and optimized for business use cases.</p> </li> <li> <p data-path-to-node="13,2,0"><strong data-path-to-node="13,2,0" data-index-in-node="0">Storytelling &amp; Visualization:</strong> Architect the <strong data-path-to-node="13,2,0" data-index-in-node="44">Looker (LookML)</strong> environment. You will ensure that dashboards aren't just "pretty," but are actionable tools that global markets rely on daily.</p> </li> <li> <p data-path-to-node="13,3,0"><strong data-path-to-node="13,3,0" data-index-in-node="0">Process Leadership:</strong> Act as the guardian of data quality. You will define documentation standards, conduct audits, and ensure the long-term scalability of the analytics solution.</p> </li> <li> <p data-path-to-node="13,4,0"><strong data-path-to-node="13,4,0" data-index-in-node="0">Proactive Advisory:</strong> As a Senior member, you are expected to challenge the status quo. You will identify opportunities where data can drive more value and propose roadmap enhancements to the client.</p> </li> </ul> <hr data-path-to-node="14"> <h2 data-path-to-node="15"><strong data-path-to-node="15" data-index-in-node="0">Candidate Profile: The "Consultant Mindset"</strong></h2> <p data-path-to-node="16">We are looking for a <strong data-path-to-node="16" data-index-in-node="21">"Translator."</strong> You should be someone who enjoys the nuance of business operations just as much as a clean SQL query.</p> <ul data-path-to-node="17"> <li> <p data-path-to-node="17,0,0"><strong data-path-to-node="17,0,0" data-index-in-node="0">The Mindset:</strong> You are a consultant first. You understand that tech is a means to an end. You are comfortable presenting to senior stakeholders and can explain complex data flows in simple, commercial terms.</p> </li> <li> <p data-path-to-node="17,1,0"><strong data-path-to-node="17,1,0" data-index-in-node="0">Technical Proficiency:</strong> * Expert-level <strong data-path-to-node="17,1,0" data-index-in-node="38">SQL</strong> and significant experience with <strong data-path-to-node="17,1,0" data-index-in-node="74">dbt</strong>.</p> <ul data-path-to-node="17,1,1"> <li> <p data-path-to-node="17,1,1,0,0">Hands-on experience with the <strong data-path-to-node="17,1,1,0,0" data-index-in-node="29">Google Cloud Platform (BigQuery)</strong>.</p> </li> <li> <p data-path-to-node="17,1,1,1,0">Professional mastery of <strong data-path-to-node="17,1,1,1,0" data-index-in-node="24">Looker and LookML</strong>.</p> </li> </ul> </li> <li> <p data-path-to-node="17,2,0"><strong data-path-to-node="17,2,0" data-index-in-node="0">Business Acumen:</strong> You have a solid grasp of how global corporations operate (supply chain, distribution, or commercial data). Experience with <strong data-path-to-node="17,2,0" data-index-in-node="141">Anaplan</strong> logic is a major plus.</p> </li> <li> <p data-path-to-node="17,3,0"><strong data-path-to-node="17,3,0" data-index-in-node="0">Experience:</strong> 3+ years in data analytics, business intelligence, or consulting. You have a track record of owning projects from requirements gathering to final delivery.</p> </li> <li> <p data-path-to-node="17,4,0"><strong data-path-to-node="17,4,0" data-index-in-node="0">Languages:</strong> Fluency in <strong data-path-to-node="17,4,0" data-index-in-node="22">English and French</strong> are mandatory.</p> </li> </ul> <hr data-path-to-node="18"> <h2 data-path-to-node="19"><strong data-path-to-node="19" data-index-in-node="0">Why Join Artefact Switzerland?</strong></h2> <ul data-path-to-node="20"> <li> <p data-path-to-node="20,0,0"><strong data-path-to-node="20,0,0" data-index-in-node="0">Senior Impact:</strong> You will have high visibility within the firm and with the client. You aren't a cog in a machine; you are an architect of solutions.</p> </li> <li> <p data-path-to-node="20,1,0"><strong data-path-to-node="20,1,0" data-index-in-node="0">Modern Analytics Stack:</strong> We focus on the "best of breed" tools (GCP, dbt, Looker), allowing you to spend more time on insights and less time on technical "plumbing."</p> </li> <li> <p data-path-to-node="20,2,0"><strong data-path-to-node="20,2,0" data-index-in-node="0">Entrepreneurial Culture:</strong> We are a fast-growing team in Switzerland. You will help shape the culture and the way we deliver projects.</p> </li> <li> <p data-path-to-node="20,3,0"><strong data-path-to-node="20,3,0" data-index-in-node="0">Focus on Value:</strong> We prioritize tangible business impact over technical vanity projects.</p> </li> </ul> <p>This position is located in the Geneva area.</p>