Snowflake Data Engineer

Description

Department:                          Sales and Delivery Team - Empower

Industry:                                 Information Technology & Services, Computer Software, Management Consulting

Location:                                 WFH/ India Remote

Experience Range:                6 - 10 years

Basic Qualification:               Bachelor of Engineering or Equivalent

Travel Requirements:           Not required

Website:                                 www.exusia.com

Exusia, a cutting-edge digital transformation consultancy, and is looking for top talent in DWH & Data Engineering space with specific skills in Snowflake/Python/DBT to join our global delivery team's Industry Analytics practice in India.

What’s the Role?

·        Full-time job to work with Exusia's clients in the United States to deliver on bleeding-edge data-driven solutions

·        Developing and managing large scale data pipelines and data repositories

·        Collaborate with Product Owners, Solution Architects to develop optimized data engineering solutions.

Criteria for the Role!

·        Minimum 6 years of experience working as a Data engineer

·        Min 2 years exp in Snowflake and DBT

·        Master of Science (preferably in Computer and Information Sciences or Business Information Technology) or an Engineering degree in the above areas.

·        Excellent communication skills and should be able to work directly with business stakeholders, creative problem solver, flexible, proactive, attitude to learn newer tools/technologies

Responsibilities

·      Implementing end to end data pipelines to move data from source systems into data lake or data warehouse

·      Build pipeline automation and orchestration process

·      Develop Snowflake data models (e.g., star schema, snowflake schema) for optimized query performance.

·      Working with Data Analysts to ensure the pipelines are tested and optimised to provide accurate and timely data

·      Working in an agile software delivery model and manage changing requirements and priorities during the SDLC 

Requirements

Mandatory Skills

·      Develop and maintain Snowflake data models (e.g., star schema, snowflake schema) for optimized query performance.

·      Create and maintain Snowpipe & SnowSQL scripts for data loading, data transformations, and data retrieval.

·      Proficiency in SQL for data manipulation, transformation, and processing.

·      Expertise in DBT to develop modular, scalable, and well-documented data pipelines.

·      Strong python programming experience to support data processing and automation.

·      Hands-on experience with Airflow for orchestrating data pipelines

·      Knowledge of cloud platforms specifically storage and databases to source or stage data for Snowflake

·      Problem-solving skills with the ability to work with large datasets and debug data pipeline issues.

Nice to have skills

·      Understanding of Data Modeling & legacy ETL technologies

·      Prior migration experience - On Prem legacy databases to snowflake

·      Knowledge of Spark / Spark based data processing tools

·      Exposure to one or more Cloud platforms – Amazon Web Services (AWS), Microsoft Azure, Google Cloud Platform

·      Exposure to Data Governance aspects like Metadata Management, Data Dictionary, Data Glossary, Data Lineage