Senior Snowflake Developer

ARV-Infotech; Boston (MA); On-site; USD 150,000 - 210,000; Full time

Job summary

ARV-Infotech is seeking an experienced Snowflake Architect/Developer to design, develop, and optimize secure, high-performance data solutions. The role requires deep Snowflake expertise, SQL, Python, data modeling, and cloud data architecture.

You will monitor performance, manage access controls, and build scalable ETL/ELT pipelines while collaborating with data engineers, analysts, and business teams. Responsibilities include integrating Snowflake with AWS and Power BI, maintaining

Qualifications

• 14+ years of IT experience.
• Strong Snowflake architecture and development.
• Excellent SQL, Python and query optimization skills.
• Experience with ETL/ELT and data integration.
• Strong data warehousing and dimensional modeling knowledge.
• Snowflake security, access control, encryption, and data masking.
• AWS cloud experience.
• GitHub or other version control experience.
• Power BI and other reporting tools.
• Database design and data modeling tools.
• Strong analytical, problem-solving, and communication skills.
• Ability to explain technical concepts clearly to business stakeholders.
• Bachelor’s degree in Computer Science, Information Technology, or a related field.

Responsibilities

• Monitor and optimize Snowflake performance, queries, and storage.
• Manage user access, roles, permissions, and data security.
• Develop and maintain data pipelines for data loading and transformation.
• Troubleshoot technical issues and improve query performance.
• Design database structures and data models.
• Maintain technical documentation and performance reports.
• Work with data engineers, analysts, and business teams.
• Integrate Snowflake with AWS, Power BI, and other reporting tools.
• Recommend improvements and follow Snowflake best practices.
• Gather business requirements and deliver scalable data solutions.

Skills

Snowflake architecture

SQL

Python

ETL/ELT

Data warehousing

Dimensional modeling

Snowflake security

AWS

GitHub

Power BI

Data modeling tools

Communication skills

Stakeholder communication

Bachelor’s degree

Education

Bachelor’s degree in Computer Science / IT / related field

Tools

GitHub

Power BI

Data modeling tools

Job description

Job Overview

We are looking for an experienced Snowflake Architect/Developer to design, develop, and optimize secure, high-performance data solutions. The candidate should have strong expertise in Snowflake, SQL, Python, data modeling, ETL/ELT, and cloud data architecture.

Key Responsibilities

• Monitor and optimize Snowflake performance, queries, and storage.

• Manage user access, roles, permissions, and data security.

• Develop and maintain data pipelines for data loading and transformation.

• Troubleshoot technical issues and improve query performance.

• Design database structures and data models.

• Maintain technical documentation and performance reports.

• Work with data engineers, analysts, and business teams.

• Integrate Snowflake with AWS, Power BI, and other reporting tools.

• Recommend improvements and follow Snowflake best practices.

• Gather business requirements and deliver scalable data solutions.

Required Skills

• 14+ years of overall IT experience.

• Strong hands-on experience with Snowflake architecture and development.

• Excellent knowledge of SQL, Python, and query optimization.

• Experience with ETL/ELT tools and data integration.

• Strong understanding of data warehousing and dimensional modeling.

• Knowledge of Snowflake security, access control, encryption, and data masking.

• Experience with AWS cloud services.

• Experience with GitHub or other version control tools.

• Knowledge of Power BI and other reporting tools.

• Experience with database design and data modeling tools.

• Strong analytical, problem-solving, and communication skills.

• Ability to explain technical concepts clearly to business stakeholders.

• Bachelor’s degree in Computer Science, Information Technology, or a related field.

Preferred Skills

• Snowflake certification (SnowPro Core or Advanced).

• Experience with AI tools and Azure identity integration.

• Knowledge of T-SQL, DevOps, and scripting.

• Experience with other databases and cloud data platforms.

Ideal Candidate:

A senior technical professional with strong Snowflake expertise, excellent communication skills, and the ability to lead data architecture and development initiatives.