Job Summary

We are looking for a highly skilled Data Engineer / Data Modeler with strong experience in Snowflake, DBT, and GCP to support our data infrastructure and modeling initiatives. The ideal candidate should possess excellent SQL skills, hands-on experience with Erwin Data Modeler, and a robust background in modern data architectures and data modeling techniques.

Key Responsibilities
- Design and implement scalable data models using Snowflake and Erwin Data Modeler.
- Create, maintain, and enhance data pipelines using DBT and GCP (BigQuery, Cloud Storage, Dataflow).
- Perform reverse engineering on existing systems (e.g., Sailfish/DDMS) using DBeaver or similar tools to understand and rebuild data models.
- Develop efficient SQL queries and stored procedures for data transformation, quality, and validation.
- Collaborate with business analysts and stakeholders to gather data requirements and convert them into physical and logical models.
- Ensure performance tuning, security, and optimization of the Snowflake data warehouse.
- Document metadata, data lineage,



and business logic behind data structures and flows.
- Participate in code reviews, enforce coding standards, and provide best practices for data modeling and governance.

Must-Have Skills
- Snowflake architecture, schema design, and data warehouse experience.
- DBT (Data Build Tool) for data transformation and pipeline development.
- Strong expertise in SQL (query optimization, complex joins, window functions, etc.).
- Hands-on experience with Erwin Data Modeler (logical and physical modeling).
- Experience with GCP (BigQuery, Cloud Composer, Cloud Storage).
- Experience in reverse engineering legacy systems like Sailfish or DDMS using DBeaver.

Good To Have
- Experience with CI/CD tools and DevOps for data environments.
- Familiarity with data governance, security, and privacy practices.
- Exposure to Agile methodologies and working in distributed teams.
- Knowledge of Python for data engineering tas

📌 Data Engineer (Faridabad)
🏢 Sketch Lighting
📍 Faridabad