Senior Analytics Engineer – ETL/ELT focused

Truelogic Software

Independent contract Analytics Engineer designing critical data infrastructure for marketing mix modeling at a prominent online design marketplace in Colombia.

Posted 6/6/2026full-timeRemote • 🇨🇴 ColombiaSeniorWebsite

Tech Stack

Tools & technologies

AirflowCloudSQL

About the role

Key responsibilities & impact

Participate in vendor scoping sessions to finalize full table and field requirements before the build phase begins.
Model a dedicated datamart in the dbt transformations marts layer, sourcing data from core order, line item, and customer tables.
Translate vendor schema specifications into specific internal field mappings, accurately accounting for DTC-adjusted logic such as ship-to addresses, order dates, and customer grain.
Configure Snowflake data sharing and connections to facilitate seamless vendor ingestion.
Write comprehensive dbt tests and documentation for all delivered models to ensure long-term data quality and transparency.
Manage the full merge request workflow using GitLab, adhering to strict peer review processes before deployment.

Requirements

What you’ll need

Proven ability to execute complex technical requirements independently with minimal guidance.
Strong proficiency in SQL, with deep experience analyzing source tables across orders, customers, and attribution models.
Expert-level experience with dbt Core and dbt Cloud, including building mart models and writing MetricFlow-compatible YAML configurations.
Proficient with Snowflake, specifically regarding schema design, query testing, and data sharing setup.
Demonstrated background in Analytics Engineering, with an emphasis on translating external vendor schemas to internal DTC data models.
Experience with GitLab for branch management and merge request workflows.
Prior experience with marketing mix modeling (MMM) or incrementality vendor integrations is a major plus.
Familiarity with Airflow for pipeline orchestration context is preferred.

Benefits

Comp & perks

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.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdbt Coredbt CloudSnowflakeMetricFlowYAMLAnalytics Engineeringmarketing mix modelingincrementality vendor integrationsAirflow

Soft Skills

independent executionminimal guidanceattention to detaildata quality assurancetransparencypeer review adherence