Senior Data Architect (Snowflake)- Market Research
Core
Design, model, and optimize a large-scale Snowflake and dbt platform to transform raw S3 event data into reliable core tables and dimensional marts for analytics and data science.
Role type
Senior hands-on IC Data Architect (Snowflake)
Builds
Production data pipelines, core tables, and dimensional marts for a market research client
Domain
Data Engineering / Analytics Engineering
Deliverable
production ML models
Required skills
Snowflake, dbt, SQL, dimensional modeling, event data processing, identity resolution, AWS (S3, IAM, SNS, SQS), Python code review
Preferred skills
None stated
Technologies
Snowflake, dbt, Amazon S3, Parquet
Responsibilities
Design scalable core tables from raw event data; Engineer incremental dbt models for billion-row tables; Implement identity-resolution solutions; Design fact and dimension marts; Solve complex SQL challenges; Design reliable ingestion from S3 to Snowflake; Partner with software engineers on event-driven patterns; Administer Snowflake environments; Monitor pipeline stability; Optimize performance and cost; Establish modeling standards and review code; Produce design documentation.
Seniority
Senior, hands-on IC (via careerplan.io/jobs/fc81f4b4-fb0e-4ee7-853d-76736d8b4bb8-senior-data-architect-snowflake-market-research-at-truelogic)
