Snowflake Developer

Supersourcing; Oregon (WI); Hybrid; USD 90,000 - 120,000; Full time

Job summary

A leading data solutions provider in the United States is looking for a Snowflake Data Engineer to design, develop, and optimize data warehouse solutions. The successful candidate will collaborate with stakeholders to gather requirements, maintain ETL processes, and ensure data quality. Applicants must have over 6 years of experience with Snowflake and ETL tools, along with strong Python skills. Familiarity with data visualization tools and AWS is preferred. This role offers a dynamic work environment focused on data excellence.

Qualifications

• 6+ years of experience in Snowflake and ETL tools.
• 3+ years of experience in Python programming.
• Hands-on exposure to Unix and Unix shell scripting.
• Experience with Oracle, SQL, PostgreSQL, and Snowflake.
• Strong background in Data Warehousing.

Responsibilities

• Design and optimize Snowflake data warehouse solutions.
• Collaborate to gather data requirements and translate into specifications.
• Develop and maintain ETL processes using Snowflake's features.
• Implement data integration pipelines with a focus on data quality.
• Troubleshoot data-related issues and performance bottlenecks.

Skills

Snowflake

ETL tools (Informatica, DMX)

Data analysis

Python

Unix shell scripting

Oracle

SQL

PostgreSQL

Data Warehousing

AWS cloud stack

Tools

Tableau

Power BI

Job description

• Design, develop, and optimize Snowflake data warehouse solutions to meet business requirements.
• Collaborate with stakeholders to gather and understand data requirements, and translate them into technical specifications.
• Perform data modeling and schema design to ensure efficient and scalable data storage and retrieval.
• Develop and maintain ETL processes using Snowflake's features and capabilities, such as stored procedures, tasks, and streams.
• Implement data integration pipelines to ingest data from various sources into Snowflake, ensuring data quality and integrity.
• Optimize queries and data processing for performance and scalability, utilizing Snowflake's indexing, clustering, and partitioning techniques.
• Troubleshoot and resolve data-related issues, including data quality, data transformation, and performance bottlenecks.
• Collaborate with cross-functional teams, including data engineers, data analysts, and business stakeholders, to deliver high-quality data solutions.
• Stay up-to-date with the latest Snowflake features and best practices, and evaluate their applicability to enhance existing systems.

Requirements

• Must have 6+ yrs. experience in Snowflake, ETL tools like Informatica, DMX and Data analysis
• Must have 3+ yrs. experience in Python
• Hands on exposure into Unix, Unix shell Scripting
• Must have hands on experience in Oracle, SQL, PostgreSQL, Snowflake.
• Must have hands on Data Warehousing
• Experience in Hadoop, Sqoop, Hive will be added advantage.
• Good to have experience in AWS cloud stack with experience in Aws S3 Athena preferred.
• Must understand any scheduling tools like, Autosys, Control-M, Tivoli etc
• Should be able to handle client independently, take up requirements and suggest solution whenever required

Preferred Skills

• Snowflake certification(s).
• Experience with data visualization tools, such as Tableau or Power BI.
• Knowledge of scripting languages like Python or Shell scripting.
• Familiarity with data governance and data security practices.