Data Engineer

Data Engineer responsible for designing, developing, and maintaining scalable ETL/ELT pipelines to ingest, transform, and load data into Snowflake. Build and manage data ingestion workflows using Azure Data Factory, Python, SQL, and related tools; develop robust data transformation processes ensuring data quality and consistency across systems. Optimize Snowflake performance with techniques like clustering, partition pruning, materialized views, and warehouse tuning. Design logical/physical data models, including dimensional models (star/snowflake schemas) for BI and analytics. Collaborate with cross-functional teams to translate data requirements into scalable solutions; implement data governance, auditing, and validation; troubleshoot pipeline issues; maintain technical documentation; pursue automation and optimization opportunities. Familiarity with Agile practices and ability to communicate complex concepts to technical and non-technical stakeholders.