Only qualified Snowflake Developer candidates located in the Boston, MA area will be considered due to the position requiring an onsite presenceRequired Education :
- At a minimum, a bachelor’s degree in computer science, Information Technology, or a related field
Desired Certification :
- Snowflake certification (e.g., SnowPro Core or Advanced Certification)
Required Skills :
- 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
- Experience or exposure to AI tools
- Deep understanding of data warehousing concepts, dimensional modeling, and analytics
- Excellent problem-solving and communication 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
Desired Skills :
- Experience integrating Snowflake with an identity and access management program such as Azure IDP is a plus
- Experience with source control tools (GitHub preferred), ETL / ELT tools and cloud platforms (AWS preferred)
- Experience with other relational database management systems, cloud data warehouses and big data platforms is a plus
- Experience with data visualization tools (e.g., Power BI)
- Experience integrating Snowflake with BI and reporting tools is a plus
- Knowledge of technical areas such as T-SQL, DevOps, and scripting
Client 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 the 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
Job 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
Interview Process : Initial contact by video or in person. Final interview in person, face-to-face