Find Jobs
Find Jobs Near You – Available Work in Your Location
Skip to job details
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.
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.
Focused on S4HANA, Data & Cloud, and innovative technologies, Fusion Consulting brings unparalleled expertise and commitment to excellence to every project we undertake.
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.
Job DescriptionWe are looking for a skilled and motivated Data Modeler (Snowflake) 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.
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.
Qualifications4-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 Data Vault 2.0 is a mustExperience with metadata and data governance platforms, ideally Collibra.
Familiarity with AWS services, particularly S3 is a plusSolid 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.
Familiarity with data quality tools such as Ataccama.
Additional Information
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.
Joining Fusion means becoming part of a company that:
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.
Connect as a
Growth & DevelopmentInvest in
Shape an
Global Mobility & Local SupportRelocate with
Upload Your CV
FC
Fusion Consulting
Senior Data Modeler (Snowflake)
Career Insights for Data Scientist
See where this job fits in the broader career landscape. Knowing your career path helps you see what's possible from here.
Scorecard
Based on national data
Review key factors to help you decide if this role fits your goals. How is this calculated?
What they do
A Data Scientist utilizes skills and experience to systematically answer questions using data to provide actionable recommendations. Commonly utilizes advanced statistical analysis and machine learning techniques. Common responsibilities also include data cleaning and data management.
$110,146 / year median in the U.S.
+15% projected growth
Job Description
Company DescriptionSwiss Delivery Excellence:
Transforming Life Science Consulting Worldwide.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.
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.
Focused on S4HANA, Data & Cloud, and innovative technologies, Fusion Consulting brings unparalleled expertise and commitment to excellence to every project we undertake.
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.
Job DescriptionWe are looking for a skilled and motivated Data Modeler (Snowflake) 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.
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.
Qualifications4-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 Data Vault 2.0 is a mustExperience with metadata and data governance platforms, ideally Collibra.
Familiarity with AWS services, particularly S3 is a plusSolid 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.
Additional Information
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.
Joining Fusion means becoming part of a company that:
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 BENEFITSWe've designed our benefits to support your growth, well-being, and global mobility.
Anywhere:
Enjoy up to 25 days per year of remote work from any global location.Recharge Freely:
Take the time you need with 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:
Receive a special gift from Fusion on your birthday.Growth & DevelopmentInvest in
Your Learning:
AccessCHF 1,500
annually for professional development.Grow Your Skills:
Join regular workshops and trainings to strengthen technical and soft skills.Advance Continuously:
Build the mindset, confidence, and capabilities to grow your career on your terms.Shape an
Inclusive Culture:
Thrive in a workplace where your individuality is valued, and your voice drives meaningful change.Recognition & RewardEarn What You're Worth:
Receive a competitive salary and benefits package that reflects your impact.Refer Talent:
Get rewarded for recommending new hires through our referral program.Stay Rewarded:
Access loyalty-based benefits starting from your third year via the Unity Scheme.Global Mobility & Local SupportRelocate with
Ease:
Receive financial assistance when moving for work.Navigate Global Moves:
Get help with visas, permits, and international assignments.Benefit Locally:
Enjoy perks tailored to your country of residence.Collaborate Globally:
Work in a diverse, inclusive culture where global teamwork drives success.OUR SELECTION PROCESS
Your time is valuable. That's why our hiring process is clear, efficient, and focused on mutual fit:Upload Your CV
- Submit your application using the relevant button, depending on the job platform (approx. 3 minutes).Wait for Profile Review
- Our Talent Acquisition team will assess your CV and experience (approx. 2 weeks).Join an Introductory Call
- Our Talent Acquisition team will arrange a brief conversation (15-30 minutes via Teams or phone) to tell you more about Fusion, the role, and understand your expectations.
- Participate in a 30-minute session with one of our experts to discuss your skills and experience in more detail.
- For some roles, you may be invited to a client-facing discussion (30-60 minutes online).Receive Final Feedback
- We aim to share timely feedback and move forward quickly.