Data Ingestion & SnapLogic Development Design, develop, and maintain enterprise-grade pipelines in SnapLogic to extract data from REST/SOAP APIs and various source systems. Build scalable ingestion pipelines to load structured and semi-structured data into Snowflake. Implement production-standard, reusable SnapLogic jobs featuring robust error handling, monitoring, and performance optimization (e.g., caching, parallel processing). 2. Data Modeling & dbt (Data Build Tool) Hands-on experience designing and building modular dbt transformation models on top of Snowflake data. Write complex, optimized SQL queries and transformations to create analytics-ready datasets. Implement data quality checks, testing, and documentation using native dbt features. 3. Workflow Orchestration & Scheduling Utilize Apache Airflow to orchestrate and schedule end-to-end data workflows. Manage job dependencies, monitor pipeline execution, and design Directed Acyclic Graphs (DAGs) to trigger SnapLogic and dbt jobs seamlessly. Qualifications & Skills Experience 7+ years of total IT experience, with at least 5 years strictly dedicated to building and managing ETL/ELT data pipelines. SnapLogic Deep, end-to-end expertise in SnapLogic iPaaS, configuring Snaps, Ultra Tasks, and building complex custom pipelines. Snowflake Extensive understanding of Snowflake architecture, schema design, clustering, and writing performance-tuned SnowSQL. dbt Hands-on commercial experience developing models, macros, and running dbt in high-volume, production-grade environments. Airflow Strong command of Airflow for workflow management, DAG creation, and resolving job failures. Scripting Proficiency in Python and advanced ANSI-SQL to support custom scripts and complex transformations.