Senior Data Modeler (Snowflake)

Fusion Consulting AG; New Haven, Northern (CT, KY); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Remote work flexibility

25 remote days per year

Flexible time off

Integration budget

Birthday gift

Global mobility support

Job summary

Fusion Consulting AG seeks a mid-level Data Modeler (Snowflake) to support regional warehouse integration into a centralized Snowflake-based platform for the pharma sector. Strong Snowflake modeling skills and governance collaboration are required to deliver scalable, compliant data solutions.

You will design Snowflake schemas, optimize ETL/ELT processes with data engineers, and ensure governance alignment across teams in a distributed global environment.

Qualifications

• 4-7 years of experience as a Data Modeler or similar role.
• Strong Snowflake data modeling and SQL expertise.
• Experience with governance, Collibra, and metadata management.
• Proven collaboration with business users, product owners, and tech teams.
• Knowledge of ETL/ELT concepts; familiarity with dbt, Matillion or Fivetran is a plus.
• Data Vault 2.0 and data modeling methodologies (Star schema, normalization).
• Ability to document models and explain technical concepts to stakeholders.

Responsibilities

• Design and implement physical data models in Snowflake for scalable, high-performance warehouses.
• Translate conceptual/logical models into Snowflake 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 modeling and transformation logic is well-documented for traceability and compliance.
• Support performance tuning and optimization of data pipelines.

Skills

Snowflake modeling

SQL

Data Vault 2.0

Collibra governance

DBT

Tools

Matillion

Fivetran

dbt

AWS S3

Job description

We 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.

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 BENEFITS

We’ve designed our benefits to support your growth, well-being, and global mobility.

Flexibility & Balance

• Work from 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 & Development

• Invest in Your Learning: Access CHF 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 & Reward

• Earn 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 Support

• Relocate 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.

Your time is valuable. That’s why our hiring process is clear, efficient, and focused on mutual fit:

Fusion is an equal opportunity employer. We value diversity and are committed to fostering an inclusive workplace for all.

Qualifications

Requirements

• 4-7 years of experience as a Data Modeler or similar role.
• Strong expertise in Snowflake data modeling and SQL.
• Strong business partnering, communication, and stakeholder management skills, with the ability to gather, challenge, and translate business requirements into scalable data solutions.
• Proven experience working directly with business users, product owners, and technical teams to define data requirements, business rules, and data models.
• Strong understanding of ETL/ELT and data integration concepts; experience with dbt, Matillion, or Fivetran is a plus.
• Data Vault 2.0 experience is required.
• Experience with metadata and data governance platforms, ideally Collibra.
• Familiarity with AWS S3 is a plus.
• Solid understanding of data modeling methodologies, including Data Vault, Star Schema, and Normalization.
• Excellent communication, presentation, and documentation skills, with the ability to explain technical concepts to non-technical stakeholders.
• Ability to work independently in a remote, cross-functional environment.

Preferred

• Experience within pharmaceutical or life sciences organizations.
• Familiarity with data quality tools such as Ataccama.
• Experience working in Agile environments and facilitating requirements-gathering workshops.

Empowering authenticity, encouraging collaboration, inspiring growth.