Snowflake Engineer

Our client is looking for a Data Engineer who can provide production support to our existing and future ETL environments. The candidate must possess strong technical expertise in Snowflake, data warehousing methodologies like Data Vault 2.0.

• Manage the full lifecycle of Snowflake data operations, including monitoring, troubleshooting, and optimizing data pipelines.

• Design, develop, and optimize Snowflake data pipelines and models.

• Recommend and implement best practices for data ingestion, transformation, storage, security and data modeling.

• Support advanced features like Change Data Capture (CDC) and Slowly Changing Dimensions (SCD Type 2).

• Support frameworks like Data Vault and dimensional modeling in Snowflake.

• Provide production support for IBM DB2, Snowflake, and orchestration tools (Airflow, ESP).

• On-call and/or after-hours work required.

Skills Qualifications

• Minimum of 5 years of relevant experience in data warehousing, business intelligence tools, and data analysis.

• Minimum of 3 years of SQL query development across multiple database platforms (Snowflake, Oracle, SQL Server, DB2).

• Strong expertise in Snowflake (development, data modeling, security). Snowflake certification preferred.

• Strong proficiency in SQL and scripting languages (e.g., Python, Shell).

• Familiarity with orchestration tools (ESP, Airflow) and version control systems (Git).

• Experience with incident management tools (e.g., ServiceNow, Jira) and CI/CD practices.

• Solid understanding of data architecture, dimensional modeling, and frameworks like Data Vault.