Snowflake Data Engineer

Trillium Staffing • Boston, MA

432d • $174,720 - $174,720

About The Position

The Snowflake Data Engineer will be responsible for designing, developing, and maintaining complex Snowflake data warehouses, ensuring data integrity, quality, and security. This role involves collaborating with stakeholders to meet data requirements, optimizing data warehouse performance, and providing technical guidance to junior team members.

Requirements

• 8+ years of experience in Snowflake data warehouse development and management, data engineering field.
• Strong understanding of Snowflake architecture, data modeling, and data warehousing concepts.
• Proficiency with SQL, including Snowflake's SQL dialect and complex query writing for performance optimization.
• Experience with Snowflake features, including cloning, time travel, data sharing, and micro-partitioning.
• Expertise in Snowflake Role-Based Access Control (RBAC), data masking, and encryption.
• Proficiency with data integration tools and ETL/ELT processes.
• Experience in Python or similar scripting languages for automation and data processing.
• Knowledge of data security and compliance standards as they relate to Snowflake.
• Experience with cloud platforms like AWS, Azure.

Nice To Haves

• SnowPro Advanced certification is a plus.
• Knowledge of data governance frameworks and tools.
• Strong experience integrating Snowflake with Tableau, Salesforce, third party APIs etc.
• SnowPro Advanced Architect or SnowPro Data Engineering certification is preferred.
• Experience in building complex data pipelines in a multi-cloud environment.
• Experience implementing data masking, and aggregation to reduce privacy risks.
• Experience integrating data from Salesforce solutions.
• Knowledge of CI/CD practices and tools.
• Familiarity with JIRA or other project management tools.
• Experience using GitHub.
• Experience working on projects in the affordable housing sector or other public benefit programs.
• Familiarity with a variety of software development methodologies such as agile, waterfall.

Responsibilities

• Design, develop, and maintain complex Snowflake data warehouses, including data modeling, ETL processes, and data quality control.
• Ensure data integrity, quality, and security across all data warehousing activities.
• Develop and maintain data pipelines to integrate data from various internal and external sources.
• Write Python code to automate data processing, transformation, and loading tasks, including data ingestion, data quality control, and data visualization.
• Collaborate with data analysts and business stakeholders to understand data requirements and develop data solutions that meet business needs.
• Develop and maintain data visualizations and reports using Snowflake's built-in visualization tools or third-party tools like Tableau.
• Optimize Snowflake data warehouse performance, scalability, and reliability, including monitoring and troubleshooting data issues.
• Develop and maintain technical documentation, including data dictionary, data flow diagrams, and code comments.
• Participate in code reviews and provide feedback to ensure high-quality code and adherence to coding standards.
• Communicate complex data findings to non-technical stakeholders in a clear and concise manner.
• Provide technical guidance and mentorship to junior analysts and other team members.

Benefits

• Pay rate of $84 per hour

What This Job Offers

• Job Type: Full-time
• Industry: Administrative and Support Services
• Education Level: No Education Listed