Senior Data Engineer (dbt, Snowflake, Tableau)

Quick Facts

• Role: Senior Data/Analytics Engineer focused on data engineering and business intelligence

• Focus: dbt Core in Snowflake + Tableau reporting

• Time requirement: Availability aligned with EST time zone or at least 4-hour overlap

Description

You will own dbt models in Snowflake from design through deployment and build Tableau reporting solutions on top of them. You’ll design, govern, and present portfolio, client, and financial data through a unified reporting layer for strategic decision-making.

Responsibilities

• Design, develop, and maintain dbt Core projects (staging, intermediate, mart layers)

• Build incremental models, snapshots, macros, reusable Jinja components, and testing frameworks

• Ensure data quality via testing, documentation, lineage management, and version-controlled development practices

• Create dimensional data models and reporting structures for portfolio, client, and financial analytics

• Develop and maintain Snowflake ingestion pipelines, including API-based integrations

• Orchestrate and monitor data workflows using Prefect

• Integrate and standardize data from third-party platforms using Workato

• Create and maintain Tableau dashboards, published data sources, and reporting assets

• Optimize Snowflake performance and cost efficiency through query tuning and data architecture improvements

• Translate stakeholder reporting/analytics requirements into scalable data solutions

Requirements

• 5+ years of experience in Data Engineering or Analytics Engineering

• Hands-on production experience with dbt Core

• Experience with dbt: incremental strategies, snapshots, macros, Jinja templates, tests, and documentation

• Strong Snowflake experience, including performance optimization and cost management

• Advanced SQL skills

• Strong understanding of dimensional modeling and star schema design

• Hands-on experience building Tableau dashboards and data sources

• Experience with Tableau calculated fields, Level of Detail expressions, extracts, live connections, and dashboard performance optimization

• Experience with ETL/ELT and API-based data ingestion

• Experience with orchestration tools such as Prefect or Apache Airflow

• Understanding of financial services/wealth management/investment management/portfolio data structures

Benefits

• Up to 26 business days of vacation per year

• 10 illness/special paid days off per year

• Health and life insurance

• MyBenefit platform with Multisport option

• Internal psychological support service

• English language classes from the first working day

• Access to external learning platforms (O’Reilly, LinkedIn Learning, Udemy) and internal training catalog

• Flexible workplace: office, remote, or hybrid

• Tech Skills Mentoring Program

• Opportunities to develop as a public speaker, mentor, or technical interviewer

• Certification reimbursement (AWS, GCP, Microsoft, etc.)