Senior Data Architect (Snowflake)- Market Research
Truelogic · Remote · Bogota ·
COMPENSATION
€•• – ••k
Listed on the employer's job board (Ashby)
- Senior Data Architect
- Fully remote
- Snowflake + dbt
- Market Research domain
- USD compensation
You will own the architecture, modeling, and ingestion processes for a high-volume data platform. Working with a market research firm, you will turn raw S3 files and event streams into structured core tables and dimensional marts that support business intelligence and advanced analytics.
What you'll do
- Design scalable core tables from raw event data into structured datasets
- Engineer incremental dbt models for billion-row tables using merge strategies
- Implement identity-resolution solutions for merged identities and duplicates
- Define fact and dimension marts for BI developers and data scientists
- Solve complex SQL challenges involving performance and semi-structured data
- Administer Snowflake environments including security policies and access control
- Optimize pipeline performance and costs through clustering and warehouse sizing
- Establish data-modeling standards and review SQL, dbt, and Python code
What you'll need
- 6+ years in Data Engineering, Architecture, or Analytics Engineering
- 3+ years building production solutions with Snowflake
- Expert-level SQL skills for complex modeling and performance tuning
- Advanced experience with dimensional modeling and slowly changing dimensions
- Proficiency in dbt with incremental strategies and large datasets
- Experience handling behavioral data, sessionization, and late-arriving events
- Deep knowledge of Snowpipe, stages, storage integrations, and cost management
- Working knowledge of AWS services such as S3, IAM, SNS, and SQS
- Ability to read and review Python code
- Strong written and verbal English communication skills
Stack
- Snowflake
- dbt
- SQL
- Python
- AWS S3
- Parquet
How you'll work
- 100% remote work policy
- Flexible hours with focus on results
- Requires laptop and reliable internet connection
What you get
- Competitive USD compensation
- Paid time off policies
- Work with top American companies
- Access to a global network of professionals