Remote job
Senior Data Engineer
Job details
About this role
Role overview Own the data models and reporting layer that bring portfolio, client, financial, and operational information together for executive and advisory decision-making. You’ll work across analytics engineering and business intelligence, building a scalable data ecosystem from ingestion through dashboards. The role requires working hours aligned with the Eastern time zone or at least four hours of overlap.
Responsibilities - Build and maintain dbt projects spanning staging, intermediate, and mart layers, including incremental models, snapshots, reusable macros, tests, and documentation. - Design dimensional models and reporting structures for financial, client, and portfolio analytics. - Develop and monitor Snowflake ingestion pipelines, including API integrations, and orchestrate workflows with Prefect. - Standardize data from financial and operational platforms using an integration platform. - Create Tableau dashboards and published data sources for business reporting. - Improve Snowflake performance and cost efficiency, and work with stakeholders to turn reporting needs into durable data solutions.
Requirements - At least five years in data engineering or analytics engineering, including production experience with dbt Core. - Strong Snowflake and advanced SQL skills, with experience tuning queries and managing warehouse costs. - Practical knowledge of dbt modeling patterns, tests, documentation, and version-controlled development. - Experience with dimensional modeling, including star schemas. - Hands-on Tableau experience, including calculated fields, Level of Detail expressions, extracts or live connections, and dashboard optimization. - Experience with ETL or ELT pipelines, API-based ingestion, and workflow orchestration such as Prefect or Airflow.
Nice to have Experience in wealth, investment, or financial services; familiarity with Workato and financial data platforms; Python development; dbt certification; CI/CD for dbt; and knowledge of financial data privacy or regulatory requirements.