Snowflake Data Engineer at Rose International

Date Posted: 01/27/2025

Hiring Organization: Rose International

Position Number: 477184

Job Title: Snowflake Data Engineer

Job Location: Boston, MA, USA, 02114

Work Model: Hybrid

Shift: 1 day per week in office preferably Tuesday

Employment Type: Temporary

Estimated Duration (In months): 13

Min Hourly Rate ($): 65.00

Max Hourly Rate ($): 75.00

Must Have Skills/Attributes: AWS, Azure, Data Warehouse, GitHub, Snowflake, SQL

Job Description

***Only qualified Snowflake Data Engineer candidates located in the Boston, MA area to be considered due to the position requiring an onsite presence***

Desired Certifications:

• Snow Pro Advanced certification is a plus

• Snow Pro Advanced Architect or Snow Pro Data Engineering certification is preferred

Required Skills:

• 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

• Strong understanding of Snowflake’s architecture, including virtual warehouses, storage, and compute separation

• 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 Snowflak

• Experience with cloud platforms like AWS, Azure

• Knowledge of data governance frameworks and tools

• Strong experience integrating Snowflake with Tableau, Salesforce, third party APIs etc

• Strong analytical, problem-solving, and communication skills

• Ability to work collaboratively in a cross-functional team environment

• Excellent verbal and written communication skills with project teams and business teams

• Team-oriented attitude and the proven ability to collaborate at all levels of an organization

Desired Skills:

• Experience in building complex data pipelines in an 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 JIRA or other project management tools

• Experience using GitHub

• Experience working on projects in the affordable housing sector or other public benefit programs

Client is looking for an experienced Snowflake Data Engineer to lead the implementation of Division of Housing Stabilization data in our new Snowflake data warehouse. The Snowflake Data Engineer plays a critical role in designing, building, and supporting the components of the agency’s data warehouse. This position involves working with various stakeholders to ensure accurate and efficient data management, reporting, and analytics

Snowflake Data Engineer Duties and 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

• Develop and maintain data pipelines using tools for data transformation, testing, and deployment

• Ensure data pipelines are scalable, reliable, and efficient

• 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

• Ensure data quality, integrity, and security by developing data validation rules, data cleansing processes, and data access controls

• 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

• Work closely with the agency’s data team and the overall state technology team to ensure alignment on data strategy and technology 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

**Only those lawfully authorized to work in the designated country associated with the position will be considered. **

**Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements. **

Benefits:

For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.

California Pay Equity:

For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.