Snowflake Architect

You will design and implement data architectures centered on the Snowflake platform.

Responsibilities

• Develop scripts using Python and Unix for extract, load, and transform (ELT/ETL) processes.
• Execute data migrations using flat files and manage the ingestion process.
• Write and optimize complex SQL queries for performance within the Snowflake environment.
• Perform data validation and unit testing to ensure data integrity.
• Support job scheduling, monitoring, and reconciliation processes.

Required Skills

• 5+ years of experience in data warehousing and ETL architecture.
• Deep expertise in Snowflake utilities including SnowSQL, SnowPipe, Tasks, Streams, and Time Travel.
• Advanced SQL proficiency with experience in performance tuning.
• Strong Python scripting skills for data manipulation.
• Experience with DBT for transformation workflows.
• Hands-on knowledge of RDBMS platforms such as AWS Redshift, Postgres, Oracle, or SQL Server.
• Familiarity with data modeling including star schemas, 3NF, and entity relationship diagrams.
• Proficiency with GitHub and Jenkins for version control and CI/CD.
• Experience working within Agile delivery frameworks.

Preferred Skills

• Experience with Snowflake Optimizer and Metadata Manager.
• Knowledge of data sharing and stored procedures.