Sr. Snowflake Developer/Architect

Client: State of MA/DOT; https://www.mass.gov/orgs/massachusetts-department-of-transportation Location: Boston, MA (local candidate to MA/RI/NH) Duration: 12+ month contract Requirements: Please do not share candidates previously submitted to MA DOT/ FACE TO FACE INTERVIEW REQUIRED Title: Sr. Snowflake Developer/Architect Key Skills: Snowflake Developer/Architect, SQL, Python Job Description: 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: o 5+ years of experience in data architecture, data engineering, or database development. o 2+ years of hands-on experience with Snowflake, including data modeling, performance tuning, and security. o At a minimum Bachelor's degree in Computer Science, Information Technology, or related field. o Experience with source control tools (GitHub preferred), ETL/ELT tools and cloud platforms (AWS preferred). o Experience or exposure to AI tools. o Deep understanding of data warehousing concepts, dimensional modeling, and analytics. o Excellent problem-solving and communication skills. o Experience integrating Snowflake with BI and reporting tools is a plus • Required Skills: o Strong proficiency in Snowflake architecture, features, and capabilities. o Knowledge of SQL and Snowflake-specific query optimization. o Experience with ETL tools and data integration processes. o Strong proficiency in SQL and Python. o Strong Database design and data modelling experience. Experience with data modeling tools. o Ability to identify and drive continuous improvements. o Strong problem solving and analytical skills. o Demonstrated process-oriented and strategic thinking skills. o Strong motivation and a desire to continuously learn and grow. o Knowledge of Snowflake security features including access control, authentication, authorization, encryption, masking, secure view, etc. o Experience working in AWS cloud environments. o Experience working with Power BI and other BI, data visualization, and reporting tools. o Business requirement gathering and aligning to solutions delivery. o Experience with data integration solutions and tools, data pipelines, and modern ways of automating data using cloud based and on-premises technologies. o Experience integrating Snowflake with an identity and access management program such as Azure IDP is a plus. o 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. **Note: Please try to keep resume to 2-pages maximum.