Data Engineer / Data Modeler_7+Years

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 strong 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 tasks and orchestration scripts.

Soft Skills

• Excellent problem-solving and analytical skills.
• Strong communication and stakeholder management.
• Self-driven with the ability to work independently in a remote setup.

Skills: gcp,erwin,dbt,sql,data modeling,dbeaver,bigquery,query optimization,dataflow,cloud storage,snowflake,erwin data modeler,data pipelines,data transformation,datamodeler