Senior Data Modeler (Snowflake)

<h3>Company Description</h3><p><strong>Swiss Delivery Excellence: Transforming Life Science Consulting Worldwide.</strong></p><p>Fusion Consulting is a globally leading Business and IT boutique consultancy specialized in the Life Sciences industry, partnering with leading companies in pharma, healthcare, and animal health.</p><p>With over 450 employees and 25 offices worldwide, our mission is to revolutionize our clients' business transformation challenges and set new industry standards through innovative solutions.</p><p>Focused on S4HANA, Data &amp; Cloud, and innovative technologies, Fusion Consulting brings unparalleled expertise and commitment to excellence to every project we undertake.</p><p>Grounded in our commitment to fast and intelligent decision-making, our client-first and open-hearted approach defines our ethos. With unwavering support and an entrepreneurial spirit, our global teamwork transcends boundaries and turns shared visions into reality.</p><h3>Job Description</h3><p>We are looking for a skilled and motivated <strong>Data Modeler (Snowflake)</strong> to support the integration of regional data warehouses into a centralized Snowflake-based data platform for our clients in the pharmaceutical industry. This mid-level role is ideal for candidates with a strong foundation in physical data modeling and implementation, particularly within Snowflake, and who can collaborate across data engineering, architecture, and governance teams. You'll play a vital role in ensuring the data platform is efficient, scalable, and compliant with best practices and governance standards.<br/> <br/> <strong>What You Will Be Doing</strong>:</p><ul><li>Design and implement physical data models in Snowflake, focusing on scalability, performance, and maintainability.</li><li>Translate conceptual and logical models into Snowflake-ready schemas, tables, and views.</li><li>Collaborate with data engineers to refine ETL/ELT processes and data integration patterns.</li><li>Align models and metadata with governance standards and tools, including Collibra.</li><li>Ensure all modeling and transformation logic is well-documented for traceability and compliance.</li><li>Support performance tuning and optimization of data pipelines.</li><li>Work in a distributed, global environment with both technical and business stakeholders.</li></ul><h3>Qualifications</h3><ul><li>4–7 years of experience as a Data Modeler or similar role.</li><li>Proven expertise in Snowflake physical data modeling and SQL.</li><li>Understanding of data integration and ETL/ELT principles; experience with tools like dbt, Matillion, or Fivetran is a plus.</li><li>Experience with metadata and data governance platforms, ideally Collibra.</li><li>Familiarity with AWS services, particularly S3 is a plus</li><li>Solid grasp of data modeling best practices (e.g., star schema, normalization, data vault).</li><li>Ability to work independently in a remote, cross-functional environment.</li><li>Excellent communication and documentation skills.</li></ul><p><br/> <strong>Preferred</strong>:</p><ul><li>Experience in pharmaceutical/life sciences data and regulatory frameworks.</li><li>Familiarity with data quality tools such as Ataccama.</li></ul><h3>Additional Information</h3><p><strong>WHY YOU SHOULD JOIN FUSION:</strong></p><p>At Fusion, you’ll join a diverse team of talented professionals from around the world, united by a passion for delivering impactful digital transformation in the life sciences industry. You’ll be part of a flat-structured, collaborative organization where decisions are made efficiently, and your expertise directly shapes client outcomes.</p><p>You’ll work alongside experienced consultants on complex, meaningful projects that demand both precision and innovation. Our culture emphasizes continuous learning, open knowledge sharing, and cross-functional teamwork—empowering you to grow both professionally and personally.</p><p>Joining Fusion means becoming part of a company that:</p><ul><li><strong>Builds strong, trusted partnerships with clients</strong>, delivering tailored solutions that create real business value.</li><li><strong>Drives delivery excellence</strong>, holding ourselves accountable for the quality and impact of every outcome.</li><li><strong>Encourages entrepreneurial thinking</strong>, empowering you to take initiative, solve problems, and lead change.</li><li><strong>Operates with a truly global mindset</strong>, where diverse perspectives, cultures, and collaboration fuel our success.</li></ul><p><strong>WHAT WE OFFER - FUSION BENEFITS</strong></p><p>We’ve designed our benefits to support your growth, well-being, and global mobility.</p><p><strong>Flexibility &amp; Balance</strong></p><ul><li>Work from Anywhere: Enjoy up to 25 days per year of remote work from any global location.</li><li>Recharge Freely: Take the time you need with flexible time off—beyond standard holiday allowances.</li><li>Connect as a Team: Use your team’s inte