FREE ACCESS
5,000–10,000 jobs/day
See all jobs on JobTailor
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Tech Stack
Tools & technologiesAirflowApacheCloudPythonSQL
About the role
Key responsibilities & impact- Build and maintain robust data models using dbt
- Develop fact tables, dimension tables and data marts aligned with business needs
- Serve as the bridge between business teams and data engineering
- Document developed models, including metric definitions, applied business rules, data glossary and lineage
- Implement and maintain orchestration pipelines on Databricks and Airflow
- Develop solutions in Python and SQL for data transformation, cleansing and aggregation
- Implement data quality tests in dbt models and analytical layers
- Set up monitoring and alerts for pipelines and data models
- Lead complex end-to-end modeling projects
- Apply appropriate partitioning, clustering and materialization strategies to ensure performance and cost efficiency in data processing
- Collaborate with product and business squads
Requirements
What you’ll need- Strong expertise in analytical data modeling: Star Schema, Snowflake and OBT (One Big Table)
- Solid knowledge of layered architectures such as the Medallion Architecture (Bronze, Silver, Gold)
- Ability to define and enforce data contracts between layers, ensuring consistency and predictability for consumers
- Experience with materialization strategies in dbt (tables, views, incremental models and snapshots)
- Knowledge of column-based partitioning by date or other high-cardinality keys to reduce data scanned by queries and optimize cost and performance on Databricks
- Familiarity with clustering techniques and Z-ordering in Databricks/Delta Lake to optimize reads on large tables
- Ability to identify and fix performance bottlenecks in SQL queries
- Ability to estimate and manage the cost impact of complex models on cloud processing
- Proficiency in dbt (dbt Core or dbt Cloud), including model development, tests, macros and documentation
- Experience with Databricks and Delta Lake
- Advanced SQL skills for building complex queries and analytical modeling
- Knowledge of Python for automation, data transformation and pipeline support scripts
- Experience orchestrating pipelines with Apache Airflow and Databricks
- Experience with code versioning using GitHub
- Critical thinking and autonomy to lead complex projects with multiple stakeholders
- Clear communication skills with non-technical business teams
Benefits
Comp & perks- Caju Card, offering flexible use of your benefits (Meal, Food, Mobility, Health, Home Office, Culture and Education)
- Health plan with no co-pay (Unimed, Sulamerica or Alice)
- Zenklub — online consultations with therapists and coaches to support your mental health
- Wellhub
- Language learning support through our partnership with Rosetta Stone
- Recharge day — an additional day off
- Conexa Saúde — online medical consultations
- Childcare assistance
- Partnership with Alura
- Remote work — work from anywhere within Brazil
- Work equipment provided
- Many growth opportunities — we have a lot to grow and we strongly hope you will help us do it!
ATS Keywords
✓ Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data modelingSQLPythondbtdata transformationdata cleansingdata aggregationanalytical modelingmaterialization strategiesperformance optimization
Soft Skills
critical thinkingautonomyclear communicationcollaborationleadership