Job Summary :

We are looking for an experienced DBT Snowflake Architect to design, develop, and optimize modern cloud-based data platforms using Snowflake and dbt (Data Build Tool).

The ideal candidate will have strong expertise in data warehousing, ELT pipeline development, data modeling, and cloud data architecture.

You will collaborate with cross-functional teams to build scalable, high-performance data solutions that support enterprise analytics and business intelligence initiatives.

Key Responsibilities :

- Design and implement scalable data architectures using Snowflake and dbt.

- Develop, maintain, and optimize ELT pipelines for processing large-scale datasets.

- Build reusable, modular, and well-documented dbt models following industry best practices.

- Design and implement dimensional data models, including star and snowflake schemas.

- Optimize SQL queries, Snowflake warehouse performance, and overall data processing efficiency.

- Ensure data quality, governance, security, and compliance across the data platform.

- Collaborate with business stakeholders, analysts, and engineering teams to gather requirements and translate them into technical solutions.

- Implement CI/CD pipelines and version control using Git for data engineering workflows.

- Monitor, troubleshoot, and resolve issues related to data pipelines and platform performance.

- Conduct architecture reviews and mentor engineering teams on modern data engineering best practices.

- Support continuous improvement initiatives for data platforms, performance tuning, and automation.

Required Skills :

- 814 years of experience in Data Engineering, Data Warehousing, or Data Architecture.

- Strong hands-on experience with Snowflake architecture, administration, and performance optimization.

- Expertise in dbt (Data Build Tool) including model development, testing, documentation, and deployment.

- Advanced proficiency in SQL and data transformation techniques.

- Strong knowledge of dimensional data modeling, star/snowflake schemas, and ELT architecture.

- Experience designing and building scalable cloud-based data solutions.

- Hands-on experience with ETL/ELT pipelines and integrating data from multiple sources.

- Experience with Git, CI/CD pipelines, and DevOps practices for data projects.

- Strong analytical, problem-solving, and troubleshooting skills.

- Excellent communication and stakeholder management abilities.

Preferred Skills :

- Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform (GCP).

- Familiarity with BI and analytics tools such as Power BI, Tableau, or Looker.

- Exposure to AI/ML workflows, data governance, metadata management, or data quality frameworks.

- Knowledge of orchestration tools such as Apache Airflow or similar workflow schedulers.

- Relevant Snowflake or cloud certifications are an added advantage.

Educational Qualification :

- Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related discipline.

Preferred Candidate Profile :

- Strong understanding of modern cloud data platforms and analytics architectures.

- Ability to work independently and lead technical solution design discussions.

- Experience working in Agile environments and collaborating with cross-functional teams.

- Passion for building scalable, reliable, and high-performing enterprise data solutions.