Diverse Lynx
Snowflake Architect - Snowflake & DBT Modernization
Diverse Lynx, Jersey City, New Jersey, United States, 07390
Job Title:
Snowflake Architect - Snowflake & DBT Modernization
Location:
Jersey City, NY - 3-4 Days onsite
Long Term Project
Key Responsibilities:
Architecture Review & Optimization
Assess the current Snowflake-based data platform architecture. Identify bottlenecks and inefficiencies in data transformation and processing. Recommend architectural improvements for scalability, performance, and cost-efficiency.
Code & SQL Review
Conduct detailed reviews of DBT models, SnowSQL scripts, and transformation logic. Validate adherence to best practices in modularity, reusability, and performance tuning. Suggest improvements for query optimization and resource utilization.
Performance Tuning
Analyze slow-running queries and transformation pipelines. Implement strategies for warehouse sizing, clustering, caching, and materialization. Guide the team on Snowflake-specific performance features (e.g., result caching, automatic clustering).
Best Practices & Governance
Establish coding standards and naming conventions for DBT and SnowSQL. Define data governance, lineage, and documentation practices. Recommend monitoring and alerting mechanisms for data pipeline health.
Collaboration & Mentorship
Work closely with data engineers, analysts, and platform teams. Mentor junior developers on Snowflake and DBT development. Participate in sprint planning, code reviews, and architectural discussions.
Required Skills & Experience:
Proven experience as a
Cloud Data Architect
or
Senior Data Engineer
in Snowflake and other Cloud DB environments. Strong hands-on expertise in
DBT
,
SnowSQL
, and
SQL performance tuning
. Familiarity with
Oracle Exadata
and PL/SQL is a plus for comparative analysis. 10+ years experience in
data modeling ( logical and physical )
,
ETL/ELT design
, and designing and implementing
data warehouse , performance tuning and optimization
. Understanding of
CI/CD pipelines
,
version control
, and
deployment automation
. Excellent communication skills and ability to translate technical findings into actionable recommendations. Preferred Qualifications:
Snowflake Architect Certification , DBT Certification. Experience in banking or financial services data platforms. Exposure to cloud platforms like AWS, Azure, or GCP.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Snowflake Architect - Snowflake & DBT Modernization
Location:
Jersey City, NY - 3-4 Days onsite
Long Term Project
Key Responsibilities:
Architecture Review & Optimization
Assess the current Snowflake-based data platform architecture. Identify bottlenecks and inefficiencies in data transformation and processing. Recommend architectural improvements for scalability, performance, and cost-efficiency.
Code & SQL Review
Conduct detailed reviews of DBT models, SnowSQL scripts, and transformation logic. Validate adherence to best practices in modularity, reusability, and performance tuning. Suggest improvements for query optimization and resource utilization.
Performance Tuning
Analyze slow-running queries and transformation pipelines. Implement strategies for warehouse sizing, clustering, caching, and materialization. Guide the team on Snowflake-specific performance features (e.g., result caching, automatic clustering).
Best Practices & Governance
Establish coding standards and naming conventions for DBT and SnowSQL. Define data governance, lineage, and documentation practices. Recommend monitoring and alerting mechanisms for data pipeline health.
Collaboration & Mentorship
Work closely with data engineers, analysts, and platform teams. Mentor junior developers on Snowflake and DBT development. Participate in sprint planning, code reviews, and architectural discussions.
Required Skills & Experience:
Proven experience as a
Cloud Data Architect
or
Senior Data Engineer
in Snowflake and other Cloud DB environments. Strong hands-on expertise in
DBT
,
SnowSQL
, and
SQL performance tuning
. Familiarity with
Oracle Exadata
and PL/SQL is a plus for comparative analysis. 10+ years experience in
data modeling ( logical and physical )
,
ETL/ELT design
, and designing and implementing
data warehouse , performance tuning and optimization
. Understanding of
CI/CD pipelines
,
version control
, and
deployment automation
. Excellent communication skills and ability to translate technical findings into actionable recommendations. Preferred Qualifications:
Snowflake Architect Certification , DBT Certification. Experience in banking or financial services data platforms. Exposure to cloud platforms like AWS, Azure, or GCP.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.