Sigmasoft - Data Architect - Snowflake DB

Data Architect (Snowflake)

About the Role :

Key Responsibilities :

- Design and implement robust, scalable Snowflake-based data architectures.

- Collaborate with data engineers, analysts, and stakeholders to translate business requirements into technical solutions.

- Establish and enforce data architecture standards, governance, and best practices.

- Design and implement data pipelines using ETL/ELT tools (e.g., dbt, Fivetran, Informatica, Talend, etc.).

- Optimize Snowflake performance through clustering, partitioning, caching, and query tuning.

- Define data security, access controls, and data masking strategies in Snowflake.

- Integrate Snowflake with various data sources (e.g., AWS, Azure, GCP, APIs, on-prem systems).

- Stay updated with Snowflakes evolving features and recommend adoption strategies.

Required Qualifications :

- Bachelors or Masters degree in Computer Science, Information Systems, or related field.

- Hands-on experience with Snowflake in production environments.

- Strong knowledge of data modeling (star/snowflake schemas) and dimensional modeling.

- Proficiency with SQL, Python, and ETL/ELT tools.

- Experience with cloud platforms (AWS, Azure, or GCP).

- Knowledge of data governance, data quality, and metadata management.