Senior Data Architect – Snowflake, Market Research

Job not on LinkedIn

🔥 0 minutes ago

🇨🇴 Colombia – 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 that transform 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 that correctly handle 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 reliable ingestion from Amazon S3 into Snowflake using Snowpipe, stages, storage integrations, COPY INTO, and schema evolution. • Partner with software engineers to define 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 and ability to independently solve complex modeling, performance, and data-correctness problems. • 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 working 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.

🏖️ Benefits

• 100% Remote Work: Enjoy the freedom to work from the location that helps you thrive. All it takes is a laptop and a reliable internet connection. • Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond typical market offerings. • Paid Time Off: We value your well-being. Our paid time off policies ensure you have the chance to unwind and recharge when needed. • Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done. Focus on results, not the clock. • Work with Top American Companies: Grow your expertise working on innovative, high-impact projects with Industry-Leading U.S. Companies. • A Culture That Values You: We prioritize well-being and work-life balance, offering engagement activities and fostering dynamic teams to ensure you thrive both personally and professionally. • Diverse, Global Network: Connect with over 600 professionals in 25+ countries, expand your network, and collaborate with a multicultural team from Latin America. • Team Up with Skilled Professionals: Join forces with senior talent. All of our team members are seasoned experts, ensuring you're working with the best in your field.