Analytics Engineer

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

📋 Description

• Conduct business and data analysis to facilitate internal projects and respond to client-driven requests.

• Examine and evaluate data issues and bugs, uncover root causes, and collaborate with relevant teams to achieve resolutions.

• Actively detect data quality issues, inconsistencies, and potential challenges across data models and services.

• Maintain the quality, accuracy, and dependability of data services and deliverables through ongoing validation and monitoring.

• Review and ensure the maintenance of clear, precise, and current documentation for data models, business rules, metrics, processes, and services.

• Validate business rules, KPIs, and data transformations against business requirements and anticipated behavior.

• Contribute to data governance and standardization, including consistent definitions, structures, naming conventions, and data quality standards.

• Work in collaboration with the Data Modeling & Governance Team and cross-functional teams throughout the organization.

⛳️ Requirements

• Proficient in SQL, including complex queries, CTEs, window functions, aggregations, joins, and data validation.

• Strong grasp of data modeling concepts, data structures, and principles of data quality.

• Experience utilizing Claude or similar AI tools to assist with data analysis, SQL development, documentation, and daily workflows.

• Proficient in Excel, including formulas, data analysis, lookups, pivot tables, and data validation.

• Basic understanding of Databricks, including notebooks, tables, catalogs, and executing SQL queries.

• Excellent problem-solving abilities to investigate data issues, identify root causes, and recommend effective solutions.

• Strong analytical and critical-thinking skills to assess data, identify inconsistencies, and draw well-supported conclusions.

• High attention to detail when ensuring data accuracy, consistency, and validation.

• Familiarity with e-commerce data and KPIs such as Sales, Revenue, Orders, Conversion Rate, ROAS, ACOS, TACOS, CPC, and other commerce and advertising metrics.

• Experience with data from e-commerce and advertising platforms like Amazon, Walmart, Shopify, Google Ads, Meta, or similar platforms.

• Understanding of data governance, data quality monitoring, documentation, and standardization practices.

• Experience handling large and complex datasets.

• Proven experience collaborating with Analytics, Engineering, Product, or other cross-functional teams.

🏝️ Benefits

• Equal opportunity employer dedicated to diversity, inclusion, and belonging.

• PJ contract employment arrangement.