Skip to content

Open nowPosted 12 hours ago

Senior Data Modeler (Snowflake)

Fusion Consulting2 open roles

Where
New Haven, CT, United States
Work mode
Hybrid
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowSenior Data Modeler (Snowflake)Fusion Consulting · New Haven, CT, United States
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Fusion Consulting's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

8.0% of postings close within 7 days. Measured by our own scanner across the market. Fusion Consulting postings stay open a median of 6 days.

Share of postings closed within
  1. 1.6%1 day
  2. 3.6%3 days
  3. 8.0%7 days
  4. 15.0%14 days
  5. 34.2%30 days
This job: posted 12 hours ago

Fusion Consulting median: 6 days open

The posting

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

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.

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.

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.

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.

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Fusion Consulting's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on Fusion Consulting's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    Fusion Consulting's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.