Data Engineer

Required Skills & Experience: Strong hands-on SQL experience, including complex queries, CTEs, joins, aggregations, and performance tuning. Strong hands-on Snowflake experience. Strong hands-on dbt experience, including incremental models. Experience with Apache Airflow for data pipeline orchestration. Experience building and supporting end-to-end ETL/ELT data pipelines. Understanding of Snowflake micro-partitions, warehouse sizing, caching, and query optimization. Ability to troubleshoot complex data and pipeline issues. Strong ability to explain technical decisions and solutions. Nice to HaveSkills & Experience Snowflake Data Sharing experience. Experience with Dynamic Data Masking and Snowflake security. Experience implementing role-based data access and masking policies. Experience with data replication/ingestion technologies feeding Snowflake. Experience handling source deletes within dbt incremental models. Experience supporting financial or investment-related datasets.

Job Description: We are seeking a Data Engineer to support the development, optimization, and maintenance of cloud-based data pipelines and data models. This individual will work heavily within Snowflake and dbt, developing complex SQL transformations and supporting reliable movement of data from various source systems into Snowflake. The ideal candidate will have strong hands-on experience troubleshooting query performance, building incremental data models, and working with orchestration tools such as Airflow. They should also understand Snowflake security, data masking, data sharing, micro-partitioning, and warehouse performance.