Senior Data Engineer - ELT Pipelines

Job Description : We are seeking a highly skilled and experienced Senior Data Engineer to join our growing data team at Logic Pursuits. In this role, you will lead the design and implementation of scalable, high-performance data pipelines using Snowflake, dbt, and Matillion Data Productivity Cloud, define architectural best practices, and drive data transformation at scale. Key Responsibilities : - Architect and implement modular, test-driven ELT pipelines using dbt and Matillion Data Productivity Cloud on Snowflake. - Design layered data models (e.g., staging, intermediate, mart layers / medallion architecture) aligned with dbt and Matillion best practices. - Lead ingestion of structured and semi-structured data from APIs, flat files, cloud storage (Azure Data Lake, AWS S3), and databases into Snowflake. - Optimize Snowflake for performance and cost: warehouse sizing, clustering, materializations, query profiling, and credit monitoring. - Apply advanced dbt capabilities including macros, packages, custom tests, sources, exposures, and documentation. - Build reusable Matillion pipelines, shared jobs, and orchestration flows. - Orchestrate workflows using dbt Cloud, Matillion Data Productivity Cloud, Airflow, or Azure Data Factory. - Define and enforce data governance and compliance practices using Snowflake RBAC, secure data sharing, and encryption strategies. - Collaborate with analysts, data scientists, architects, and business stakeholders. - Mentor junior engineers, lead architectural/code reviews, and help establish reusable frameworks. - Engage with clients to gather requirements, present solutions, and manage end-to-end project delivery. Job Description : We are seeking a highly skilled and experienced Senior Data Engineer to join our growing data team at Logic Pursuits. In this role, you will lead the design and implementation of scalable, high-performance data pipelines using Snowflake, dbt, and Matillion Data Productivity Cloud, define architectural best practices, and drive data transformation at scale. Key Responsibilities : - Architect and implement modular, test-driven ELT pipelines using dbt and Matillion Data Productivity Cloud on Snowflake. - Design layered data models (e.g., staging, intermediate, mart layers / medallion architecture) aligned with dbt and Matillion best practices. - Lead ingestion of structured and semi-structured data from APIs, flat files, cloud storage (Azure Data Lake, AWS S3), and databases into Snowflake. - Optimize Snowflake for performance and cost: warehouse sizing, clustering, materializations, query profiling, and credit monitoring. - Apply advanced dbt capabilities including macros, packages, custom tests, sources, exposures, and documentation. - Build reusable Matillion pipelines, shared jobs, and orchestration flows. - Orchestrate workflows using dbt Cloud, Matillion Data Productivity Cloud, Airflow, or Azure Data Factory. - Define and enforce data governance and compliance practices using Snowflake RBAC, secure data sharing, and encryption strategies. - Collaborate with analysts, data scientists, architects, and business stakeholders. - Mentor junior engineers, lead architectural/code reviews, and help establish reusable frameworks. - Engage with clients to gather requirements, present solutions, and manage end-to-end project delivery.