Job Description: Job Description: Solution Architect - Analytics (Snowflake)
Role Summary:
We are seeking a Solution Architect with a strong background in application modernization and enterprise data platform migrations. This role will lead the design and architecture of solutions for migrating from SAP HANA to Snowflake ensuring scalability performance and alignment with business goals.
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.
Additional Sills: