Data Modeler - SQL / Erwin

Zorba Consulting India Pvt. Ltd.; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

A leading consulting firm is seeking a highly skilled Data Engineer / Data Modeler to enhance their data infrastructure and modeling initiatives. This role requires strong experience with Snowflake, DBT, SQL, and GCP while supporting collaboration with business stakeholders. Ideal candidates will demonstrate expertise in creating scalable data models and data pipelines, ensuring optimized performance and data governance in a remote work environment.

Qualifications

• Strong experience in Snowflake architecture and schema design.
• Hands-on experience with DBT for data transformation.
• Ability to perform reverse engineering on legacy systems.

Responsibilities

• Design and implement scalable data models using Snowflake.
• Create and maintain data pipelines using DBT and GCP.
• Collaborate with stakeholders to gather data requirements.

Skills

SQL

Data Modeling

Snowflake

DBT

GCP

Tools

Erwin Data Modeler

DBeaver

Job description

Employment Type : Contract (Remote).

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.