Senior Data Engineer

Project overview

The project involves the development and expansion of a centralized, scalable data ecosystem. Having successfully ingested the initial data source, the team is now moving into a high-growth phase to integrate multiple high-value financial and operational data streams. The goal is to provide C-level executives and advisors with a unified, reliable reporting layer for strategic decision-making.

Position overview

As a Senior Data Engineer, you will be a technical cornerstone of the data platform team. You will be responsible for the end-to-end engineering of data pipelines, from ingestion to transformation, ensuring that the Snowflake warehouse is optimized for complex wealth management analytics. You will work at the intersection of sophisticated financial data and enterprise-grade engineering.

This position requires availability aligned with the EST time zone, or at least a 4-hour overlap with EST working hours (until 1 pm EST in the EU and APAC regions).

Responsibilities

• Build and maintain scalable data pipelines for ingestion into Snowflake.
• Develop and manage transformations using dbt, including modeling, testing, and comprehensive documentation.
• Design and orchestrate complex data workflows using Prefect.
• Utilize Workato to integrate and normalize data from critical SaaS platforms, including Addepar, NetSuite, Salesforce, Morningstar, and UKG.
• Design specialized data models tailored for portfolio, client, and financial reporting.
• Ensure data quality, lineage, and governance best practices while optimizing performance and costs within Snowflake.
• Partner with Tableau developers and business stakeholders to align technical delivery with reporting needs.

Requirements

• 5+ years of experience in data engineering with a focus on building modern data platforms.
• Hands-on experience with Snowflake and dbt, supported by strong SQL skills and advanced data modeling expertise.