Senior Snowflake Engineer

Desired Competencies (Technical/Behavioral Competency)

• 8+ years of experience of analyzing, integrating, modelling, and interpreting large volumes of complex data from multiple sources and technologies
• Minimum of 2+ years of working experience with Snowflake as a cloud Datawarehouse and data lake service
• Experience in advanced snowflake topics like RBAC, Dynamic tables, optimization techniques
• Obvious track record of designing and implementing ELT data pipelines using tools like dbt with Snowflake as Cloud Datawarehouse
• Working experience of building lean and efficient data transformation pipelines using dbt (data build tool) at advanced level
• Exposed to ETL/ELT and data governance tools (incl. FiveTran, Alation)
• Strong technical proficiency in SQL, data modelling and data warehousing in a variety of database technologies
• Working experience in cloud
• Ability to present and communicate to varied users (technical and non-technical)
• Inept understanding of orchestration using Apache Airflow or MWAA and CI/CD pipelines
• Demonstrable career history working with and delivering high volume Data Warehousing solutions is essential

Good to have Skills

• You are comfortable being responsible for continuous deployment, operation, and monitoring of your data solutions and their infrastructure. Preferred CI/CD toolkit: Terraform, GitHub Actions
• Airline Industry domain experience
• Adaption to Agile Methodology

Role & responsibilities

• Place a heavy focus on building their future state Data Warehouse capabilities in cutting edge technologies
• Analyze, adjust, and adapt their data pipeline as data, models and requirements evolve, always providing your expertise and insights along the journey
• Write, test, and validate data transformation and ETL routines with dbt, Snowflake and Airflow