Senior Analytics Engineer – ETL/ELT focused

This is a fully remote position, open to applicants in Colombia.

📋 Description

• Engage in vendor scoping meetings to finalize complete table and field requirements prior to the commencement of the build phase.

• Develop a dedicated datamart within the dbt transformations marts layer, sourcing data from fundamental order, line item, and customer tables.

• Convert vendor schema specifications into precise internal field mappings, accurately reflecting DTC-adjusted logic such as ship-to addresses, order dates, and customer grain.

• Set up Snowflake data sharing and connections to enable smooth vendor data ingestion.

• Create thorough dbt tests and documentation for all models delivered to ensure long-term data integrity and transparency.

• Oversee the entire merge request process using GitLab, following stringent peer review protocols before deployment.

⛳️ Requirements

• Demonstrated capability to fulfill complex technical requirements autonomously with minimal supervision.

• Strong command of SQL, with extensive experience in analyzing source tables related to orders, customers, and attribution models.

• Advanced proficiency with dbt Core and dbt Cloud, including the development of mart models and creation of MetricFlow-compatible YAML configurations.

• Skilled in Snowflake, particularly in schema design, query testing, and data sharing configuration.

• Proven experience in Analytics Engineering, with a focus on translating external vendor schemas into internal DTC data models.

• Familiarity with GitLab for managing branches and merge request processes.

• Previous experience with marketing mix modeling (MMM) or incrementality vendor integrations is highly desirable.

• Knowledge of Airflow for pipeline orchestration is preferred.

🏝️ Benefits

• 100% Remote Work: Enjoy the flexibility to work from wherever you thrive, with just a laptop and a stable internet connection.

• Highly Competitive USD Pay: Receive an outstanding, market-leading salary in USD that surpasses typical market rates.

• Paid Time Off: We prioritize your well-being. Our paid time off policies ensure you can relax and recharge as needed.

• Work with Autonomy: Experience the freedom to manage your schedule as long as the work is completed, focusing on outcomes rather than hours.

• Collaborate with Top American Companies: Enhance your skills by working on innovative, high-impact projects with industry-leading U.S. firms.