Senior Data Engineer — Snowflake & Dbt (Wealth Management)

Dataart; Maceió; Presencial; BRL 180 000 - 320 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, ensuring a fast Snowflake warehouse for complex analytics.

The role requires 7+ years in data engineering, strong SQL and data modeling, and hands-on experience with Snowflake, DBT, and orchestration tools like Prefect or Airflow.

Qualificações

• 7+ years in data engineering and building modern data platforms.
• Strong SQL and advanced data modeling skills.
• Experience with ETL/ELT patterns and API-based ingestion.
• Hands-on with orchestration tools such as Prefect or Airflow.
• Experience in financial and wealth management data domains.

Responsabilidades

• Build and maintain scalable data pipelines loading 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.
• Maintain data quality, lineage, governance, and optimize Snowflake performance and cost.
• Collaborate with Tableau developers and business stakeholders to meet reporting needs.

Conhecimentos

Snowflake

DBT

SQL

Data modeling

ETL/ELT

Airflow/Prefect

Financial domain

Wealth management domain

Python

Ferramentas

Tableau

Workato

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