Snowflake Architect

Job Details:

Role:

Employment Type:

Work Location:

Role Summary:

We are seeking a Solution Architect with a strong background in application modernization and enterprise data platform migrations.

Key Responsibilities:

• Provide solution architecture leadership & strategy development.
• Engage with BAs to translate functional and non-functional requirements into solution designs.
• Lead the overall design, including detailed configuration.
• Collaborate with Enterprise Architecture.
• Conduct thorough reviews of code and BRDs to ensure alignment with architectural standards, business needs, and technical feasibility.
• Evaluate system designs, ensuring scalability, security, and performance while adhering to best practices and organizational guidelines.
• Troubleshoot and resolve technical challenges encountered during coding, integration, and testing phases to maintain project timelines and quality.
• Strong expertise in data warehousing and data modelling
• Excellent communication, collaboration and presentation skills.
• Experience with ETL/ELT tools and processes, building complex pipelines and data ingestion.

SQL Skillset needed:

• Should be able to write Advanced SQL, complex joins.
• Subqueries - correlated /non correlated, CTEs.
• Window functions.
• Aggregations - Group by, rollup, cube, pivot.

Snowflake Skilled needed:

• Should be able to understand and write UDFs and stored procedures in snowflake.
• Have good understanding of Snowflake architecture, clustering , micro partitions, caching, virtual warehouse, stages, storage , security(row and column level security).
• Knowledge of snowflake features (Streams, time -travel, zero copy cloning, Snowpark and tasks).
• Provide expert recommendations on frameworks, tools, and methodologies to optimize development efficiency and system robustness.
• Performance tuning within Snowflake (Performance bottlenecks, materialized views, search optimization)
• Solution design- Ability to architect scalable, cost-effective snowflake solutions.
• Cost management - Monitor and optimize Snowflake credit usage and storage costs.