Job Title: Snowflake Developer
Location: Boston, MA 02116
Duration: 12 Months
We are seeking a highly skilled and motivated Snowflake Architect/Developer to join our team. The ideal candidate will bring deep expertise in Snowflake development, data modeling, ETL/ELT processes, and cloud data architecture. This role involves close collaboration with the architecture team to deliver scalable, high-performance data solutions that support analytics, reporting, and business intelligence.
Monitor, analyze, and optimize Snowflake performance, including query tuning, resource utilization, and storage management.
Manage user access, roles, and permissions to ensure data security and compliance.
Support and enhance data integration processes (loading, transformation, and extraction).
Troubleshoot and resolve Snowflake-related issues, including performance bottlenecks and query optimization.
Maintain documentation of system configurations, processes, and changes.
Collaborate with data engineers, analysts, and IT teams to ensure seamless integration of Snowflake with other systems.
Stay updated on Snowflake best practices and recommend improvements to optimize system performance.
Generate regular reports on system performance, utilization, and compliance.
5+ years in data architecture, engineering, or database development.
2+ years hands-on experience with Snowflake, including data modeling, performance tuning, and security.
Bachelor’s degree in Computer Science, IT, or related field.
Proficiency with SQL, Snowflake-specific optimization, and Python.
Strong background in database design, dimensional modeling, and data warehousing concepts.
Hands-on experience with ETL/ELT tools and cloud platforms (AWS preferred).
Familiarity with source control tools (GitHub preferred).
Experience integrating Snowflake with BI/reporting tools (Power BI a plus).
Knowledge of Snowflake security features (access control, masking, encryption, secure views, etc.).
Strong analytical, problem-solving, and communication skills.
Ability to gather business requirements and align solutions to delivery.
Snowflake certification (SnowPro Core or Advanced).
Experience with Power BI or other visualization tools.
Familiarity with DevOps practices, scripting, and automation.
Exposure to AI tools and modern cloud-based automation methods.
Experience integrating Snowflake with IAM programs (Azure IDP preferred).
Knowledge of other relational databases, cloud data warehouses, or big data platforms.