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.