Senior Data Modeler (Snowflake) at Fusion Consulting
New Haven
—
Jul 13, 2026
New Haven
Jul 21, 2026
What this job asks for AI summary
A mid-level data modeling role focused on consolidating regional data warehouses into a centralized Snowflake platform for pharmaceutical clients. Day-to-day work involves designing and implementing physical data models, translating conceptual designs into Snowflake schemas, supporting ETL/ELT pipelines, and aligning data assets with governance standards via Collibra. Data Vault 2.0 experience is required; familiarity with tools like dbt, Matillion, or Fivetran is advantageous.
Mid level · 4+ years · Remote
“or” means any one of them counts — you don't need all of them.
We read this from the posting text with AI. Skim the description below before ruling yourself out.
How this req sits in the market our data
Roughly 7,400 people nationally plausibly meet what this posting asks for (database architects). range 2,150–11,100
Applicant volume Heavy — This req sits in a large pool with little in its requirements to thin it, and auto-apply tools fire at everything in the occupation. Applying early and leading with the rare skills below is what gets read.
Most people in this occupation already list these. Still required — just not what gets you shortlisted.
What the occupation pays Median $142,568 (middle half $111,775–$173,013).
Estimated from BLS employment for this occupation and area, per-skill prevalence across our listing corpus, and published wage benchmarks — as of Jul 28, 2026. It is a model, not a headcount.
Why we read it this way (11)
The role is posted by a Swiss-headquartered global consultancy (Fusion Consulting) with 25 offices worldwide and no specific country or city stated for this position. The posting is not US-based; US-based flag is set to false and no CBSA is assigned.
The posting explicitly frames this as a 'mid-level role', which aligns with the 4–7 years of experience requirement — both advertised and assessed seniority land at Mid.
Data Vault 2.0 is explicitly called out as 'a must' in the qualifications section, making it a hard gate despite appearing alongside other modeling practices.
Collibra is listed in the main qualifications block with the qualifier 'ideally', but it sits within the required qualifications section (not a separate Preferred/Nice-to-have block) and is framed as an expectation for the role. Treated as a hard gate; the qualifier signals a preference for Collibra specifically over other governance tools, not that governance platform experience is optional.
dbt, Matillion, and Fivetran are grouped as interchangeable examples under 'a plus' language in the qualifications section — treated as a single preferred skill with alternatives.
AWS S3 is explicitly flagged as 'a plus' and is treated as preferred.
Ataccama appears under the explicit 'Preferred' heading at the end of qualifications.
Pharmaceutical/life sciences domain experience is listed under 'Preferred' but names no specific technology or tool, so it is omitted from the skills list per extraction rules.
No compensation figures are provided in the posting.
This posting reads as a fully-remote role, so it was scored against the national candidate pool rather than a single metro.
This role's work location reads as outside the US — the candidate pool, comp, and contention benchmarks here are US-only (BLS employment, Adzuna/USAJOBS demand, and certified H-1B wages), so treat them as a rough US reference, not a local market.
Read the full posting
The employer publishes the full description on their own site — read it there ↗. Or sign in to read it here — it's free, and it also lets you track this application.