Data Ingestion Engineer (ADF+Dbt+Snowflake)
Core
Build and maintain scalable, reliable, and secure data pipelines to power analytics, reporting, and decision-making across the organization.
Role type
Data Ingestion Engineer
Builds
Scalable data ingestion pipelines and ELT workflows for analytics and reporting
Domain
Cloud data platforms (Snowflake, Azure) and data engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Snowflake (Snowpipe, Snowpipe Streaming, Snow Tasks, Snow Streams), Azure Data Factory (ADF), Python, SQL, dbt, PostgreSQL, data modeling (star/snowflake schemas), Git
Preferred skills
API integration, handling large data files (CSV, JSON, XML), Azure Blob Storage/Data Lake, cloud data platforms (AWS, GCP), data governance and lineage tools
Technologies
Snowflake, Azure Data Factory, dbt, Python, PostgreSQL, Snowpipe, Snowpipe Streaming, Snow Tasks, Snow Streams
Responsibilities
Design and develop Snowflake-native data ingestion pipelines; Build automated batch and near-real-time data loading processes; Implement ELT workflows; Integrate ADF with Snowflake for orchestration; Develop Python scripts for ingestion, validation, and automation; Ingest data from APIs, databases, files, and cloud storage; Monitor and optimize pipeline performance; Implement data quality checks, logging, and alerting; Maintain technical documentation
Seniority
Mid-Senior, hands-on IC
