Data Analyst

Jobtailor; Florianópolis; Presencial; BRL 180 000 - 240 000; Tempo integral

Resumo da oferta

Jobtailor is seeking a senior data analytics professional to own data modeling in DBT and design robust semantic layers in Power BI. You will lead end-to-end analytics projects spanning acquisition, retention, LTV/CAC/payback, and channel profitability for DTC and marketplace contexts.

You will translate business questions into scalable data models and provide actionable recommendations while ensuring data quality and consistency across brands.

Qualificações

• Experience designing and maintaining the semantic layer and dashboards in BI/analytics.
• Strong SQL in BigQuery with window functions, UNNEST, and performance tuning.
• Hands-on DBT experience: staging → marts/OBT, incremental, tests, seeds, macros, CI/CD builds.
• Proficiency in Power BI: star schema, DAX, relationships, performance optimization.
• Python for exploration and ad-hoc analyses (pandas/numpy).
• Version control with Git; data CI/CD familiarity.
• Experience with e-commerce metrics: cohorts, retention, LTV, CAC, payback, margins.
• Background in e-commerce, retail or DTC; knowledge of direct sales vs marketplaces.
• GA4 and paid media data sources; CRM/audience activation.
• Basic orchestration knowledge (Airflow) and Modern Data Stack.

Responsabilidades

• Own data modeling in DBT and manage gold/platinum layers and One Big Table definitions.
• Design and maintain semantic layer and dashboards in Power BI for a single source of truth.
• Lead end-to-end analytics projects: acquisition vs retention, LTV/CAC/payback, profitability by product/channel.
• Translate business questions into data models and actionable analyses with recommendations.
• Govern metrics: document, standardize and enforce consistency across brands and channels.
• Ensure data quality with dbt tests, validations, and documentation.
• Collaborate with Data Engineer to evolve the gold layer and integrate new sources.

Conhecimentos

Advanced SQL in BigQuery

DBT Data Modeling

Power BI Proficiency

Python for Data Analysis

Data Validation & QA

DAX

Git Version Control

Airflow basics

E-Commerce Metrics

Ferramentas

BigQuery

DBT

Power BI

Git

Airflow

GA4

Descrição da oferta de emprego

• 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

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

Core Competencies

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 BigQuery
• DBT Data Modeling
• Power BI Proficiency
• E-Commerce Metrics Expertise
• Python for Data Analysis

ATS Optimization Keywords

Hard Skills

• Advanced SQL
• DBT
• Dimensional Data Modeling
• Power BI
• Python
• DAX
• Data Validation
• Data Quality Assurance
• Version Control with Git
• E-Commerce Metrics

Soft Skills

• Collaboration
• Analytical Thinking
• Communication

Industry Keywords

• E-Commerce
• Retail
• DTC
• Data CI/CD
• Business Intelligence

Tools & Technologies

• BigQuery
• Power BI
• Git
• Airflow
• GA4