Snowflake Data Engineer

A career as a Snowflake Engineer at Accelirate means being a critical part of successful data outcomes. Here, your work can accelerate solutions for our clients while you accelerate your career. Own the opportunity to provide our clients with the data they need to turn insights and ideas into action.

Job Description/ Main Responsibilities

• Design and implement cloud data warehouses using Snowflake.
• Design complete data analytics stack and workflow, from ETL to data platform design to BI and analytics tools
• Create As-Is analysis and requirements based on existing databases, data warehouses, and data processing.
• Create integration and configuration scripts using a combination of SQL, SQL analytics, Python, Ruby, Perl, or Bash
• Apply knowledge of and experience with large-scale database technology (e.g., Netezza, Exadata, Teradata, Greenplum, etc.) to design of data lake and Snowflake architecture
• Design, and implement data pipelines using a variety of tools including non-relational platforms and tools for large-scale data processing (e.g., Hadoop, HBase) native tools of large-scale infrastructure-as-a-service platforms (e.g., Amazon AWS, Microsoft Azure, Google Cloud Platform) common off shelf (COTS) packaged tools.
• Deploy Snowflake deployment best practices.
• Develop complex data models in Snowflake Tune and Troubleshoot Snowflake for performance and optimize utilization.
• Provide guidance on how to resolve customer-specific technical challenges.
• Build, design, architect, and implement high-volume, high-scale data analytics and machine-learning Snowflake solutions in the cloud.
• Provide technology leadership in driving large complex Snowflake implementations.
• Implement, monitor & maintain complex Snowflake solutions.
• Implementing ETL pipelines within and outside of a data warehouse using Python and Snowflakes Snow SQL
• Querying Snowflake using Snow SQL.
• Development of scripts using Unix, Python, etc. for loading, extracting, and transforming data.
• Knowledge of Amazon Web Services Redshift
• Assist with production issues in Data Warehouses like reloading data, transformations, and translations.
• Develop a Database Design and Reporting Design based on Business Intelligence and Reporting requirements.

Required Experience

• Two or more years of experience with data engineering, data lake/ data warehouse design.

Technical Skills

• Must understand common challenges and corresponding solutions that accompany a data lake/data warehouse implementation.
• The ability to design, implement, and optimize large-scale data and analytics solutions on Snowflake Cloud Data Warehouse is essential.
• Preferred Technical Skills:
• Skilled at Implementing ETL pipelines within and outside of a data warehouse using Python and Snowflakes Snow SQL
• Querying Snowflake using SQL.
• Development of scripts using Unix, Python, etc. for loading, extracting, and transforming data.
• Knowledge of Amazon Web Services Redshift