Senior Data Engineer — Snowflake & Dbt (Wealth Management)

Dataart; Marabá; Presencial; BRL 200 000 - 300 000; Tempo integral

Resumo da oferta

DataArt in Marabá, Pará, Brazil is seeking a Senior Data Engineer to build a scalable data platform for a global wealth management client. You will own end-to-end pipelines and ensure the Snowflake data warehouse is fast for complex analytics.

Key responsibilities include modeling, testing, and running DBT transformations, orchestrating data workflows with Prefect, and connecting data from Addepar, NetSuite, Salesforce, Morningstar, and UKG. Strong financial domain experience is required.

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 patterns

Orchestration tools (Prefect/Airflow)

Financial / wealth management domain

Ferramentas

Snowflake

DBT

Prefect

Airflow

Tableau

Addepar

NetSuite

Salesforce

Morningstar

UKG

Descrição da oferta de emprego

Senior Data Engineer — Snowflake & DBT (Wealth Management) DataArt•marabá, estado do parâ, 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