Snowflake Data Modeler (Python, dbt, Storm Expert)

Job Title: Snowflake Data Modeler (Python, dbt, Storm Expert)Location: [Onsite / Remote / Hybrid]Experience: 5+ YearsEmployment Type: Full-Time / ContractJob SummaryWe are seeking a highly skilled Snowflake Data Modeler with strong expertise in Python, dbt (data build tool), and real-time processing frameworks like Apache Storm. The ideal candidate will be responsible for designing scalable data models, building robust data pipelines, and enabling efficient analytics across the organization.Key Responsibilities• Design and develop scalable and optimized data models in Snowflake (Star/Snowflake schemas, DataVault, etc.)• Build and maintain ETL/ELT pipelines using Snowflake, Python, and dbt• Develop and optimize dbt models, macros, and tests for data transformation• Implement real-time data processing solutions using Apache Storm• Collaborate with data engineers, analysts, and business teams to define data requirements• Ensure data quality, governance, and consistency across platforms• Perform performance tuning for Snowflake queries and pipelines• Create and maintain technical documentation for data models and workflows• Support CI/CD processes for data pipelinesRequired Skills & Qualifications• Strong experience with Snowflake• Proficiency in Python for data processing and automation• Hands-on experience with dbt (models, seeds, snapshots, testing)• Experience with Apache Storm for real-time data processing• Strong understanding of data modeling concepts (Dimensional modeling, Data Vault, normalization)• Expertise in SQL and query optimization• Experience with cloud platforms (AWS / Azure / GCP)• Familiarity with data orchestration tools (Airflow preferred)• Strong problem-solving and analytical skillsPreferred Qualifications• Experience with data warehousing and lakehouse architectures• Knowledge of streaming technologies (Kafka, Spark Streaming)• Exposure to DevOps / CI-CD pipelines• Certification in Snowflake or cloud platforms• Experience working in Agile/Scrum environmentsWhat Makes a Strong Candidate (Storm-Level Expertise)• Deep understanding of real-time data pipelines and streaming architectures• Ability to design high-performance Snowflake models at scale• Advanced knowledge of dbt optimization and modular design• Strong coding skills in Python for data engineering and automation• Proven track record of handling large-scale, high-volume datasetsNice to Have• Experience in data governance and security frameworks• Knowledge of machine learning data pipelines• Exposure to BI tools like Tableau / Power BI