Job Description
Job Description
- Only qualified Snowflake Developer candidates located in the Boston, MA area will be considered due to the position requiring an onsite presence
Required Education :
At a minimum, a bachelor’s degree in computer science, Information Technology, or a related fieldDesired Certification :
Snowflake certification (e.g., SnowPro Core or Advanced Certification)Required Skills :
5+ years of experience in data architecture, data engineering, or database development2+ years of hands-on experience with Snowflake, including data modeling, performance tuning, and securityExperience or exposure to AI toolsDeep understanding of data warehousing concepts, dimensional modeling, and analyticsExcellent problem-solving and communication skillsStrong proficiency in Snowflake architecture, features, and capabilitiesKnowledge of SQL and Snowflake-specific query optimizationExperience with ETL tools and data integration processesStrong proficiency in SQL and PythonStrong Database design and data modelling experience. Experience with data modeling toolsAbility to identify and drive continuous improvementsStrong problem solving and analytical skillsDemonstrated process-oriented and strategic thinking skillsStrong motivation and a desire to continuously learn and growKnowledge of Snowflake security features including access control, authentication, authorization, encryption, masking, secure view, etcExperience working in AWS cloud environmentsExperience working with Power BI and other BI, data visualization, and reporting toolsBusiness requirement gathering and aligning to solutions deliveryExperience with data integration solutions and tools, data pipelines, and modern ways of automating data using cloud based and on-premises technologiesDesired Skills :
Experience integrating Snowflake with an identity and access management program such as Azure IDP is a plusExperience 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 plusExperience with data visualization tools (e.g., Power BI)Experience integrating Snowflake with BI and reporting tools is a plusKnowledge of technical areas such as T-SQL, DevOps, and scriptingClient 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 managementUser and Access Management : Manage user access, roles, and permissions to ensure data security and compliance with organizational policiesData Integration : Support and manage data integration processes, including data loading, transformation, and extractionTroubleshooting and Support : Provide technical support and troubleshooting for Snowflake-related issues, including resolving performance bottlenecks and query optimizationDocumentation and Reporting : Maintain detailed documentation of system configurations, procedures, and changes. Generate and deliver regular reports on system performance and usageCollaboration : Work closely with data engineers, analysts, and other IT professionals to ensure seamless integration and optimal performance of the Snowflake environmentBest Practices : Stay up to date with Snowflake best practices and industry trends. Recommend and implement improvements and upgrades to enhance system functionality and performanceInterview Process : Initial contact by video or in person. Final interview in person, face-to-face