Role Overview

We are seeking a highly skilled Senior Data Engineer with deep expertise in Snowflake and dbt (Data Build Tool) to join our data analytics team. In this role, you will be responsible for designing, building, and optimizing robust data pipelines, transforming raw data into clean, actionable data models, and establishing scalable data warehousing architectures. You will collaborate closely with business analysts, data scientists, and business stakeholders to drive data-driven decision-making across our manufacturing, supply chain, and operational workflows.

Key Responsibilities

• Data Modeling & Transformation: Design, develop, and maintain robust data transformation pipelines using dbt (Data Build Tool) to implement version-controlled, tested, and documented data models.

• Data Warehousing Architecture: Architect, manage, and optimize enterprise-scale data warehouses within Snowflake, ensuring optimal storage, compute sizing, clustering, and data sharing strategies.

• Pipeline Development (ETL/ELT): Build scalable ingestion pipelines to extract data from various enterprise source systems (such as ERPs like SAP or Oracle, CRM platforms, and operational databases) and load it into Snowflake.

• Performance Optimization: Troubleshoot and fine-tune complex SQL queries, dbt models, and Snowflake warehouse utilization to improve execution speeds and manage costs efficiently.

• Data Quality & Governance: Establish rigorous data quality checks, testing frameworks (using dbt test configurations), and data monitoring patterns to ensure enterprise data reliability and lineage accuracy.

• Collaboration & CI/CD: Implement and maintain best practices for modern data stack workflows, utilizing Git and CI/CD pipelines (e.g., GitHub Actions, GitLab CI) for seamless deployment of data models.

Required Qualifications & Technical Skills

• Experience: 5+ years of dedicated data engineering experience, with a heavy emphasis on data warehouse modeling and pipeline development.