Data Engineer - Snowflake DB

Design, develop, and maintain scalable data transformation pipelines with primary focus on Snowflake and dbt.

- Build, enhance, and support dbt models, including staging, intermediate, and marts layers, following best practices for modularity, reusability, and maintainability.

- Develop and optimize data solutions in Snowflake, including schema design, tables, views, SQL transformations, and performance tuning.

- Implement and manage ELT workflows using dbt and one ETL/ELT tool such as Matillion, Informatica, SSIS, Talend, ADF, or similar.

- Work with structured and semi-structured data from multiple source systems and integrate it into Snowflake for downstream analytics and business consumption.

- Write efficient, high-quality SQL for data transformation, validation, reconciliation, and business logic implementation.

- Create and maintain dbt tests, documentation, and lineage-aware models to support data quality and governance standards.

- Optimize Snowflake workloads for performance, scalability, and cost efficiency.

- Collaborate with business analysts, data architects, and stakeholders to understand requirements and translate them into robust data models and transformation logic.

- Support deployment, version control, and release processes for dbt and Snowflake-based solutions.

- Troubleshoot data pipeline failures, transformation issues, and performance bottlenecks in Snowflake and dbt environments.

- Participate in code reviews, technical discussions, and continuous improvement initiatives to enhance engineering standards and delivery quality.

- Ensure all data solutions are aligned with enterprise data governance, security, and compliance requirements.