data engineer

$97,760 - $115,440/Yr

Randstad - Boston, MA

posted about 2 months ago

Full-time - Mid Level
Boston, MA
Administrative and Support Services

About the position

The Data Engineer position is a contract role based in Boston, Massachusetts, requiring onsite work from the start of the project. The ideal candidate will have a minimum of 6 to 9 years of IT experience, specifically in data warehousing and ETL processes, with at least 3 years of hands-on experience using Snowflake. The role demands strong programming skills in Snowflake, Snow SQL, and Snowpipe, as well as proficiency in Azure Data Lake Storage (ADLS) and Azure Data Factory (ADF) for data processing. Candidates should also be familiar with handling semi-structured data formats such as XML and JSON within Snowflake, and have experience with Snowflake's features including Stages, Streams, Tasks, and External Tables. In addition to technical skills, the position requires a solid understanding of Role-Based Access Control (RBAC) and experience in creating Snowflake Procedures and User Defined Functions (UDFs). Query optimization techniques and advanced SQL skills are essential for this role. While a degree is not required, candidates must demonstrate their expertise through relevant work experience. The work hours are from 8 AM to 4 PM, and the pay range for this position is between $47.00 and $55.50 per hour, depending on the candidate's qualifications and experience.

Responsibilities

  • Develop and maintain data warehousing solutions using Snowflake.
  • Implement ETL processes to ensure data is accurately processed and stored.
  • Handle semi-structured data formats such as XML and JSON in Snowflake.
  • Create and manage Snowflake Procedures and User Defined Functions (UDFs).
  • Optimize SQL queries for performance improvements.
  • Utilize Azure Data Lake Storage (ADLS) and Azure Data Factory (ADF) for data processing.
  • Implement Role-Based Access Control (RBAC) for data security.
  • Work with Snowflake features including Stages, Streams, Tasks, and External Tables.

Requirements

  • Minimum of 6 to 9 years of IT experience in Data warehousing ETL.
  • At least 3 years of experience in Snowflake.
  • Strong programming skills in Snowflake, Snow SQL, and Snowpipe.
  • Good work experience in ADLS and ADF for data processing in Azure cloud.
  • Experience in handling semi-structured XML and JSON data in Snowflake.
  • Experience with Stages, Streams, Tasks, and External Tables in Snowflake.
  • Understanding of Role-Based Access Control (RBAC).
  • Experience in creating Snowflake Procedures and UDFs.
  • Experience in Query Optimization techniques.
  • Strong experience in SQL and advanced SQL.

Nice-to-haves

  • Experience in Azure Storage concepts.

Benefits

  • Health insurance
  • Incentive and recognition program
  • 401K contribution
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service