Data Engineer - Snowflake DB

About the Role: We are looking for an experienced Data Engineer with strong expertise in Snowflake, DBT, SQL, and Data Warehousing to build scalable data transformation pipelines and modern cloud-based data platforms. The ideal candidate will have hands-on experience in designing enterprise data warehouse solutions, optimizing Snowflake environments, and implementing DataOps best practices. Key Responsibilities: - Design, develop, and maintain modular DBT models, including staging, intermediate, and data marts. - Build and optimize scalable ETL/ELT data pipelines and data ingestion frameworks. - Design and maintain Snowflake schemas, data models, and transformation workflows. - Implement and manage Snowpipe, Streams, Tasks, and Virtual Warehouses for efficient data processing. - Develop and optimize SQL queries and DBT models for high performance. - Implement data quality checks, testing frameworks, and data validation using DBT. - Manage CI/CD pipelines for automated DBT deployments and Snowflake schema changes. - Collaborate with Analytics Engineers, Data Analysts, and business stakeholders to translate business requirements into scalable data solutions. - Implement role-based access control (RBAC), security policies, and secure data sharing within Snowflake. - Troubleshoot and optimize data pipelines, SQL queries, and performance bottlenecks. - Maintain data lineage, documentation, and enterprise data standards. Required Skills: - 810 years of experience in Data Engineering. - Strong expertise in Snowflake, DBT Framework, and SQL. - Experience building Enterprise Data Warehouse (DWH) solutions. - Strong understanding of Dimensional Data Modeling, Star Schema, and data warehousing concepts. - Experience designing ETL/ELT pipelines and data ingestion frameworks. - Hands-on experience with Linux/Unix Shell Scripting. - Experience with scheduling tools such as Control-M, Autosys, or equivalent. - Strong analytical, debugging, and problem-solving skills. Good to Have: - Exposure to Databricks. - Experience with cloud data platforms. - Knowledge of CI/CD tools such as GitHub Actions, GitLab CI, or DBT Cloud. - Familiarity with Power BI. - Excellent communication and stakeholder management skills.