Design and implement scalable Snowflake Data Warehouse/Data Lakehouse architectures
Develop enterprise data solutions for manufacturing analytics, supply chain, production planning, quality management, and IoT data processing
Architect ELT/ETL pipelines using tools such as DBT, Informatica, ADF
Define data modeling strategies including: Star schema, Snowflake schema, Data Vault, Dimensional modeling
Optimize Snowflake performance: Query tuning, Clustering, Caching, Warehousing strategy, Cost optimization
Integrate Snowflake with manufacturing systems: Oracle ERP, CRM, IoT platforms, External API’s
Implement data security, governance, and compliance frameworks
Enable CI/CD and DevOps practices for data engineering workflows
Support near real-time and batch processing architectures
Work closely with business stakeholders, architects, analysts, and data engineering teams
Mentor junior engineers and provide technical leadership

Experience 10-14 Years
Strong expertise in Snowflake Architecture
Snowpipe, Streams & Tasks, Time Travel, Secure Data Sharing, Snowpark, Zero Copy Cloning
Proficiency in SQL and performance tuning
Familiarity with cloud platforms (AWS / Azure / GCP)
Hands-on with Python, Spark, DBT
Knowledge of Manufacturing KPIs and business processes
Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or related field
Snowflake Certification preferred: SnowPro Core (Must)
SnowPro Advanced Architect (Good to have)
Nice to Have: Knowledge of MDM and data governance tools
Experience with Tableau / Power BI

Technical Architect – Azure/AWS, Snowflake

Key skills