Senior Data Modeler - Snowflake

Company Description

Swiss 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 Description

We are seeking an experienced Data Modeler to join our client's data transformation journey. The organization is currently transitioning from multiple legacy systems to a centralized data repository based on Snowflake, with a comprehensive data catalog maintained in Collibra. The ideal candidate will play a key role in designing, developing, and maintaining data models that facilitate seamless data integration, accessibility, and governance within this modernized infrastructure.

Key Responsibilities:

• Design and develop scalable and efficient data models to support the transition to Snowflake.

• Collaborate with data architects, data engineers, and business stakeholders to understand data requirements and translate them into optimal data structures.

• Ensure that data models align with organizational data governance policies and Collibra catalog standards.

• Analyze legacy systems and define data migration strategies to ensure data integrity and consistency.

• Maintain documentation of data models, definitions, relationships, and metadata within Collibra.

• Optimize data models for performance and scalability within Snowflake.

• Participate in data quality assessments and contribute to establishing best practices for data management.

• Provide expertise in resolving data-related issues and recommend improvements.

• Work closely with cross-functional teams to ensure that data models meet business objectives and compliance requirements.

Qualifications

Required Qualifications:

• Relevant professional experience in data modeling, data architecture, or related fields. Formal education in Computer Science, Information Systems, Data Science.

• Proven experience in data modeling, particularly within Snowflake environments.

• Strong understanding of data warehousing concepts, dimensional modeling, and relational databases.

• Experience with Collibra or similar data catalog tools.

• Proficiency in SQL and data modeling tools (e.g., ER/Studio, ERwin, or similar).

• Familiarity with data governance principles and best practices.

• Excellent analytical, problem-solving, and communication skills.

• Ability to work independently and collaboratively within cross-functional teams.

• Proven experience with IHM Infosphere

Preferred Qualifications:

• Experience in data migration from legacy systems to modern data platforms.

• Understanding of data privacy regulations and compliance standards.

• Experience with Agile methodologies and working in dynamic, fast-paced environments.

• Familiarity with data integration tools and ETL processes.

Additional Information

Why Fusion? 

At Fusion, we unite entrepreneurial minds from around the globe to develop and implement game-changing solutions that build lasting relationships with our clients.

We value employees who challenge the status quo through innovation, adapt to diverse client needs in ever-changing environments, and commit to continuous learning—for themselves and their colleagues.

We provide a competitive salary and benefits package, along with an outstanding work environment that fosters long-term career development opportunities.

Our Benefits:

• Workflex: Enjoy 25 days of flexibility to work from your preferred global location.
• Flexible Time Off: Take the time you need to recharge and maintain a healthy work-life balance, with flexibility beyond standard holiday allowances.
• Annual Training Budget: Access CHF 1,500 to invest in your professional development and skill enhancement.
• Continuous Learning: Thrive in an environment that encourages ongoing learning, with opportunities to develop new skills and broaden your expertise.
• Global Mobility Support: Gain assistance with international assignments, visa/permit support, and relocation services.
• Unity Scheme: Benefit from loyalty rewards starting after 3 years of service.
• Referral Program: Earn a referral fee for every successfully hired referee.
• Local Benefits: Access a range of country-specific benefits tailored to your location.
• People Focus: Unite with the best global talent in life sciences, empowered to grow and collaborate in a vibrant environment.
• Truly Global: Join a truly global organization where mutual support, teamwork, and diversity drive our collective success.