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
