Engenheiro de Dados SR (Analytics Engineer)
UOL EdTech · São Paulo, São Paulo, Brazil
- On site
- Full-time
- R$150,000 / year
- São Paulo, São Paulo, Brazil
Job highlights
- Design high-performance data models in BigQuery.
- Develop data transformation pipelines with dbt.
- Ensure data quality with contracts and tests.
- Support AI team with reliable datasets.
- Hybrid role in São Paulo, Brazil.
About the role
About UOL EdTech
We are looking for people passionate about education and technology! We want you to be able to work in an environment that demands the union of multiple skills and experiences, with a focus on results to leave our legacy in the world. If you, like us, have a passion for education and technology, UOL EdTech is for you! 🧡 Check out this opportunity and come be #EdTecher!
Responsibilities and Attributes
Design and maintain high-performance analytical models in the Data Warehouse (BigQuery), applying dimensional techniques (Star Schema/Kimball). Act as a protagonist in the critical transition between the Silver layer (integrated data) and the Gold layer (data products ready for business). Develop and evolve transformation pipelines using dbt (data build tool), ensuring modular, versioned, and reusable code. Implement Data Contracts and automated tests to ensure no dashboard breaks due to unexpected source changes. Monitor data health (Freshness, Volume, Schema) and act proactively in resolving anomalies. Support the AI team by providing clean and reliable datasets for model training and experiments. Document models and metrics to empower business users, ensuring everyone speaks the same language (Single Source of Truth).
Requirements and Qualifications
- Solid experience as an Analytics Engineer, Data Engineer, or Business Intelligence.
- Mastery of Advanced SQL - Ability to write performant and complex queries.
- Experience with dbt - Experience with macros, incremental models, and technical documentation.
- Experience with Cloud Data Warehouse - Experience with BigQuery (preferably) or AWS solutions.
- Experience with Data Architecture - Knowledge in dimensional modeling and Medallion architecture.
- Experience with BI Tools - Familiarity with Looker, Power BI.
- Experience with Version Control - Mastery of Git and Pull Request/CI-CD processes.
Additional Information
To stand out in this position, it would be great if you also had:
- Engineering Mindset - Passion for automation, code quality, and documentation.
- Knowledge of Python for automations and data scripts.
- Experience with observability tools (e.g., Elementary, Monte Carlo, or Soda).
- Experience with dbt Mesh or managing multiple data projects at scale.
- Knowledge of DataOps and governance practices (LGPD).
- Availability for a hybrid model (3x per week) in São Paulo - SP.
About Us
WE ARE GOING TO TRANSFORM LIVES WITH EDUCATION THROUGH TECHNOLOGY? We are a company that transforms lives with education through technology, offering a complete ecosystem with solutions for students, educational institutions, and companies. We work hard to offer the best digital learning experience, contributing to removing obstacles, expanding access to quality education, and leaving our legacy in the world. UOL EdTech is part of Grupo UOL, a 100% Brazilian company that has revolutionized the digital universe since 1996, and from this legacy, we carry credibility, pioneering spirit, and innovation in our DNA. Discover our ecosystem 🌐 We offer a complete ecosystem for education that transforms lives! Our business verticals are: For Students: we offer the largest online study platform, daily facilitating access to knowledge, empowerment, and transforming people's futures. In Brazil, we use the brand Passei Direto, and in the rest of the world, the brand Studenta. For Companies: we have two fronts of operation, with Learning.Rocks, we offer a complete solution to meet companies' training needs, combining technology and multi-format content. With Qulture.Rocks, we support companies in unlocking their teams' potential with a people and performance management platform. For Educational Institutions: we are the technological partner of large universities in offering 100% online specialization courses, attracting students in Brazil and worldwide. We are passionate about education and technology 😍 Technology is our fuel, and we are always looking for disruptive and technological solutions that help us break down barriers to bring our educational solutions to every corner of the world! The collective is stronger than the individual 🤝 We are always seeking the best results, even if we have to change course. We are on a long-term journey, creating a perennial and high-impact business. We are #EdTechers, and this is our way of being and doing! Our differences add up to make our purpose worthwhile 🧡 We believe in the diversity and plurality of people to achieve incredible results! Therefore, we do not discriminate based on disability, gender, sexual/affective orientation, race/ethnicity, age, origin, family structure, and appearance. Discover the benefits of being #EdTecher 🤩 You will have a complete benefits package that makes all the difference: Meal and/or food voucher. Health and dental plan. Life insurance. Partnership with TotalPass and ZenKlub. Extended maternity and paternity leave. Childcare assistance. Discounts of up to 50% on postgraduate and MBA programs from major institutions, such as FIA, FAAP, and PUCRS. And there's more, take a look: Dress code: what matters is what makes you feel good. #YoureAwesome: Day off on your birthday. Baby gift: gift for newborns. Learn how our selection process works 🔎 Not all processes follow the same format. However, the vast majority follow a similar flow: Application (the one you complete here on Gupy). Interview with the Recruitment & Selection team. Technical challenge, which may be a test, case study, or portfolio presentation. Or even a technical chat with the team. Interview with area leadership. We have an important tip for you 📣 Excel in the process stages, especially during the application! We analyze all applications, and this can take some time. Therefore, if you're wondering about the deadline for us to contact you, we ask for your empathy. 🧡 All candidates who apply for our positions receive feedback via Gupy, whether positive or negative. We ask you to follow your application here and in your email inbox, without forgetting to check spam, okay? So, shall we transform lives with education through technology? Come be #EdTecher!
Key skills/competency
Senior Analytics Engineer
- Data Modeling
- SQL
- dbt
- BigQuery
- Data Warehouse
- Data Pipelines
- ETL/ELT
- Business Intelligence
- Data Governance
- Data Quality
Skills & topics
- Analytics Engineer
- Data Engineer
- Business Intelligence
- Data Modeling
- SQL
- dbt
- BigQuery
- Data Warehouse
- Data Pipelines
- Data Architecture
How to get hired
- Customize your resume: Highlight your experience with SQL, dbt, BigQuery, and dimensional modeling, aligning keywords with the job description.
- Showcase your impact: Quantify your achievements in designing analytical models, developing data pipelines, and ensuring data quality.
- Prepare for technical interviews: Brush up on advanced SQL, dbt concepts, data warehousing principles, and data architecture patterns.
- Demonstrate passion for education: Articulate why you are drawn to UOL EdTech's mission and how your skills can contribute.
- Understand hybrid work: Be ready to discuss your experience and expectations regarding a hybrid work model.
Technical preparation
Behavioral questions
Frequently asked questions
- What are the key responsibilities for a Senior Analytics Engineer at UOL EdTech?
- As a Senior Analytics Engineer at UOL EdTech, you'll be responsible for designing and maintaining high-performance analytical models in BigQuery using dimensional techniques, developing transformation pipelines with dbt, implementing data contracts and automated tests, monitoring data health, and supporting the AI team with clean datasets. You'll also document models and metrics to create a Single Source of Truth for business users.
- What technical skills are essential for this Senior Analytics Engineer role at UOL EdTech?
- Essential technical skills include solid experience as an Analytics Engineer, Data Engineer, or BI professional, mastery of Advanced SQL for complex queries, and hands-on experience with dbt (macros, incremental models, documentation). You should also have experience with Cloud Data Warehouses like BigQuery or AWS solutions, knowledge of dimensional modeling and Medallion architecture, familiarity with BI tools (Looker, Power BI), and proficiency in Git for version control and CI/CD.
- What is the work arrangement for the Senior Analytics Engineer position at UOL EdTech?
- This position follows a hybrid work model, requiring 3 days per week in the office, located in São Paulo, SP, Brazil.
- Does UOL EdTech offer remote work options for the Senior Analytics Engineer role?
- No, the Senior Analytics Engineer role at UOL EdTech is a hybrid position requiring 3 days a week in the São Paulo office. Remote work is not specified as an option for this role.
- What is the company culture like at UOL EdTech for a Senior Analytics Engineer?
- UOL EdTech fosters a culture passionate about education and technology, aiming to transform lives through digital learning. They emphasize collaboration, results-driven work, and a pioneering, innovative spirit inherited from Grupo UOL. They value diversity and inclusivity, believing that collective effort leads to incredible results.
- What additional qualifications would make a candidate stand out for the Senior Analytics Engineer role?
- To stand out, candidates would benefit from a strong engineering mindset with a passion for automation, code quality, and documentation. Experience with Python for data scripting, observability tools (Elementary, Monte Carlo, Soda), dbt Mesh for managing large-scale data projects, and knowledge of DataOps and governance practices (LGPD) are also highly desirable.