Senior Data Modeler (Snowflake)
Role details
Job location
Tech stack
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., 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. Attend a Technical Interview - Participate in a 30-minute session with one of our experts to discuss your skills and experience in more detail. Participate in a Client Interview (if applicable) - 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. Fusion is an equal opportunity employer. We value diversity and are committed to fostering an inclusive workplace for all.
Requirements
- 4-7 years of experience as a Data Modeler or similar role.
- Proven expertise in Snowflake physical data modeling and SQL.
- Proven experience with Data Vault
- 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.
- Fluent in English
Preferred:
- Experience in pharmaceutical/life sciences data and regulatory frameworks.
- Familiarity with data quality tools such as Ataccama.
Benefits & conditions
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.