Description :

EXP : 8+yrs

Location : Chennai

Role : Technical Architect

Job Summary :

We are looking for an experienced Snowflake & Data Warehouse Architect to design and optimize scalable cloud-based data warehouse solutions. The candidate should have strong expertise in Snowflake, modern data warehousing principles, ELT frameworks, and cloud platforms like Amazon Web Services, Microsoft Azure, or Google Cloud Platform.

The role involves architecting ELT-based solutions where transformation logic is implemented within Snowflake (stored procedures), with orchestration handled via Apache Airflow.

Key Responsibilities :

- Design and implement scalable data warehouse solutions in Snowflake

- Develop ELT pipelines with transformation logic in Snowflake stored procedures

- Orchestrate workflows using Apache Airflow

- Integrate data from CSV files and API-based sources

- Implement data modeling using Sql DBM

- Ensure performance tuning, cost optimization, and security (RBAC, masking)

- Manage data governance, quality, and compliance

- Support testing processes using ALM/AQM frameworks .Collaborate with BI teams using Tableau Software and Microsoft Power BI

Required Skills :

- 8+ years of experience in Data Warehousing & BI

- 3+ years of hands-on Snowflake architecture experience

- Snowflake certified

- Strong SQL and performance tuning expertise

- Experience with ELT architecture (transformations within Snowflake)

- Hands-on experience with Apache Airflow for scheduling/orchestration

- Experience integrating CSV and API data sources

- Knowledge of data modeling tools (Sql DBM preferred)

- Strong understanding of data governance and security