Truelogic
Senior Data Architect (Snowflake)- Market Research
Remote role where the employee must remain based in a particular country.
Listed for Colombia
Source: the job board's country tag. The advert itself does not name Colombia.
Where you can work from is uncertain. The listing names Colombia, but the advert says Remote" Job description states: "based in Latin America
. We have not counted this role as confirmed for any country. Check with the employer before you apply.
Employer listed it 6 weeks ago 路 Added 6 weeks ago
Listed for 12 days before it closed.
This job has closed
Truelogic has taken this listing down, so it is no longer accepting applications. The details below are kept for reference only.
Browse open rolesSalary
Not stated
Location
Listed for Colombia
Timezone
Not stated
Contract
Full-time
Experience
Senior
Category
Data
The employer did not publish a salary, and we have too few comparable roles to estimate one.
What the advert says
Quoted word for word from the employer's advert. Where it says nothing, we say so.
- Working hours
- Not mentioned in the advert
- Where you can work from
Our team of 600+ highly skilled tech professionals, based in Latin America, drives digital disruption by partnering with U.S.
- Contract
- Not mentioned in the advert
- Experience asked for
6+ years of experience in Data Engineering, Data Architecture, or Analytics Engineering.
- Pay
Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond typical market offerings.
Remote flexibility
Work from home
This is a remote role, but the employee must be based in Colombia. It is work from home rather than work from anywhere.
What the employer says
- Source listing states candidate location: "Bogota, Remote"
- Job description states: "based in Latin America"
What Nomaders makes of it
- Payroll and tax are likely handled in that country only
The quotes above are the employer's own words; the reading is ours. Always check the original listing and employment terms before working from another country.
Before you apply
Questions worth asking: Nomaders interpretation
- The advert does not say whether this is employment or a contractor arrangement. Ask, as it affects tax and benefits.
Produced automatically from this advert's text; not reviewed by a person. The employer's own page is the final word.
About the role
About Truelogic
At Truelogic we are a leading provider of nearshore staff augmentation services headquartered in New York. For over two decades, we鈥檝e been delivering top-tier technology solutions to companies of all sizes, from innovative startups to industry leaders, helping them achieve their digital transformation goals.
Our team of 600+ highly skilled tech professionals, based in Latin America, drives digital disruption by partnering with U.S. companies on their most impactful projects. Whether collaborating with Fortune 500 giants or scaling startups, we deliver results that make a difference.
By applying for this position, you鈥檙e taking the first step in joining a dynamic team that values your expertise and aspirations. We aim to align your skills with opportunities that foster exceptional career growth and success while contributing to transformative projects that shape the future.
Our Client
This market research company provides trusted data, forecasts, benchmarks, and expert analysis across advertising, media, commerce, technology, healthcare, and financial services. It combines proprietary research with thousands of vetted sources to help organizations understand consumer behavior, anticipate market trends, validate strategies, and make faster, more confident and informed business decisions.
Job Summary
We are seeking a Senior Data Architect to own the design, modeling, ingestion, and optimization of a large-scale Snowflake and dbt platform. This hands-on role transforms raw S3 files and event data into reliable core tables and dimensional marts supporting analytics and data science. The ideal candidate will solve complex SQL problems, engineer billion-row incremental models, administer Snowflake, establish modeling standards, and partner with software engineers while optimizing data correctness, performance, security, governance, and cost across production environments at scale.
Responsibilities
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.
Qualifications and Job Requirements
6+ years of experience in Data Engineering, Data Architecture, or Analytics Engineering.
3+ years of hands-on experience building production solutions with Snowflake.
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.
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.
Applying
This listing has closed, so there is no application link. The details above are kept for reference only.
Found 1mo ago. Last checked 23 Oct. Always confirm the details on the original posting, salary and location can change after publication.
Listing sourced from Company boards.
This role is closed, applications are no longer accepted.