Senior data engineering with Snowflake

Senior Snowflake Developer
Boston, MA (Hybrid ( 3 Days Onsite per week ) ( 3 round Interviews, 1 onsite interview out of 3 rounds - 1 onsite round is mandatory, no exceptions )
Long term
LOCALS ONLY within MA state

14+ years of candidates only, Must have excellent communication skills***

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

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.