Live opening · Posted 16 hours ago
At a glance
The key details from the original listing.
About the role
Description supplied by the original job listing.
Job Title: Sr Data Architect / Data Modeler (Snowflake)
Location: Dallas TX (or) Remote
$80/hr on C2C
Purpose: Own the Client data architecture and model so the MVP scales to new modules without a rebuild.
Responsibilities
Design the multi-tenant Snowflake topology: hybrid of database/schema-per-client and shared objects, with RBAC, row/column policies and secure views that isolate clients yet enable anonymised cross-client benchmarking.
Define the medallion model (bronze, silver, gold) and the governed semantic layer (semantic views for Cortex Analyst; KPIs and measures for dashboards).
Model the event domain: events, sessions, attendees, exhibitors, venues, engagement, sensor and registration data from Cvent, Bizzabo and others.
Design master data management and entity resolution across source systems (attendee, company, industry, role).
Set PII handling and anonymisation levels (participant, event, geo) aligned with client consent and data-retention terms.
Lay foundations for the post-MVP ontology and knowledge graph linking structured data with documents and reports.
Set standards, review pipelines and advise JM's Technical Architect on AWS–Snowflake integration and cost.
Must have
12+ years in data architecture; 4+ years designing on Snowflake in production.
Multi-tenant SaaS data design, Snowflake RBAC, masking and row-access policies, data sharing.
Dimensional and data-vault modelling; semantic layer design; dbt.
AWS data services (S3, Glue, Lambda, IAM).
PII and privacy-by-design (GDPR / UK GDPR, CCPA).
Snowflake Cortex (Analyst, Search), Snowflake Horizon governance.
Knowledge graphs / ontologies; MDM tooling.
Events, marketing or media-industry data.
SnowPro Advanced: Architect certification.
Please share your updated resume, rate and contact information.
Work arrangement
Yes
Your early-applicant advantage
Live timing from JobBeeper.
More openings worth a look
Recently tracked roles with full details and direct application links.