Data Modeling + Snowflake Developer

Data Modeling + Snowflake Developer

Experience: 5-12 Years
Location: Bangalore
Role: Data Modeler / Snowflake Data Engineer

Job Summary

We are looking for an experienced professional with 512 years of experience in Data Modeling and Snowflake to design, develop, and optimize enterprise data warehouse solutions. The candidate will work on data modeling, data transformation, Snowflake development, SQL, and data warehouse architecture.

Key Responsibilities

• Design and develop conceptual, logical, and physical data models.
• Create efficient data models based on business and analytical requirements.
• Develop and maintain Snowflake data warehouse solutions.
• Design tables, views, schemas, relationships, and data structures in Snowflake.
• Develop complex SQL queries for data transformation and analysis.
• Build and maintain ETL/ELT pipelines for loading data into Snowflake.
• Perform data transformation, cleansing, validation, and reconciliation.
• Optimize Snowflake queries and workloads for performance and cost efficiency.
• Analyze source systems and define appropriate target data models.
• Work closely with Data Architects, Data Engineers, Business Analysts, and reporting teams.
• Ensure data models support scalability, performance, reporting, and analytics requirements.
• Troubleshoot data-quality and performance issues.
• Maintain documentation for data models, mappings, and warehouse architecture.

Required Skills

• 5–12 years of experience in Data Warehousing / Data Engineering.
• Strong hands-on experience with Snowflake.
• Strong expertise in Data Modeling.
• Excellent knowledge of SQL.
• Experience with Dimensional Modeling, Star Schema, and Snowflake Schema.
• Good understanding of data warehouse architecture.
• Experience with ETL/ELT processes.
• Experience with data transformation and data integration.
• Knowledge of Snowflake objects, warehouses, stages, loading mechanisms, and performance optimization.
• Strong analytical and problem-solving skills.

Good to Have

• DBT
• Python
• Apache Airflow
• AWS / Azure / GCP
• Snowflake performance tuning
• Data governance and data quality
• BI tools such as Power BI/Tableau
• Git and CI/CD