Senior Data Engineer (Snowflake/Dbt)
zallpy
Remoto
BR
Dados
Business Intelligence
Score da Vaga
100 pontos
Modelo remoto (+90)
Dados (+10)
Business Intelligence (+10)
Here at Zallpy, technology is born from curious, collaborative people with a desire to do things well. If you like environments where there's room to ask questions, test, learn, and evolve together, check out this opportunity! 💚
Diversity, Equity, and Inclusion
At Zallpy, we value an environment where everyone can be themselves, with respect, safety, and a sense of belonging. We especially encourage applications from people with disabilities and guarantee an accessible environment with adaptations and support throughout the journey.
We also encourage Black people, women, LGBTQIA+ individuals, and professionals from diverse backgrounds to apply.
Here, you can be yourself at every stage of your journey. Come join us. 🚀
We are looking for someone to work in a team that thinks big, works with attention to detail, collaborates daily, and shares responsibility. We believe in autonomy, the exchange of different experiences, and solutions built together.
Here, growth means sharing knowledge, respecting different ways of thinking, and building trusting relationships while delivering quality technology. If you identify with this way of working, come join us.
What you will do:
- Design, develop, implement, and support robust ETL/ELT and data pipeline solutions;
- Coordinate with multiple development teams to achieve delivery objectives;
- Support requirements definition, estimation, and delivery of scalable solutions;
- Develop and support real-time data ingestion processes from various data sources;
- Develop and support data models optimized for business intelligence usage;
- Build integrations with APIs from external providers such as Google, Facebook, Salesforce, SAP, and others;
- Adhere to industry standards and regulations such as GDPR and SOX;
- Lead best-practices definition and promote creative thinking within the team.
What we are looking for:
- Fluent English;
- Bachelor's or Master's degree in Computer Science, Business Intelligence, or related fields;
- Solid and demonstrated experience with Snowflake, DBT, Microsoft SQL Server, Power BI, and Git;
- Fluency in SQL and Python;
- Strong understanding of data modeling and development of robust ETL/ELT pipelines;
- Experience writing, executing, and optimizing complex SQL queries;
- Experience implementing REST API service architectures;
- Ability to develop clean and maintainable code in a CI/CD environment;
- Experience with cloud BI technologies such as Azure or similar;
- Experience translating business requirements into advanced data models for analysts and data scientists;
- Experience with data profiling and working within agile teams to build big data and analytics solutions;
- Open-minded, organized, and able to adapt to new ways of working (data vault, event-driven architecture, unstructured data, self-service analytics).
Nice to have:
- Experience with data vault or event-driven architecture;
- Background with unstructured data and self-service analytics;
- Proven track record of continuous improvement and hands-on interest in emerging technologies.
Where you will work:
-
This is a hybrid opportunity, requiring employees to work from the Campinas, SP office twice a week.
Hiring models:
- CLT
- Cooperative
Benefits of being a Zallper:
🍽 Meal/Food Allowance
Caju multi-benefit card (credit format), offering flexibility for everyday needs. (CLT only) *
🏥 Health Plan – Unimed
No waiting period or copayment for the holder. Possibility to include dependents (children, spouse, or stepchildren) with copayment. (CLT only) *
🦷 Dental Plan – Uniodonto
Affordable options to include dependents. (CLT only) *
💪 Wellhub
Access to gyms, physical activities, and wellness programs.
🧘 Zenklub
For CLT: Two free sessions per month and special rates for additional sessions.
For Cooperative/Contractor: Special rates for sessions.
🛡 Life Insurance
More security for you and your family. (CLT only) *
👶 Childcare Allowance
Financial support for Zallpers with children from 4 months to 6 years old, according to internal policy. (CLT only) *
🎁 Baby Zallpy
A special gift to celebrate the arrival of new Zallpy babies.
👥 Business Partner Support
Close and human-centered support from our People & Culture team throughout your journey at Zallpy.
🌍 Volunteer Internal Communities
Diversity, Sports & Movement, and Technology.
🎓 Educational Partnerships
Discounts on undergraduate and graduate programs, professional courses, and language schools.
✈️ Experiences & Development
Participation in events, workshops, trips, and team-building activities.
💼 Referral Program
Refer talents to Zallpy and receive bonuses from R$2,500 to R$5,000.
* Contractor / PJ: For these hiring models, the benefits above apply except for those marked with an asterisk (*), which are exclusive to CLT. In addition, we offer dedicated platforms to manage contractors, ensuring organization, transparency, and a structured experience throughout the entire journey. 😉
Job ID:ffc24e
Sobre a área de Dados
A área de Dados passou por uma transformação radical com a ascensão da Inteligência Artificial Generativa. Profissionais de dados são fundamentais para tomada de decisão baseada em evidências em todas as indústrias.
As principais especializações incluem Data Engineering, Data Science, Business Intelligence, Machine Learning Engineering e Analytics. Ferramentas como SQL, Python, Spark, dbt e plataformas de cloud (AWS, GCP, Azure) são essenciais.
O mercado de dados continua com alta demanda e salários entre os mais competitivos do setor de tecnologia, com muitas oportunidades para trabalho remoto.
Sobre a área de Business Intelligence
Business Intelligence (BI) é a área responsável por transformar dados brutos em informações estratégicas para tomada de decisão. Profissionais de BI constroem dashboards, relatórios e análises que ajudam as empresas a entender seu desempenho e identificar oportunidades de crescimento.
As principais habilidades incluem modelagem de dados (star schema, snowflake), ETL (extração, transformação e carga), SQL avançado, ferramentas de BI (Power BI, Tableau, Looker), data warehousing, KPIs e análise de métricas de negócio (MRR, churn, cohort). Conhecimento de dbt, Airflow e pipelines de dados é diferencial.
Profissionais de BI em empresas de tecnologia são muito valorizados, especialmente aqueles que dominam data visualization, analytics engineering e conseguem traduzir dados complexos em insights acionáveis para o negócio. A área oferece oportunidades desde analista de BI até diretor de dados, com foco em tomada de decisão baseada em dados.