Senior Analytics Engineer (ETL/ELT focused) - Design Marketplace
This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Senior Analytics Engineer (ETL/ELT focused) - Design Marketplace based in Brazil.
This role is a high-impact, project-based analytics engineering engagement focused on designing and delivering the foundational data infrastructure that enables advanced marketing analytics use cases. You will play a critical role in translating external vendor requirements into scalable, production-ready data models within a modern cloud data stack. The position sits at the intersection of data engineering, analytics, and marketing measurement, supporting the integration of a marketing mix modeling and incrementality testing vendor. You will work closely with both internal data stakeholders and external partners to ensure seamless data alignment, high-quality transformations, and robust analytics readiness. The environment is highly autonomous and technical, requiring strong ownership and the ability to independently drive complex implementations from specification to deployment. This is an opportunity to shape core data architecture supporting large-scale consumer insights and experimentation frameworks.
Accountabilities:
- Lead the end-to-end design and implementation of a dedicated analytics data mart within dbt, supporting external marketing mix modeling and incrementality vendor requirements.
- Translate external B2C schema specifications into robust internal data models, ensuring accurate mapping across orders, customers, and attribution-related datasets.
- Participate in vendor alignment sessions to define table structures, field requirements, and data logic before implementation begins.
- Build and maintain scalable transformations using dbt Core and dbt Cloud, including marts layer modeling and MetricFlow-compatible configurations.
- Develop comprehensive dbt tests, documentation, and data validation frameworks to ensure accuracy, transparency, and long-term maintainability.
- Configure and manage Snowflake data sharing and connectivity to enable secure and efficient vendor data ingestion.
- Collaborate within GitLab workflows, managing branch strategy, merge requests, and peer review processes for production deployments.
- Ensure DTC-specific logic is properly applied, including adjustments for customer, order, and shipment-level data interpretations.
- Support data quality, governance, and performance optimization across all delivered models.
- Strong experience in Analytics Engineering or Data Engineering roles, ideally within a modern cloud data stack environment.
- Advanced SQL expertise with the ability to independently explore, analyze, and transform complex datasets across multiple domains.
- Deep hands-on experience with dbt Core and dbt Cloud, including building modular data marts and MetricFlow-compatible YAML configurations.
- Strong proficiency with Snowflake, including schema design, query optimization, and data sharing setup.
- Proven ability to translate external vendor schemas into internal data models, particularly in B2C or DTC environments.
- Experience working with GitLab or similar version control systems, including branching strategies and merge request workflows.
- Strong analytical mindset with attention to data accuracy, validation, and reproducibility.
- Ability to work independently and deliver complex technical solutions with minimal supervision.
- Exposure to marketing mix modeling (MMM) or incrementality measurement integrations is a strong plus.
- Familiarity with workflow orchestration tools such as Airflow is preferred.
- Fully remote role with the flexibility to work from anywhere in Brazil.
- Competitive USD-based compensation aligned with international market standards.
- Paid time off to support rest, recovery, and work-life balance.
- High autonomy in managing workload and delivery timelines, with a focus on outcomes over hours worked.
- Opportunity to collaborate with leading U.S.-based companies on high-impact data and analytics projects.
- Exposure to a global network of experienced data and technology professionals across multiple countries.
- Collaborative, high-seniority environment that fosters learning, growth, and technical excellence.
- Strong culture of flexibility, well-being, and professional respect.
Requirements:
Benefits:
How Jobgether works: We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best! Why Apply Through Jobgether? Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time. #LI-CL1