Snowflake Developer/Architect

Overview

Hybrid

$70 - $75

Accepts corp to corp applications

Contract - Independent

Contract - 8 Month(s)

No Travel Required

Skills

snowflake

architect

architecture

Identity Management

Snow Flake Schema

Scripting

ELT

Dimensional Modeling

Data Warehouse

Database

Database Design

Data Modeling

Data Integration

SQL

Job Details

Candidate must reside is MA/NH/RI.
In-person interview is required
Job Summary:
Client is seeking a highly skilled, experienced and motivated Snowflake Architect/Developer to join their team. The ideal candidate will have deep experience with Snowflake, data modeling, ETL/ELT processes, and cloud data architecture. You will work closely with Snowflake architecture team to deliver scalable, high-performance solutions that meet business analytics and reporting requirements. This role requires a deep understanding of Snowflake s features and best practices, as well as strong problem-solving skills and the ability to work collaboratively with cross-functional teams.
Key Responsibilities:

Performance Tuning: Monitor and optimize performance, including query performance, resource utilization, and storage management.
User and Access Management: Manage user access, roles, and permissions to ensure data security and compliance with organizational policies.
Data Integration: Support and manage data integration processes, including data loading, transformation, and extraction.
Troubleshooting and Support: Provide technical support and troubleshooting for Snowflake-related issues, including resolving performance bottlenecks and query optimization.
Documentation and Reporting: Maintain detailed documentation of system configurations, procedures, and changes. Generate and deliver regular reports on system performance and usage.
Collaboration: Work closely with data engineers, analysts, and other IT professionals to ensure seamless integration and optimal performance of the Snowflake environment.
Best Practices: Stay up to date with Snowflake best practices and industry trends. Recommend and implement improvements and upgrades to enhance system functionality and performance.

Qualifications and Experience:

5+ years of experience in data architecture, data engineering, or database development.
2+ years of hands-on experience with Snowflake, including data modeling, performance tuning, and security.
At a minimum Bachelor s degree in Computer Science, Information Technology, or related field.
Experience with source control tools (GitHub preferred), ETL/ELT tools and cloud platforms (AWS preferred).
Experience or exposure to AI tools.
Deep understanding of data warehousing concepts, dimensional modeling, and analytics.
Excellent problem-solving and communication skills.
Experience integrating Snowflake with BI and reporting tools is a plus

Required Skills:

Strong proficiency in Snowflake architecture, features, and capabilities.
Knowledge of SQL and Snowflake-specific query optimization.
Experience with ETL tools and data integration processes.
Strong proficiency in SQL and Python.
Strong Database design and data modelling experience. Experience with data modeling tools.
Ability to identify and drive continuous improvements.
Strong problem solving and analytical skills.
Demonstrated process-oriented and strategic thinking skills.
Strong motivation and a desire to continuously learn and grow.
Knowledge of Snowflake security features including access control, authentication, authorization, encryption, masking, secure view, etc.
Experience working in AWS cloud environments.
Experience working with Power BI and other BI, data visualization, and reporting tools.
Business requirement gathering and aligning to solutions delivery.
Experience with data integration solutions and tools, data pipelines, and modern ways of automating data using cloud based and on-premises technologies.
Experience integrating Snowflake with an identity and access management program such as Azure IDP is a plus.
Experience with other relational database management systems, cloud data warehouses and big data platforms is a plus.

Analytical Skills: Excellent problem-solving and analytical skills with strong attention to detail.
Communication: Effective communication skills, both written and verbal, with the ability to convey complex technical information to non-technical stakeholders.
Teamwork: Ability to work independently and collaboratively in a fast-paced environment.

Preferred Skills:

Snowflake certification (e.g., SnowPro Core or Advanced Certification).
Experience with data visualization tools (e.g., Power BI).
Knowledge of technical areas such as T-SQL, DevOps, and scripting.

Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Job Details

Performance Tuning: Monitor and optimize performance, including query performance, resource utilization, and storage management.

User and Access Management: Manage user access, roles, and permissions to ensure data security and compliance with organizational policies.

Data Integration: Support and manage data integration processes, including data loading, transformation, and extraction.

Troubleshooting and Support: Provide technical support and troubleshooting for Snowflake-related issues, including resolving performance bottlenecks and query optimization.

Documentation and Reporting: Maintain detailed documentation of system configurations, procedures, and changes. Generate and deliver regular reports on system performance and usage.

Collaboration: Work closely with data engineers, analysts, and other IT professionals to ensure seamless integration and optimal performance of the Snowflake environment.

Best Practices: Stay up to date with Snowflake best practices and industry trends. Recommend and implement improvements and upgrades to enhance system functionality and performance.

Qualifications and Experience:

5+ years of experience in data architecture, data engineering, or database development.

2+ years of hands-on experience with Snowflake, including data modeling, performance tuning, and security.

At a minimum Bachelor s degree in Computer Science, Information Technology, or related field.

Experience with source control tools (GitHub preferred), ETL/ELT tools and cloud platforms (AWS preferred).

Experience or exposure to AI tools.

Deep understanding of data warehousing concepts, dimensional modeling, and analytics.

Excellent problem-solving and communication skills.

Experience integrating Snowflake with BI and reporting tools is a plus

Required Skills:

Strong proficiency in Snowflake architecture, features, and capabilities.

Knowledge of SQL and Snowflake-specific query optimization.

Experience with ETL tools and data integration processes.

Strong proficiency in SQL and Python.

Strong Database design and data modelling experience. Experience with data modeling tools.

Ability to identify and drive continuous improvements.

Strong problem solving and analytical skills.

Demonstrated process-oriented and strategic thinking skills.

Strong motivation and a desire to continuously learn and grow.

Knowledge of Snowflake security features including access control, authentication, authorization, encryption, masking, secure view, etc.

Experience working in AWS cloud environments.

Experience working with Power BI and other BI, data visualization, and reporting tools.

Business requirement gathering and aligning to solutions delivery.

Experience with data integration solutions and tools, data pipelines, and modern ways of automating data using cloud based and on-premises technologies.

Experience integrating Snowflake with an identity and access management program such as Azure IDP is a plus.

Experience with other relational database management systems, cloud data warehouses and big data platforms is a plus.

Analytical Skills: Excellent problem-solving and analytical skills with strong attention to detail.

Communication: Effective communication skills, both written and verbal, with the ability to convey complex technical information to non-technical stakeholders.

Teamwork: Ability to work independently and collaboratively in a fast-paced environment.

Preferred Skills:

Snowflake certification (e.g., SnowPro Core or Advanced Certification).

Experience with data visualization tools (e.g., Power BI).

Knowledge of technical areas such as T-SQL, DevOps, and scripting.

Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.

Share