Senior Data Engineer (Snowflake/DBT)

Zallpy Software LTDA; Campinas; Híbrido; BRL 120 000 - 180 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Meal/Food Allowance Cajumulti-benefit-

Health Plan– Unimed

Dental Plan– Uniodonto

Wellhub

Zenklub

Life Insurance

Childcare Allowance

Baby Zallpy

Business Partner Support

Volunteer Internal Communities

Educational Partnerships

Experiences & Development

Referral Program

Resumo da oferta

Zallpy Software LTDA is seeking a data engineer to design, implement, and optimize robust ETL/ELT pipelines and data models for BI use. You will coordinate with multiple teams to ensure timely delivery and scalable solutions.

The role requires SQL and Python fluency, experience with Snowflake, DBT, SQL Server, Power BI, Git, and cloud BI tooling (Azure). Familiarity with REST APIs and CI/CD is essential.

Qualificações

• Bachelor's or Master's degree in Computer Science, Business Intelligence, or related fields.
• Solid experience with Snowflake, DBT, Microsoft SQL Server, Power BI, and Git.
• Fluency in SQL and Python.
• Strong data modeling and robust ETL/ELT pipeline development.
• Experience writing, executing, and optimizing complex SQL queries.
• Experience implementing REST API service architectures.
• Ability to develop clean, maintainable code in a CI/CD environment.
• Experience with cloud BI technologies such as Azure.
• Experience translating business requirements into advanced data models for analysts and data scientists.
• Experience with data profiling and agile teams building big data analytics.
• Open-minded and adaptable to new data architectures (data vault, event-driven, unstructured data, self-service analytics).

Responsabilidades

• 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.

Conhecimentos

Snowflake

DBT

Microsoft SQL Server

Power BI

Git

SQL

Python

Data Modeling

ETL/ELT

REST API

CI/CD

Azure

Data Profiling

Agile

Data Vault (Nice to have)

Formação académica

Bachelor's or Master's degree in Computer Science, Business Intelligence, or related fields

Ferramentas

Snowflake

DBT

Microsoft SQL Server

Power BI

Git

SQL

Python

Azure

Descrição da oferta de emprego

Remote

Remote BR

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.

Whatyouwilldo:

• 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:

• 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.

• CLT
• Cooperative

Benefits of being a Zallper:

• Meal/Food Allowance
  Cajumulti-benefitcard (creditformat),offeringflexibilityforeverydayneeds. (CLTonly) *
• HealthPlan– Unimed
  Nowaitingperiodorcopaymentfortheholder.Possibilitytoincludedependents(children,spouse,orstepchildren)withcopayment. (CLTonly) *
• DentalPlan– Uniodonto
  Affordableoptionstoincludedependents. (CLTonly) *
• Wellhub
  Accesstogyms,physicalactivities,andwellnessprograms.
• Zenklub
  For CLT:Twofreesessionspermonthandspecialrates foradditionalsessions.
  ForCooperative/Contractor:Specialrates forsessions.
• Life Insurance
  Moresecurityforyouandyourfamily. (CLTonly) *
• ChildcareAllowance
  FinancialsupportforZallperswithchildrenfrom4monthsto6yearsold,accordingtointernalpolicy. (CLTonly) *
• Baby Zallpy
  Aspecialgifttocelebratethearrivalofnew Zallpy babies.
• BusinessPartnerSupport
  Closeandhuman-centeredsupportfromourPeople & CultureteamthroughoutyourjourneyatZallpy.
• VolunteerInternalCommunities
  Diversity, Sports & Movement,andTechnology.
• EducationalPartnerships
  Discountsonundergraduateandgraduateprograms, professionalcourses,andlanguageschools.
• Experiences& Development
  Participationinevents, workshops,trips,andteam-buildingactivities.
• ReferralProgram
  RefertalentstoZallpyandreceivebonusesfromR$2,500toR$5,000.
• *Contractor/ PJ: Forthesehiringmodels,thebenefitsaboveapplyexceptforthosemarkedwithanasterisk(*),whichare exclusivetoCLT. Inaddition,weofferdedicatedplatformstomanagecontractors,ensuringorganization,transparency,andastructuredexperiencethroughouttheentirejourney.

Job ID:ffc24e