Senior Data Architect – Snowflake, Market Research

Job not on LinkedIn

🔥 0 minutes ago

🇲🇽 Mexico – Remote

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 25%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Truelogic Software

WebsiteLinkedInAll Job Openings

501 - 1000 employees

Founded 2004

☁️ SaaS

🤝 B2B

🏢 Enterprise

SaaS • B2B • Enterprise

Truelogic Software is a nearshore software development company specializing in agile staff augmentation services. They focus on providing custom outsourced software development with a team of highly skilled engineers from Latin America. Truelogic Software partners with both startups and Fortune 500 companies, offering solutions that align with their clients' time zones and ensuring high-quality outcomes through collaboration and responsiveness. With a presence in over 25 countries, Truelogic emphasizes remote work for better quality of life, and their engineers are experienced in various industries, delivering a wide range of successful projects globally.

📋 Description

• Design and build scalable core tables transforming raw event data into reliable, well-structured datasets • Engineer incremental dbt models for billion-row tables using merge strategies, clustering, deduplication, microbatch processing, and idempotent reprocessing • Implement identity-resolution solutions handling merged identities, late-arriving data, and duplicate events • Design fact and dimension marts and define approved datasets for BI developers, analysts, and data scientists • Solve complex SQL challenges involving performance, correctness, window functions, and semi-structured data • Design ingestion from Amazon S3 into Snowflake using Snowpipe, stages, storage integrations, COPY INTO, and schema evolution • Partner with software engineers on event-driven delivery patterns, schemas, data contracts, and columnar formats such as Parquet • Administer Snowflake environments, including role-based access control, security policies, integrations, and warehouse configuration • Monitor pipeline stability, load failures, data freshness, late-arriving events, and duplicate files • Optimize Snowflake and dbt performance and cost through clustering, materialization strategies, warehouse sizing, query profiling, and scheduling • Establish data-modeling and dbt standards and review complex SQL, dbt, and Python code • Produce design documentation, evaluate architectural trade-offs, and coach engineers and analysts

🎯 Requirements

• 6+ years of experience in Data Engineering, Data Architecture, or Analytics Engineering • 3+ years of hands-on experience building production solutions with Snowflake • Expert-level SQL skills • Advanced data-modeling experience, including dimensional modeling, fact and dimension marts, slowly changing dimensions, conformed dimensions, and semi-structured data • Advanced dbt experience with incremental strategies, snapshots, macros, testing, and billion-row datasets • Experience with behavioral or event data, including sessionization, identity resolution, late-arriving events, and duplicates • Deep Snowflake expertise covering RBAC, Snowpipe, stages, storage integrations, COPY INTO, schema inference, tasks, streams, clustering, and cost management • Working knowledge of AWS services, including S3, IAM, SNS, and SQS • Experience designing event-driven data integrations and working with formats such as Parquet • Ability to read and review Python code • Proven ability to take complex data problems from diagnosis through production with minimal direction • Strong written and verbal English communication skills • Ability to explain architectural decisions and technical trade-offs to engineers and business leaders • Candidates must be currently based in Latin America

🏖️ Benefits

• 100% Remote Work • Highly Competitive USD Pay • Paid Time Off • Work with Autonomy • Work with Top American Companies • Engagement activities • Work-life balance • Collaboration with a diverse, multicultural global network • Opportunity to work with senior talent and seasoned experts