Data Analyst

Brandness

Data Analyst responsible for transforming business data into actionable insights. Collaborating with data engineers and maintaining Power BI dashboards for marketing and operations.

Posted 7/28/2026full-timeFlorianópolis • 🇧🇷 BrazilMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in advanced SQL, DBT, and Power BI for data modeling and analytics, ensuring data quality and actionable insights across e-commerce and retail domains. Proficient in translating complex business questions into data-driven recommendations while collaborating effectively with cross-functional teams.

Highest-signal resume keywords

Advanced SQL in BigQueryDBT Data ModelingPower BI ProficiencyE-Commerce Metrics ExpertisePython for Data Analysis

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

Advanced SQLDBTDimensional Data ModelingPower BIPythonDAXData ValidationData Quality AssuranceVersion Control with GitE-Commerce Metrics

Soft Skills

CollaborationAnalytical ThinkingCommunication

Tools & Technologies

BigQueryPower BIGitAirflowGA4

Industry Keywords

E-CommerceRetailDTCData CI/CDBusiness Intelligence

Tech Stack

Tools & technologies

AirflowBigQueryNumpyPandasPythonSQL

About the role

Key responsibilities & impact

Own the business data modeling in DBT (gold → platinum layers): build and maintain our One Big Tables, marts and seeds for definitions (payback, targets, classifications, acquisition/retention groups).
Design and maintain the semantic layer and dashboards in Power BI, ensuring performance, consistency and a single source of truth.
Lead end-to-end analytical projects: acquisition vs. retention, LTV/CAC/payback, repurchase journey, profitability by product and channel, returns, and inventory/purchasing planning.
Translate business questions (marketing, e-commerce, operations, sales) into data models and actionable analyses — and deliver recommendations, not just numbers.
Govern metrics and definitions: document, standardize and enforce consistency across brands and channels (DTC, marketplaces and B2B).
Ensure the quality and reliability of the data you model (dbt tests, validations, documentation).
Collaborate with the Data Engineer on evolving the gold layer and integrating new sources (logistics, CRM, new channels).

Requirements

What you’ll need

Advanced SQL in BigQuery: window functions, chained CTEs, QUALIFY, arrays/structs and UNNEST, timezone-aware dates, and cost/performance optimization (partitioning, clustering, bytes processed).
Solid hands-on experience with DBT: layered modeling (staging → marts/OBT), materializations (including incremental and snapshots), tests (generic and custom), seeds for business definitions, macros/Jinja, documentation and dbt build in CI. You will inherit and evolve our business layer.
Dimensional data modeling (fact/dimension, grain, SCDs) and denormalized BI modeling (One Big Table).
Proficiency in Power BI: star schema modeling, DAX (CALCULATE, FILTER, time intelligence, VAR), relationships and filter direction, and performance optimization — our official BI tool.
Python for analysis (pandas/numpy/notebooks) for exploration and ad-hoc analyses.
Version control with Git (branches, PRs, code review in the dbt repository) and familiarity with data CI/CD.
E-commerce metrics at your fingertips: cohorts, retention, LTV, CAC, payback, contribution margin, return rate.
Previous experience in e-commerce, retail or DTC, understanding the economic differences between direct sales and marketplaces.
GA4, paid media data (Meta/Google Ads) as sources, CRM/audience activation.
Basic knowledge of orchestration (Airflow) and the Modern Data Stack.

Benefits

Comp & perks

Product Voucher: Exclusive credit to redeem products from any of our brands.
Discount Coupon: Special, ongoing discounts across our three brands.
Birthday Day Off: One paid day off during your birthday month to celebrate as you wish.
Annual Bonus: Profit-sharing tied to the group's overall results (when the company wins, everyone shares the benefits).
Partnership with Conexa: 24/7 telemedicine services plus telepsychotherapy support.
Dental Plan: Comprehensive dental coverage through Uniodonto.
Partnership with GoGood: Agreements and discounts with a wide network of gyms and partner studios.
Partnership with Guapeco: Protection coverage for your four-legged friend.