Senior Data Engineer — Snowflake & Dbt (Wealth Management)

Dataart; Itajaí; Presencial; BRL 180 000 - 320 000; Tempo integral

Resumo da oferta

DataArt Brazil is seeking a Senior Data Engineer to build a scalable data platform for a global wealth and asset management firm. You will own end-to-end pipelines, from ingestion to transformation, and ensure a fast Snowflake data warehouse for analytics.

You will implement DBT transformations, orchestrate with Prefect, and connect systems like Salesforce and Morningstar to deliver accurate reporting. The ideal candidate has 7+ years in data engineering and strong SQL.

Qualificações

• 7+ years in data engineering building modern data platforms.
• Strong SQL and advanced data modeling.
• Experience with ETL/ELT and API-based ingestion.
• Hands-on with orchestration tools like Prefect or Airflow.
• Proficiency with Snowflake and DBT.

Responsabilidades

• Build and maintain scalable data pipelines that load data into Snowflake.
• Create and manage DBT transformations: modeling, testing, and documentation.
• Design and run complex data workflows with Prefect.
• Use Workato to connect data from SaaS tools like Addepar, NetSuite, Salesforce, Morningstar, and UKG.
• Design data models for portfolio, client, and financial reporting.
• Keep data quality, lineage, and governance strong, while optimizing Snowflake performance and cost.
• Work with Tableau developers and business stakeholders to meet reporting needs.

Conhecimentos

Snowflake

DBT

SQL

ETL/ELT

Prefect

Airflow

Finance domain

Wealth management

Data modeling

Ferramentas

Snowflake

DBT

Prefect

Airflow

Tableau

Salesforce

Descrição da oferta de emprego

Descrição da vaga We are looking for a Senior Data Engineer to join a data platform team building a large, scalable data ecosystem for a global wealth and asset management firm. The data gives C-level leaders and advisors one reliable place for reporting and decision-making.

You will own data pipelines end to end, from ingestion to transformation, and make sure the Snowflake warehouse is fast and ready for complex wealth management analytics.

Must-have skills (please apply only if you have all of these):

• Strong hands-on experience with Snowflake and DBT
• Experience in the financial domain
• Experience in the wealth management domain

What you will do

• Build and maintain scalable data pipelines that load data into Snowflake
• Create and manage DBT transformations: modeling, testing, and documentation
• Design and run complex data workflows with Prefect
• Use Workato to connect data from SaaS tools like Addepar, NetSuite, Salesforce, Morningstar, and UKG.
• Design data models for portfolio, client, and financial reporting
• Keep data quality, lineage, and governance strong, while optimizing Snowflake performance and cost
• Work with Tableau developers and business stakeholders to meet reporting needs

What we look for

• 7+ years in data engineering, building modern data platforms
• Strong SQL and advanced data modeling
• Experience with ETL/ELT patterns and API-based ingestion
• Hands-on with orchestration tools like Prefect or Airflow
• Good understanding of financial / wealth management data structures

Nice to have

• DBT certification.
• Experience supporting Tableau reporting layers
• Background with market data providers like Bloomberg or Morningstar
• Python for data engineering tasks