Logo for True Logic Solutions

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

Key Facts

Remote From: 
Full time
Senior (5-10 years)
English

Other Skills

  • β€’
    Problem Solving
  • β€’
    Collaboration

Roles & Responsibilities

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

Requirements:

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

Job description

About Truelogic

At Truelogic we are a leading provider of nearshore staff augmentation services headquartered in New York. For over two decades, we’ve been delivering top-tier technology solutions to companies of all sizes, from innovative startups to industry leaders, helping them achieve their digital transformation goals.

Our team of 600+ highly skilled tech professionals, based in Latin America, drives digital disruption by partnering with U.S. companies on their most impactful projects. Whether collaborating with Fortune 500 giants or scaling startups, we deliver results that make a difference.

By applying for this position, you’re taking the first step in joining a dynamic team that values your expertise and aspirations. We aim to align your skills with opportunities that foster exceptional career growth and success while contributing to transformative projects that shape the future.

Our Client

Prominent online design marketplace and lifestyle brand that crowdsources graphic design and artwork from a global community of independent artists. They scale unique art, stationery, and home decor products to a massive consumer market, utilizing a modern, cloud-based data stack.


Job Summary

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.

Apply now!

Related jobs

Other jobs at True Logic Solutions

We help you get seen. Not ignored.

We help you get seen faster β€” by the right people.

πŸš€

Auto-Apply

We apply for you β€” automatically and instantly.

Save time, skip forms, and stay on top of every opportunity. Because you can't get seen if you're not in the race.

✨

AI Match Feedback

Know your real match before you apply.

Get a detailed AI assessment of your profile against each job posting. Because getting seen starts with passing the filters.

Upgrade to Premium. Apply smarter and get noticed.

Upgrade to Premium

Join thousands of professionals who got noticed and hired faster.