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

Analytics Engineer

We are seeking an independent contract Analytics Engineer for a scoped, time-bound engagement starting in Q3 2026. In this role, you will design and build the critical data infrastructure required to onboard a new marketing mix modeling (MMM) and incrementality testing vendor. The ideal candidate will take full ownership of translating the external vendor's B2C schema specification into a production-ready data mart, serving as the bridge between internal direct-to-consumer (DTC) data and external ingestion.

Responsibilities

• 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.

Qualifications and Job Requirements

• 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.

What We Offer

• 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.

Why You'll Like Working Here

• A Culture That Values You: We prioritize well-being and work-life balance, offering engagement activities and fostering dynamic teams to ensure you thrive both personally and professionally.

• Diverse, Global Network: Connect with over 600 professionals in 25+ countries, expand your network, and collaborate with a multicultural team from Latin America.

• Team Up with Skilled Professionals: Join forces with senior talent. All of our team members are seasoned experts, ensuring you're working with the best in your field.