Evnek - Snowflake Developer - Data Engineering

Job Role : Senior Data : : Period : Max 30days

Key Responsibilities :

• Design, develop, and optimize DBT models for scalable, maintainable data Architect and implement modern ELT pipelines leveraging DBT and orchestration tools such as Apache Airflow or Prefect.
• Lead query optimization and performance tuning for DBT models on Snowflake, Redshift, or Databricks.
• Integrate DBT workflows and pipelines with AWS services (S3, Lambda, Step Functions, RDS, Glue) and event-driven architectures.
• Build robust ingestion processes from diverse sources, including Manufacturing Execution Systems (MES), manufacturing stations, and web applications.
• Manage and monitor orchestration tools to ensure automated, reliable execution of DBT models.
• Implement CI / CD best practices for DBT, including version control, automated testing, and streamlined deployment workflows.
• Troubleshoot and resolve pipeline issues while optimizing for cost and Skill :
• 5+ years of hands-on DBT experience, including model design, testing, and optimization.
• 8+ years of strong SQL experience, with proven skills in query optimization and database performance tuning.
• 5+ years of programming experience, including custom DBT macros, scripting, APIs, and AWS integrations using boto3.
• 3+ years of experience with orchestration tools like Apache Airflow or Prefect.
• Proven experience with cloud data platforms (Snowflake, Redshift, Databricks, or BigQuery).
• Hands-on knowledge of AWS data services (S3, Lambda, Step Functions, RDS, SQS, CloudWatch).
• Familiarity with serverless architectures and infrastructure as code (CloudFormation, Terraform).
• Strong communication skills with the ability to deliver MVPs aligned with sprint timelines.
• Excellent analytical and problem-solving abilities, with a track record of cross-functional collaboration.

(ref : hirist.tech)