Onix Datametica Is Hiring Snowflake DW Engineers....!!!

Job Summary

We are seeking a skilled Data Engineer with strong expertise in Snowflake and Data Warehouse (DW) architecture to design, develop, and optimize scalable data pipelines and analytical solutions. The ideal candidate will have hands-on experience with modern cloud data platforms, ETL/ELT processes, and performance tuning in Snowflake.

Key Responsibilities

• Design, build, and maintain high-performance data pipelines and ELT workflows using Snowflake.
  
• Develop and optimize Snowflake objects including databases, schemas, tables, tasks, streams, stages, and views.
  
• Implement data warehousing solutions following best practices in dimensional modeling (Kimball/Inmon).
  
• Build scalable data integration solutions using tools like Informatica, dbt, Matillion, Airflow, or Azure Data Factory (customize as needed).
  
• Optimize Snowflake compute usage, query performance, and storage through clustering, micro-partitioning, caching, and resource monitoring.
  
• Perform data profiling, data quality checks, and implement governance/security controls.
  
• Collaborate with data analysts, data scientists, and business stakeholders to deliver clean, reliable data.
  
• Automate workflows and CI/CD for data pipelines.
  
• Monitor datasets for freshness, accuracy, and performance.
  

Required Skills

• Strong hands-on experience with Snowflake (Warehouses, Virtual Warehouses, Streams, Tasks, Time Travel, Cloning, Staging, Role-Based Access Control).
  
• Expertise in SQL (advanced level) and performance tuning.
  
• Solid understanding of Data Warehouse concepts, star-schema modeling, and ETL/ELT frameworks.
  
• Experience with at least one orchestration or ETL tool (e.g., dbt, Airflow, Informatica, Matillion, ADF, Talend).
  
• Proficiency in Python or Java/Scala for data transformation (optional).
  
• Experience working with cloud environments (AWS / Azure / GCP).
  
• Knowledge of CI/CD, Git, and DevOps best practices.
  

Preferred Qualifications

• Snowflake SnowPro Core or Advanced certification.
  
• Experience with real-time/streaming pipelines (Kafka, Kinesis, Pub/Sub).
  
• Exposure to BI tools like Tableau, Power BI, Looker, or ThoughtSpot.
  
• Understanding of data governance, lineage, and catalog tools (Collibra, Atlan, Alation).
  

Education

• Bachelors or Master’s degree in Computer Science, Information Systems, Engineering, or related fields.