Senior Data Modeler (Snowflake)

Fusion Consulting

Where
Hybrid in New Haven, CT, United States

Posted 41 days ago· Checked live at Fusion Consulting 2 hours ago

Stale: open 41 daysUp for more than two weeks. It may already be filled.

See how you score for this job

One sentence and your resume. We score it against what Fusion Consulting asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on Fusion Consulting's own hiring page 2 hours ago.
What is the job?
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.
What does it pay?
The posting doesn't say.
Our verdict
Stale. Up for more than two weeks. It may already be filled.

What the job is

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.

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.

What we offer - fusion benefits

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