
Senior Analytics Engineer – Data
Dasa
full-time
Posted on:
Location Type: Hybrid
Location: São Paulo • Brazil
Visit company websiteExplore more
Job Level
About the role
- Advanced Data Modeling: Build and maintain complex data models in BigQuery and Snowflake, applying dimensional modeling techniques and performance optimization.
- Development with Dataform/dbt: Develop data transformation pipelines using Dataform (preferred) or dbt, ensuring modularity and code reuse.
- Quality and Testing: Implement automated data tests and ensure rigorous technical documentation for each table and business rule developed.
- Automation and CI/CD: Operate and evolve deployment pipelines, ensuring production changes are safe and validated via Git.
- Code Review and Support: Perform peer code reviews and support mid-level and junior analysts with day-to-day technical challenges.
Requirements
- SQL Expert: Absolute mastery of SQL for complex transformations, window functions, and cost/performance optimization.
- Experience with Dataform or dbt: Strong hands-on experience with at least one of these transformation frameworks.
- Cloud Data Warehousing: Proven experience with BigQuery (partitioning, clustering) and/or Snowflake.
- Engineering Culture: Proficiency with Git (version control), basic CI/CD practices, and data governance concepts.
- Problem-Solving Profile: Ability to take a complex business problem and translate it into an efficient table architecture.
- Desired:
- Python: Knowledge for task automation and API integration.
- Cloud Run / Docker: Familiarity with infrastructure concepts for orchestrating data processes.
- Data Architecture: Knowledge of different methodologies (Star Schema, Data Vault, or OBT).
Benefits
- Food support: Meal Voucher / Food Voucher.
- Health care: Health plan and life insurance.
- Development support: Dasa University, Development and Career Cycle, Technology Academies/PMAX, and the Crescer program within Dasa.
- Other: Performance bonus (PPR).
- Only Dasa has — Health Program based on 5 pillars:
- Physical: TotalPass, primary care clinic, discounts on exams and vaccines.
- Intellectual: Dasa University.
- Relational: UAU benefits club and SESC benefits.
- Emotional: Telepsychology.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLDataformdbtBigQuerySnowflakePythonCI/CDData Architecturedimensional modelingperformance optimization
Soft Skills
problem-solvingpeer code reviewtechnical documentationsupporting analysts