Overview
Data Modeler (Snowflake) – to support the integration of regional data warehouses into a centralized Snowflake-based data platform for clients in the pharmaceutical industry. This mid-level role requires a strong foundation in physical data modeling and implementation within Snowflake, with collaboration across data engineering, architecture, and governance teams to ensure an efficient, scalable, and compliant data platform.
What You Will Be Doing
- Design and implement physical data models in Snowflake, focusing on scalability, performance, and maintainability.
- Translate conceptual and logical models into Snowflake-ready schemas, tables, and views.
- Collaborate with data engineers to refine ETL / ELT processes and data integration patterns.
- Align models and metadata with governance standards and tools, including Collibra.
- Ensure all modeling and transformation logic is well-documented for traceability and compliance.
- Support performance tuning and optimization of data pipelines.
- Work in a distributed, global environment with both technical and business stakeholders.
Qualifications
4–7 years of experience as a Data Modeler or similar role.Proven expertise in Snowflake physical data modeling and SQL.Understanding of data integration and ETL / ELT principles;experience with tools like dbt, Matillion, or Fivetran is a plus.
Experience with metadata and data governance platforms, ideally Collibra.Familiarity with AWS services, particularly S3 is a plus.Solid grasp of data modeling best practices (e.G., star schema, normalization, data vault).Ability to work independently in a remote, cross-functional environment.Excellent communication and documentation skills.Preferred
Experience in pharmaceutical / life sciences data and regulatory frameworks.Familiarity with data quality tools such as Ataccama.Why You Should Join Fusion
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. 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.
Builds strong, trusted partnerships with clients, delivering tailored solutions that create real business value.Drives delivery excellence, holding ourselves accountable for the quality and impact of every outcome.Encourages entrepreneurial thinking, empowering you to take initiative, solve problems, and lead change.Operates with a truly global mindset, where diverse perspectives, cultures, and collaboration fuel our success.What We Offer – Fusion Benefits
We’ve designed our benefits to support your growth, well-being, and global mobility.
Flexibility & BalanceWork from Anywhere : Up to 25 days per year of remote work from any global location.Recharge Freely : Flexible time off beyond standard holiday allowances.Connect as a Team : Use your team’s integration budget to meet, collaborate, and bond.Celebrate Your Birthday : A birthday gift from Fusion.Growth & DevelopmentInvest in Your Learning : CHF 1,500 annually for professional development.Grow Your Skills : Regular workshops and trainings to strengthen technical and soft skills.Advance Continuously : Build the mindset and capabilities to grow your career.Shape an Inclusive Culture : An environment where your individuality is valued and your voice drives change.Recognition & RewardCompetitive salary and benefits that reflect impact.Refer Talent : Rewards for referrals.Unity Scheme : Loyalty-based benefits starting from year three.Global Mobility & Local SupportRelocation assistance when moving for work.Visa, permits, and international assignments support.Regionally tailored perks and global collaboration.Our Selection Process
Your time is valuable. Our hiring process is clear, efficient, and focused on mutual fit :
Upload Your CV – Apply using the relevant button (approx. 3 minutes).Profile Review – Talent Acquisition assesses your CV and experience (approx. 2 weeks).Introductory Call – Brief 15–30 minute conversation to share more about Fusion and the role.Technical Interview – 30-minute session with a domain expert.Client Interview (if applicable) – 30–60 minutes online for some roles.Final Feedback – Timely feedback and next steps.Fusion is an equal opportunity employer. We value diversity and are committed to fostering an inclusive workplace for all.
#J-18808-Ljbffr