Data Modeler - SQL/Erwin
- Leading Client
- 7 - 10 years
- Kolkata
- 4 months ago
- Email to a friend
- Report this job
Job Description
Employment Type : Contract (Remote).Experience Required : 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.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: DBA / Data warehousing - OtherEmployement Type: Full timeContact Details:
Company: Leading ClientLocation(s): Kolkata
Keyskills: Data Modeling Data Quality Data Build Tool Data Security Snowflake DB Data Warehousing Data Analytics Data Governance Erwin SQL
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in