Snowflake Data engineer

Date Posted: 12/13/2024

Hiring Organization: Rose International

Position Number: 475620

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 ($): 75.00

Max Hourly Rate ($): 88.00

Must Have Skills/Attributes: AWS, Azure, ETL, GitHub, JIRA, Snowflake, SQL

***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 Snowflake.

• 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

• Familiarity with a variety of software development methodologies such as agile, waterfall, and a strong understanding of the suitability of these methodologies for certain development environments and types of applications

• Experience with advanced Microsoft Office, pivot tables, charts, Visio, data analytics and JIRA or other project management tools

• Experience with SQL a plus

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.

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.