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

📋 Description

• Participate in vendor scoping sessions to finalize table and field requirements.
• Model a dedicated datamart in the dbt layer from core order, line item, and customer data.
• Translate vendor schema into internal field mappings for DTC logic.
• Configure Snowflake data sharing and connections for vendor ingestion.
• Write dbt tests and documentation for delivered models.
• Manage the GitLab merge request workflow with peer reviews.

🎯 Requirements

• Proven ability to execute complex technical requirements independently.
• Strong SQL proficiency with data analysis across orders, customers, and attribution models.
• Expert dbt Core and dbt Cloud, building mart models and YAML.
• Proficient with Snowflake: schema design, testing, data sharing.
• Experience translating external vendor schemas to internal DTC data models.
• GitLab MR workflows; MMM and Airflow familiarity are pluses.

🎁 Benefits

• 100% Remote work from anywhere.
• Competitive USD salary.
• Paid time off for rest and recharge.
• Autonomy to manage time and deliver results.
• Work with top U.S. companies.