Senior Data Engineer — Snowflake & Dbt (Wealth Management)

Dataart; Piracicaba; Presencial; BRL 260 000 - 420 000; Tempo integral

Resumo da oferta

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

Responsibilities include building Snowflake + DBT transformations, orchestrating workflows with Prefect, and connecting data from tools like Salesforce, NetSuite, Morningstar, and Bloomberg.

Qualificações

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

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

SQL

Data Modeling

ETL/ELT

API Ingestion

Orchestration

Python

Ferramentas

Snowflake

DBT

Prefect

Airflow

Workato

Tableau

Salesforce

NetSuite

Bloomberg

Morningstar

Descrição da oferta de emprego

Senior Data Engineer — Snowflake & DBT (Wealth Management) DataArt•piracicaba, estado de são paulo, br

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.