Senior Data Modeler (Snowflake)

About the role

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.

Responsibilities

• 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 Data Vault 2.0 is a must.
• 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.

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.

What We Offer

• Flexibility & Balance: Work from Anywhere, Recharge Freely, Connect as a Team, Celebrate Your Birthday.
• Growth & Development: Invest in Your Learning, Grow Your Skills, Advance Continuously.
• Recognition & Reward: Earn What You’re Worth, Refer Talent, Stay Rewarded.
• Global Mobility & Local Support: Relocate with Ease, Navigate Global Moves, Benefit Locally, Collaborate Globally.