Senior Data Engineer (Snowflake/Dbt)

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