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 IC data architect (Snowflake/dbt)
Builds
Production data pipelines, core tables, and dimensional marts
Domain
Market research, advertising, media, commerce, technology, healthcare, financial services
Deliverable
production ML models
Required skills
Snowflake, dbt, SQL, dimensional modeling, identity resolution, AWS (S3, IAM, SNS, SQS), Parquet, Python code review
Preferred skills
Event-driven architecture, data contracts, columnar formats
Technologies
Snowflake, dbt, Amazon S3, Parquet, Python
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.
Seniority
Senior, hands-on IC (via careerplan.io/jobs/5130c105-9f12-4e63-949d-4777d927c885-senior-data-architect-snowflake-market-research-at-truelogic)
