Technical Architect

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Snowflake, SQL, Python, and/or cloud services preferably AWS
• Build and optimize data models (staging, warehouse, Datamarts) using best practices such as micro partitioning, clustering, and performance tuning.
• Develop and manage data ingestion workflows from structured and semi‑structured sources (JSON, Parquet, XML, APIs, etc.).
• Implementation of business requirements using Snowflake features such as Streams, Tasks, Time Travel, Zero Copy Cloning, and Snowpipe for automated data loads.
• Collaborate with Data architects, analysts, and business stakeholders to translate requirements into scalable technical solutions.
• Monitor and troubleshoot pipelines for failures and issues ensuring data quality and integrity.
• Document data flows, transformations, and technical processes for maintainability and knowledge s...