Role: Senior Snowflake Developer 

Boston, MA, 02115

Description

15 + Years of Experience with MassDOT Technology division is seeking a highly skilled, experienced and motivated Snowflake Architect/Developer to join our 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