Senior Analytics Engineer (ETL/ELT focused) - Design Marketplace | Colombia at Truelogic

📋 Description

• Participate in vendor scoping to finalize table/field requirements.
• Model a datamart in dbt layer, sourcing from orders, items, and customers.
• Map vendor schema to internal fields, including ship-to, dates, and customer grain.
• Configure Snowflake data sharing and connections for ingestion.
• Write dbt tests and docs for delivered models.
• Manage merge requests with GitLab and peer reviews.

🎯 Requirements

• Proven ability to execute complex technical requirements independently.
• Strong proficiency in SQL across orders, customers, and attribution models.
• Expertise with dbt Core and dbt Cloud for mart models.
• Proficient with Snowflake: schema design, query testing, data sharing.
• Experience translating vendor schemas to internal DTC data models.
• Experience with GitLab for MR workflows.
• Nice to have MMM or incrementality vendor integrations.
• Familiarity with Airflow for pipeline orchestration is preferred.

🎁 Benefits

• 100% remote work.
• Paid time off.
• Autonomy to manage your time.
• Collaborate with top U.S. companies.
• Global, diverse team across 25+ countries.