Snowflake Architect

Artifintech; Santa Clara (CA); Vor Ort; USD 150.000 - 230.000; Vollzeit

Zusammenfassung

Artifintech in Santa Clara, CA seeks a senior Data Engineer to design and implement enterprise Snowflake data warehouses and related architectures. You will drive data modeling, SQL optimization, and scalable ETL/ELT pipelines across cloud environments.

You will lead technical discussions, mentor teams, and collaborate with stakeholders to ensure data security, governance, and cost management in Snowflake deployments. Compliance and performance are essential.

Qualifikationen

• 8–12+ years in Data Engineering, Data Warehousing, or Data Architecture.
• 5+ years with Snowflake architecture and implementation.
• Strong SQL programming and performance tuning.
• Experience with Python and Snowflake scripting.
• Experience with cloud platforms (AWS, Azure, or GCP).
• Knowledge of data governance, metadata, and data lineage (desirable).

Aufgaben

• Design and implement enterprise-level data warehouse architectures using Snowflake.
• Define data architecture standards and best practices for cloud platforms.
• Develop and optimize complex SQL queries, stored procedures, views, and Snowflake objects.
• Design scalable ETL/ELT pipelines for data ingestion and transformation.
• Lead architecture discussions, reviews, and PoC initiatives.
• Mentor development teams on Snowflake best practices.
• Collaborate with data engineers, analysts, and application teams.
• Ensure data security, RBAC, masking policies, and cost management.

Kenntnisse

Snowflake architecture

Advanced SQL

ETL/ELT development

Data modeling

Python

Cloud platforms (AWS/Azure/GCP)

Data security concepts

Tools

Informatica

Matillion

Fivetran

dbt

Talend

Jobbeschreibung

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H4-EAD, Other

Job Description:

Key Responsibilities:

• Design and implement enterprise-level data warehouse architectures using Snowflake.
• Define data architecture strategies, standards, and best practices for cloud-based data platforms.
• Develop and optimize complex SQL queries, stored procedures, views, and Snowflake objects.
• Design and implement scalable ETL/ELT pipelines for data ingestion and transformation.
• Work with Snowflake features such as Virtual Warehouses, Snowpipe, Streams, Tasks, Time Travel, Zero-Copy Cloning, and Dynamic Tables.
• Develop data integration solutions using tools such as Informatica, Matillion, Fivetran, dbt, or Talend.
• Implement data modeling techniques, including Star Schema, Snowflake Schema, and dimensional modeling.
• Optimize query performance, warehouse utilization, and overall Snowflake cost management.
• Implement data security, role-based access control (RBAC), masking policies, and row-level security.
• Establish data governance, data quality, metadata management, and data lineage standards.
• Integrate Snowflake with cloud platforms such as AWS, Azure, or Google Cloud Platform.
• Lead technical discussions, architecture reviews, and proof-of-concept initiatives.
• Collaborate with business stakeholders, data engineers, data analysts, and application teams.
• Mentor development teams and provide technical guidance on Snowflake best practices.

Required Technical Skills:

• 8–12+ years of experience in Data Engineering, Data Warehousing, or Data Architecture.
• 5+ years of hands-on experience with Snowflake architecture and implementation.
• Strong expertise in Snowflake cloud data warehouse architecture.
• Advanced SQL programming and performance tuning.
• Strong experience with ETL/ELT development and data integration.
• Expertise in data modeling, dimensional modeling, and database design.
• Hands-on experience with Python and Snowflake scripting.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Knowledge of Snowflake security, governance, and access management.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.