Senior Data/Analytics Engineer

Responsibilities

• Design, develop, and maintain dbt Core projects, including staging, intermediate, and mart layers
• Build incremental models, snapshots, macros, reusable Jinja components, and testing frameworks
• Ensure data quality through testing, documentation, lineage management, and version controlled development practices
• Design dimensional data models and reporting structures for portfolio, client, and financial analytics
• Develop and maintain data ingestion pipelines into Snowflake, including API based integrations
• Orchestrate and monitor data workflows using Prefect
• Integrate and standardize data from third party platforms such as Addepar, NetSuite, Salesforce, Morningstar, and UKG through Workato
• Create and maintain Tableau dashboards, published data sources, and reporting assets
• Optimize Snowflake performance and cost efficiency through query tuning, warehouse management, and data architecture improvements
• Collaborate with business stakeholders to translate reporting and analytics requirements into scalable data solutions

Languages